Search results
-
P
Query results change when I add a field
I have gone through pretty much all the iterations of those functions on the Tool Status field, but it does not reflect the actual text in the Tool Status field for that record. Some how the combination of reading the MaxofID and the MaxofdtEndDate gives me the wrong records for the Tool Status... -
P
Query results change when I add a field
So How do i get the last record of each Tool which read the Tool Status from that record #? I can't seem to get this one to work. -
P
Query results change when I add a field
First Post here... looks like a great forum. Anyway, I am developing a Tools database for a Cleanroom. It will hopefully keep track of the tools that are used and the maintenance of each tool. I have created a Tool Details table and a Tools Maintenance table with the data that I need to keep...