Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cherish2007

    Error Report

    Found it! Thanks :)
  2. Cherish2007

    Error Report

    Sorry, where do I find unmatched query wizard???
  3. Cherish2007

    Error Report

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

    Looking for a new account

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

    Favourites

    Can you give me an example how? Many thanks!
  6. Cherish2007

    Favourites

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

    How to sum up dates in a query???

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

    How to sum up dates in a query???

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

    Convert Text into Numbers in Microsoft Access

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

    Convert Text into Numbers in Microsoft Access

    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!
  11. Cherish2007

    Convert Text into Numbers in Microsoft Access

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

    Convert Text into Numbers in Microsoft Access

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

    Convert Text into Numbers in Microsoft Access

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

    Convert Text into Numbers in Microsoft Access

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

    Convert Text into Numbers in Microsoft Access

    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?
  16. Cherish2007

    Convert Text into Numbers in Microsoft Access

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

    Convert Text into Numbers in Microsoft Access

    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!
  18. Cherish2007

    Convert Text into Numbers in Microsoft Access

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

Part and Inventory Search

Back
Top