MS Access 2010

[GmWelch]

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

[ranman256]

I would hope you only have 1 record for 1 wheel,
and not 1 record holds info on 12 wheels.

[GmWelch]

Each record contains all the measurements for each vehicle. in other words each record contains the vehicle number, mileage, date that the measurements we taken, and the 36 fields for the measurements. I thought about using separate tables for the actual measurements but thought a single table would be simpler, I could be wrong.

[RayMilhon]

What you're trying to do and the data structure you've described is not possible. You need 1 table for the vehicle and 1 table for the wheels with a foreign key in the wheels table to link it to a vehicle.

[GmWelch]

I haven't worked with Foreign Keys yet, so I will get back to the books and do more research. will get back nxt week with my progress

Thank you.

[ssanfu]

The way your table is constructed is what is known as "Committing Spreadsheet".

Consider