Hello access gurus! I am need of some assitance. I am finally reaching the end or a grueling process. I say grueling, and I am sure its a snap for all of you, which is why I am hoping you all can help....
I have four queries. Two different tables..
three queries are coming from one table (Daily 1) and the other one is coming from the other table (Daily 2)
All of these queries share a common field. "Store Number"
I want the end result to be similar to this http://www.mykesdesigns.com/tblrock1/help/EXCEL.JPG
except 5 more $ Deposited fields...
here are the 4 queries
http://www.mykesdesigns.com/tblrock1/help/ATMDEP.JPG (the ATMDEP field)
http://www.mykesdesigns.com/tblrock1/help/NETSLS.JPG (the NETSLS field)
http://www.mykesdesigns.com/tblrock1/help/DEPOSITS.JPG (the 6 DEP fields)
http://www.mykesdesigns.com/tblrock1/help/ADJTAX.JPG (the ADJTAX field)
I have posted screen caps because I am horrible at explaining things and I think you would appreciate them..
I believe it is relatively simple but I couldn't find anything on google that was what I needed. I am going to continue my search. I do not know too much about sql queries, I know how to use the design view pretty well ^_^
My search continues! I hope someone can help me!