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

    If Statement

    I was able to get the query to run by removing the & symbol. SELECT IIf(DCount("*","dbo_CMC_PRPR_PROV","TaxID = TaxID")>1,"Multiple",[PRPR_NPI]) AS PRPR_NPICalc, ProviderList.TaxID FROM ProviderList INNER JOIN dbo_CMC_PRPR_PROV ON (ProviderList.TaxID = dbo_CMC_PRPR_PROV.MCTN_ID) AND...
  2. timidjewel

    If Statement

    Thanks Andy! I did practice and preview and I think I am getting the hang of it. Thank you for your help!
  3. timidjewel

    If Statement

    Thank you both for the quick reply. Duane, when i enter that SQL into my query, I get the below error The expression you entered as a query parameter produced this error: 'Microsoft Access cannot find the name 'TaxID' you entered in the expression'
  4. timidjewel

    If Statement

    Andy, you are correct Current Result PRPR_NPI[tab] TaxID 12[tab][tab][tab][tab]12345 14[tab][tab][tab][tab]12345 52[tab][tab][tab][tab]12345 83[tab][tab][tab][tab]54321 18[tab][tab][tab][tab]98763 23[tab][tab][tab][tab]98763 Desired Result PRPR_NPI[tab] TaxID multiple[tab][tab][tab]12345...
  5. timidjewel

    If Statement

    Thank you for the tips! I apologize, but i am not familiar with TGML and couldn't get it to look as good as your reply. But you are correct in that I only want one record per employee (TaxID). This is a great start so I am including my current sql since i'm joining to another table. I was trying...
  6. timidjewel

    If Statement

    I'm new to query building in Access. I have a unique identifier such as an employee id and the result in question is fruits. If an employee has more than one fruit, i want to see the word "multiple". If the employee has only one fruit, i want to see that fruit. How do i write a formula to show...

Part and Inventory Search

Back
Top