|
|
|
|
3 |
144 |
|
|
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 09:55 PM
by Dave
|
4 |
152 |
|
|
|
|
1 |
139 |
|
|
|
|
4 |
245 |
|
|
|
|
0 |
114 |
|
|
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,...
|
|
3 |
182 |
|
|
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...
|
|
5 |
320 |
|
|
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...
|
|
2 |
163 |
|
|
|
February 16th, 2007 08:06 PM
by MB
|
2 |
144 |
|
|
|
February 16th, 2007 08:03 PM
by Paul
|
0 |
132 |
|
|
Queries by
steven
I need to make a query that finds all the names that start with the letter S.
I need help.
--
Steven
|
|
1 |
148 |
|
|
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...
|
|
1 |
161 |
|
|
|
|
1 |
140 |
|
|
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,...
|
|
2 |
150 |
|
|
|
February 16th, 2007 05:59 PM
by fredg
|
3 |
142 |
|
|
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...
|
|
1 |
162 |
|
|
|
February 16th, 2007 05:48 PM
by fredg
|
1 |
202 |
|
|
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...
|
|
2 |
243 |
|
|
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...
|
|
3 |
143 |
|
|
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,...
|
|
1 |
143 |