What are the data types of CustomerID and Group No? If they are numbers, you can ensure a proper JOIN by using Format(CustomerID, "00000") - enough zeros to cover the largest CustomerID or Group No. Doing a plain concatenation might get some bogus joins - for example customer 11 and Group 1 will match customer 1 and group 11. Formatting the numbers before concatenation will give you 0001100001 for the first combo and 0000100011 for the second. Try it and let me know.
John Viescas, Author
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
Posted by: John Viescas <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (6)|
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.