Search results for query: *

Hello, I have two tables, the main one which shows account numbers and a second table which shows a date and a sales transaction by account number. I need to identify which account number from the Sales table is not included in the main table. Once I identify it, I can add it to the main table...

Hi there. I have two tables: one - main one where all the account numbers are (ex: g1234, g1235, g1236, etc) and another table with account numbers and dollar values. Every week this table gets updated with new information. I need to see if there is a new account number in table 2 (the one that...

Can anyone please tell me what Favourites is for? It's under Groups in Microsoft Access main screen. Thank you!

Hello, i am trying to sum up dates in the query and i am having a bit of difficulty with it. I have Sales date from March 1, 2006 to March 31, 2006 and i need to come up with a sum. When i do the sum function in the Sales column and run the query i get all the dates from March 1 - 31. Is it...

Hello, in one of my tables I have a column with the Fund Code Name field and it lists Fund Codes as text, but i entered numbers, ie. 1, 2, 3, etc. Now i need to convert these numbers into 3 digit numbers. For example 1 should become 001, 2 should become 002. One condition should be present...