|
|
"Effective Date" Criteria for Rates by
Jason V
I have been stuck on this for some time now. I will try to make it as clear
as I can.
I need to create a Report of “transactions” (days worked of...
( 1 2)
|
October 25th, 2005 11:00 PM
by Jason V
|
13 |
1,300 |
|
|
Query in a query by
PPerry
I have a query (thanks to this group) which returns the very last date in a sequence. This query works great. I now want to use it in another query where I...
|
|
1 |
1,299 |
|
|
|
August 24th, 2004 09:55 AM
by Franky
|
15 |
1,297 |
|
|
Flag a value in a group... by
Jack Leach
Hi all, tia for any insight.
I have the following query that gives some totals for qty's in a releases
table, pulling and grouping information (part number,...
|
|
4 |
1,287 |
|
|
|
|
4 |
1,275 |
|
|
Query Form: Print Report by
Dennis
I have a query form that has three query criteria fields.
The first field is a diagnoses, the second is the first
unit and the third is the second unit. First...
|
|
1 |
1,264 |
|
|
sql union self-join syntax by
SillySally
Hi. I can't seem to get my syntax correct. I hope the
first part of the union query will give me everyone with a
SignificantOtherID (avoiding duplicates) and...
( 1 2 3)
|
|
27 |
1,260 |
|
|
SQL subsets by
Stacy in Savannah
I have a set of Permitees 12,000+, who own one or more items 58,908 of a list
of 29 items. Some Permitees are only allow to own 3 of these 29 items,
others...
( 1 2)
|
|
15 |
1,252 |
|
|
JOIN Query very slow by
Tally.NET
Hello,
I have the following Input tables
Table1
Serial Item Date SerialandDate
123 Item1 01-04-2007 12339173
123 Item2 01-06-2010...
|
|
4 |
1,250 |
|
|
|
July 30th, 2004 09:05 PM
by Dkline
|
5 |
1,250 |
|
|
Semicolon delimited text query help by
Al Guerra
I did not design this. I have two tables, table A has a field "Link"
that is of type string and contains a unique 30 character string (700
hundred of them)....
|
|
3 |
1,243 |
|
|
SELECT function in Query by
alexparks
I am entering this following command in a query and I am
getting the following warning:
"The syntax of the subquery in this expression in
incorrect. Check...
|
|
9 |
1,241 |
|
|
query a number stored as text by
Lee
I have a part number field that had to be defined as text due to the make up
of the part numbers. I need to query for a number and it will not find them.
How...
( 1 2)
|
|
19 |
1,234 |
|
|
Partial Name Prompt Question by
bdehning
I currently have the following SQL which works fine but requires me to enter the whole Servicing Division such as Henderson.
How do I add Like & "*" without...
( 1 2 3)
|
|
21 |
1,233 |
|
|
Return repeats info in "8s" by
Joy Rose
I have the following Accounts Receivable Aging query.
SELECT DISTINCTROW
Sum(IIf((Date()-)31,*(1+)+-nz(),0)) AS , Sum(IIf((Date()-)61...
( 1 2)
|
|
14 |
1,225 |
|
|
help needed by
jkendrick75
I am needing a query to power a report that my boss wants done by this
friday. i have been working on this report for a couple of weeks now,
without getting...
( 1 2)
|
|
19 |
1,218 |
|
|
in access, round up to nearest fraction(.5) by
Stephengw
In MS-Access, How do I round a formula result up to the nearest fraction
(Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7
rounds up to...
|
|
1 |
1,216 |
|
|
|
March 21st, 2005 09:19 AM
by Andreas
|
1 |
1,213 |
|
|
Access 2000 to 2003 mail merge to word by
JJ
The DB we have was created in 2000. On my test computer, I upgraded to Office 2003 and am testing the mail merge. We run the query to get the information and...
|
|
1 |
1,207 |
|
|
|
June 1st, 2010 03:19 PM
by SSi308
|
4 |
1,201 |