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 MikeeOK 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: *

  • Users: NLucy
  • Content: Threads
  • Order by date
  1. NLucy

    Multiple update and make table queries

    I am manipulating data in MS Access SQL and I have manipulated the data in several steps (make tables, update queries etc.). How do I combine these queries? subqueries won't work for the updates I have to do as the updates are based on several criteria and it's not recognising the IIf statement...
  2. NLucy

    Multiple Update Commands based on different criteria in the one query

    I have a table of values and they have a date field. The date field values are 1-12, these relate to a period in the fiscal year. I want to create another column and assign the correct month in each row by looping through with the following criteria: 1 = 04 2 = 05 3 = 06 etc. I can do this with...

Part and Inventory Search

Back
Top