Recent content by Cherish2007

Found it! Thanks :)

Sorry, where do I find unmatched query wizard???

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 you give me an example how? Many thanks!

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

Thank you! So there is no way to do it without writing the code?

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...

Hap007, thank you but when i do that nothing happens, because the Data Type of this field is Text not Numbers.

PRPHx, thank you so much. I've never written a code before, would you mind helping me out? Should i do in a table or in a query? Thank you!

If I enter 000 in Format, 1 moves to the right of the column and so are the other numbers. It doesn't become 001.

In a Table I use Format function and enter @00@. 1 becomes 001, 2 becomes 002 and 10 becomes 1000 and 11 becomes 1001. And all i need is for 1 to become 001 and for 10 to become 010 and for 100 to stay 100. Any suggestions? Thank you.

I tried Format, but it didn't work. Any other suggestions please?

How??? I have to do it for work as soon as possible, so i am really counting on your help. I am not sure why 10 becomes 1000. In Format should i use @00@? Thanks

I do and it helps...1 becomes 001, etc, but 10, also becomes 1000 for some reason! and i don't want that. any chance i can avoid it?