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 Chris Miller 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. mhall222

    SLQ -SELECT <THEN COUNT THEN UPDATE Another Table

    It says: "undefined function 'dcount' in expression Thanks ph
  2. mhall222

    SLQ -SELECT <THEN COUNT THEN UPDATE Another Table

    Yes but it gave me an error about the count function, not recognizable
  3. mhall222

    SLQ -SELECT <THEN COUNT THEN UPDATE Another Table

    The first one, "I'd try this" works but I get the message operation must use an updatable query. How do i make the nested query updatable?!! Thanks
  4. mhall222

    SLQ -SELECT <THEN COUNT THEN UPDATE Another Table

    I apologize for that. I am typing from my iPhone and i wasn't paying attention to parenthesis. The two original queries, the first one was just creating the table so i can count but i don't need to creat a table for that Table names: metrics and current 1. Select current.account, count(1) as...
  5. mhall222

    SLQ -SELECT <THEN COUNT THEN UPDATE Another Table

    This is what i had at one point but i need to count each sub account that are in account numbers from my "current" table My table that i am updating has the account numbers. This is what i had, i am dealing with 700k records. A lot of sub records are in the account numbers though. Update...
  6. mhall222

    SLQ -SELECT <THEN COUNT THEN UPDATE Another Table

    I have been working with this only access database that has about 1000 tables with some huge files. THe selected the info that they needed, lets says Select bank.account, bank.record, bank.amount where amount >100 or <-100 then they counted the records Select Bank.account...

Part and Inventory Search

Back
Top