Search results for query: *

Ok, I got lost on this line: FROM Instruments As A The first table is "Instrument Names" and the second is "Calibration Data". In instrument names is the field "Instrument Number" which is what keys instrument names to calibration data. Sorry to be dense on this one.....

I have two tables, One with instrument numbers, and then another table joined with instrument numbers that has all the data for each instrument. What I need to do is search the last records for each instrument and see if it is within the last 6 months. If the last record is not within the last...

Can you explain this? Did you do this within the query critera?

Well, by last 6 months I want to see if an instrument number has an entry from the past 6 months. If is has I want to display the last years worth of data. If it hasn't had an entry in the last 6 months, reguardless if it has data in the past year I just want to skip it by and not display any...

I don't even know how to search this to see if there is a faq already made on this, but let me explain my situation and then maybe it will make sense to somebody. I have two tables, One with instrument numbers, and then another table joined with instrument numbers that has all the data for each...

Thanks for everyone's help. I just replaced the open query with the open report and everything seems to be working fine. :)

Hmm, that makes sense. I tried to understand that tip and it just didn't seem to make sense to me. However, I tried the iif statements and it seems to work. Now I have to figure out why it suddenly gives me this error: Run Time Error '2001': You canceled the previous operation. It gets...

The data type is text.

In a query I have a record field that I need to specify criteria for. The records in that field are of the form 2xxxxx, 3xxxxx - 9xxxxx ect. (the 2,3,4,5,6,7,8,9 denote different systems). Well, I have built a form with 9 checkboxes for the user to select which forms to run a query on. The...