Just like to thank everybody for the help you've given me. As this is my first time on this forum l.m greatly impressed. I'll try out the other suggestions but once again thanks.
Regards
Keith
Kanga Keith
Last Activity: Nov 17 '08, 10:50 AM
Joined: Nov 15 '08
Location: England
-
ADezii your a star.
Its now works a treat - l was trying to enter the whole of your code in the criteria of the Sales_ID.
Thanks again for your help.
Regards
KeithLeave a comment:
-
Hi ADezii
Thanks for replying so promptly. As this is my first forum question l was really impressed. I've tried your reply but am having a problem with an error being reported:
The syntax of the subquery in this expression is incorrect.
Check the subquery's syntax and enclose the subquery in parentheses.
Not being very experienced in queries l've tried to track down the error but not having any luck. Any...Leave a comment:
-
Access Query Sorting Problem
Hi Everybody
I have a problem with a small database which l am designing. I've created a simple query using 4 fields:
Sales_ID Pack_Number SOP_Number SOP_Line
When displayed the data looks like this:
1 3 20462 1
2 2 20465 1
3 5 20470 2
4 7 20470 2
5 4 20470 5
As you can see Sales_ID 3 and 4 contain the same data...
No activity results to display
Leave a comment: