Search results for query: *

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?

Ok, i have a table with Fund Codes: 1, 2, 3 all the way to 9999 (the data type is text). However i need to change Fund Codes to 001, 002, etc without changing the data type to numbers. Maybe i can try to use IIF function? I've never used IIF before, but it's my guess. If so, can you please tell...

Yes, i tried that, but then if i have a number 1000, i want to keep it as 1000, and if i use format function "000" it adds 000 to 1000 as well. I only want to do it till 99, i.e. 099 and stop there and leave 1000, 1001 as they are. Can it be done? Many thanks!

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