Results 1 to 6 of 6
  1. #1
    GmWelch is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    3

    MS Access 2010

    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

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    I would hope you only have 1 record for 1 wheel,
    and not 1 record holds info on 12 wheels.

  3. #3
    GmWelch is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    3
    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.

  4. #4
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,085
    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.

  5. #5
    GmWelch is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    3
    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.

  6. #6
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    The way your table is constructed is what is known as "Committing Spreadsheet".

    Consider
    Click image for larger version. 

Name:	Wheels1.jpg 
Views:	11 
Size:	23.4 KB 
ID:	24865

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 01-07-2016, 12:49 PM
  2. Replies: 6
    Last Post: 07-07-2014, 09:13 AM
  3. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  4. Replies: 4
    Last Post: 09-19-2012, 02:07 AM
  5. Replies: 0
    Last Post: 07-31-2012, 12:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums