I am fairly new to Access 2010 and I am putting together a data base for monitoring Light Rail vehicle wheel diameters and wear. I have created a table that has fields for the vehicle identifier, mileage, date of measured data, and then 36 more fields that contain the 3 dimensions for each wheel (12 wheels 6 on each side) the dimensions are diameters, wear and max wear, I have created a form for data input into the table. I created a query that has criteria for the wear (>=0.050") and have returned proper results for the first 4 columns ( column 4 through 7), but when I add the criteria to the fifth column (column 8) the return is blank (no Data) I am not trying to sort the vehicle id, mileage or date of measurement. Ideally I would like the query to return results for the vehicles that exceed the wear and only the wheels for that vehicle that exceed the wear. I would be happy if I could just return the results for the vehicle for now. I am not sure why the fifth column spoils the query. The book I have and the you tube videos are all based upon customer data bases and do not seem to relate well to this situation.
Thanks for your help