K
KarenM
Greetings.
A2K, Win2K
I have a simple enough query, based on another query. When I run it,
it will not produce unique results. However, when I alter my query to
base it on the source query's underlying table, it will deliver unique
results. I want to use the query as my underlying recordsource if
possible because it contains some derived fields that I want to take
advantage of.
Can anyone tell me why my SQL won't deliver unique records when
pointing to a query?
Here's my SQL:
THIS WORKS:
SELECT DISTINCT tblStuff.colParentRefNum, tblStuff.colDescription
FROM tblStuff
WHERE (((tblStuff.colParentRefNum)="10-2-6"));
THIS DOESN'T:
SELECT DISTINCT qryStuff.colParentRefNum, qryStuff.colDescription
FROM qryStuff
WHERE (((qryStuff.colParentRefNum)="10-2-6"));
TIA...
Karen M.
A2K, Win2K
I have a simple enough query, based on another query. When I run it,
it will not produce unique results. However, when I alter my query to
base it on the source query's underlying table, it will deliver unique
results. I want to use the query as my underlying recordsource if
possible because it contains some derived fields that I want to take
advantage of.
Can anyone tell me why my SQL won't deliver unique records when
pointing to a query?
Here's my SQL:
THIS WORKS:
SELECT DISTINCT tblStuff.colParentRefNum, tblStuff.colDescription
FROM tblStuff
WHERE (((tblStuff.colParentRefNum)="10-2-6"));
THIS DOESN'T:
SELECT DISTINCT qryStuff.colParentRefNum, qryStuff.colDescription
FROM qryStuff
WHERE (((qryStuff.colParentRefNum)="10-2-6"));
TIA...
Karen M.