Jim
Can you post the SQL for each queryk? Usually when you need two different Max fields you can join the two or use a UNION, but without seeing what you have now I can't give you a definitive answer.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :
Hello all,
I am looking at these 2 queries that are run to get max Eff dt and Max Eff sq. They are in 2 queries. can these be run in only one query to get the max Eff dt and max Eff sq?
Thank You
Jim Wagner
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar