A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How does one "check the file permissions for the document"? by lorraine
I saved a document. When I tried to retrieve it the message said "check the file permissions for the document.." I don't know how to do this and as a...
February 16th, 2007 11:33 PM
by Van T. Dinh Go to last post
3 112
query issues - critera being ignored by Dave
All, Found some similar posts, but didn't help my sitaution. Any help would be appreciated. I've got the following in query design view. The function...
February 16th, 2007 10:55 PM
by Dave Go to last post
4 100
Delimiting Field Containing - Character by [email protected]
I need to turn the following types of number strings into a date field: 03-1-12345 98-12-12345 Where, the strings would represent: January 2003 December 1998
February 16th, 2007 10:08 PM
by John Spencer Go to last post
1 94
Calculating total days minus overlapp by [email protected]
Hello, I have to create a query which will return the total # days a file has been checked out. The table is set up for two "checkouts" that can occur in...
February 16th, 2007 09:39 PM
by John Spencer Go to last post
4 102
Delimiting Field Containing - Character by [email protected]
I need to turn the following types of number strings into a date field: 03-1-12345 98-12-12345 Where, the strings would represent: January 2003 December 1998
February 16th, 2007 09:21 PM
by [email protected] Go to last post
0 94
Miles per Gallon Report by pbielawski
Hi I am using Access 2002 on XP Pro. I have a database that tracks our fuel usage. One table, tblTransactions, has transaction data in it; fldDate,...
February 16th, 2007 09:20 PM
by babyatx13 via AccessMonster.com Go to last post
3 113
UTC and Now() function by techgeek1234
I am familiar with the "GetSystemTime" function for VB Access. However, I need to use UTC for a query parameter. I have a database in which all date and time...
February 16th, 2007 09:09 PM
by John Nurick Go to last post
5 177
week day query by Joel Allen
Hi, I'm trying to do a simple calculation of the number of weekdays between two dates. This what I have in my query, but it's not working. Seems so...
February 16th, 2007 09:07 PM
by KARL DEWEY Go to last post
2 118
Using a combination of IIF, INSTR and LEFT by MB
I have a table of about 25 fields. Field19 is a column of Last Names, but some of the records have extra text in it. This extra text begins with a "/". I...
February 16th, 2007 09:06 PM
by MB Go to last post
2 106
Changing color or adding a value based on a field value by Paul
I am trying to report on login/logouts from a system and have a question. 4 fields that matter: login_time Unix time the user logged in...
February 16th, 2007 09:03 PM
by Paul Go to last post
0 96
Queries by steven
I need to make a query that finds all the names that start with the letter S. I need help. -- Steven
February 16th, 2007 08:39 PM
by KARL DEWEY Go to last post
1 102
Random Sample Within Parameters by Don
Hoping someone can help. I have reviewed many postings on drawing a random sample and have looked at several web pages, but the postings all assume a higher...
February 16th, 2007 08:38 PM
by KARL DEWEY Go to last post
1 121
Frustrated...Can somebody tell me how to turn on a feature? by Chris E.
When you're in the queries tab and you hover the mouse pointer over a make table or append query, a little window (I don't know what you call it) will come...
February 16th, 2007 07:52 PM
by Joel Allen Go to last post
1 105
Format Field in Make Table Query by Claudette Hennessy
I know field formats are not inherited in a Make Table Query. Here is the query. SELECT DISTINCT tblDealer.DealerFirstName, tblDealer.DealerLastName,...
February 16th, 2007 07:01 PM
by Claudette Hennessy Go to last post
2 119
Remove Zeroes in front of a number - help! by gholly
hoping someone can help me figure this out. i'm not sure how i would need to do this. basically i have 2 different tables with what should be the same...
February 16th, 2007 06:59 PM
by fredg Go to last post
3 105
Seperating Email Addresses using a Query by dwalsh77
I have 1 table called Customers which has many fields, inlcuding an EmailAddress field. I query the table so that it returns all the email addresses and...
February 16th, 2007 06:55 PM
by KARL DEWEY Go to last post
1 122
date field by month in query but want only one year by Sue R via AccessMonster.com
I have a query that reads the date field by month and shows the results by each month for every year. I want it to display only the results from one year,...
February 16th, 2007 06:48 PM
by fredg Go to last post
1 109
Finding First salesperson by Jordan_n22 via AccessMonster.com
Hello, I am trying to create a report that will show me the first salesperson for each of our clients. I have two table that are related by ID. One table...
February 16th, 2007 06:24 PM
by Jordan_n22 via AccessMonster.com Go to last post
2 127
Switch Function by twen
Prefix: Switch(IsNull() Or ="", & " " & ,=1,"Mr.",=2,"Mrs.", =3,"Ms.",=4,"Miss",=5,"Mr. & Mrs.", & " " & ) Will that work in a query if I have 1,2,3,4,5...
February 16th, 2007 06:21 PM
by Marshall Barton Go to last post
3 111
Top 5 with grouping by AirgasRob
I am trying to get the top 5 results for each region. Any help would be appreciatted, below is my sql thus far. SELECT TOP 5 QryNullConv.AbsError,...
February 16th, 2007 06:16 PM
by John Spencer Go to last post
1 114
Post New Thread


Display Options
Showing threads 20061 to 20080 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.