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

    Updating Data using a form

    Hello Friends, I am using a Access 2000 database to records absentism at my store. I have a switchboard I use to access my form where I select my employees name and date they took holiday and other details.. Thats working fine. The situation is..whenever someone requests a day off in advance I...
  2. uniroyal2001

    Use CASE Statements in Access

    Hello Frederico, I wish I could give you 5 stars. It worked like a charm. Thanks a million. :)
  3. uniroyal2001

    Use CASE Statements in Access

    hello cmmrfrds, so if I am to follow your steps then the final code should like this Switch(L.PSYS_COLLECTOR_ID = 'CTA' AND G.TEAM <> ' ' ,G.TEAM, L.PSYS_COLLECTOR_ID = 'CTA' AND G.TEAM = ' ',C.TEAM, L.PSYS_COLLECTOR_ID <> ' ' AND L.PSYS_COLLECTOR_ID <> 'CTA', L.PSYS_TEAM_ID,G.TEAM...
  4. uniroyal2001

    Use CASE Statements in Access

    yes i tried using multiple IIFs but something in the syntax didnt work.
  5. uniroyal2001

    Use CASE Statements in Access

    Any idea to just convert it in access. The code you are seeing about is in ANSI SQL. I tried using IIF(...)..but gave me some obscure error message. VALUE(G.TEAM,' ') AS CBT_TEAM, this I can convert as Nz(G.TEAM,'') AS CBT_TEAM
  6. uniroyal2001

    Use CASE Statements in Access

    Hello All, I am trying to use this mentioned CASE statement in a Access query. Any leads in this matter is greatly appreciated. SELECT VALUE(G.TEAM,' ') AS CBT_TEAM, VALUE(L.PSYS_COLLECTOR_ID,' '), VALUE(L.PSYS_TEAM_ID,' ') AS PSYS_TEAM, H.LEGAL_NAME AS CUSTOMER_NAME, CASE WHEN...

Part and Inventory Search

Back
Top