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!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- NLucy
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Multiple Update Commands based on different criteria in the one query
That worked, thanks!- NLucy
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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...- NLucy
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
