Re start numbers on linked table

  • Thread starter Thread starter sByrne
  • Start date Start date
ok got everything going, created some reports, entered in data for testing and ran into a problem with the data on the report. Why does Access fill in data that shouldn't be there?? What it is doing is this...

Our screw machine runs 2 times for a total of 8 1/2 hours, our secondary machine runs once for a total of 5 hours. Now on the report it has the 2 records that need to be on there, but it puts a second 5 hours for the secondary machine that shouldn't be there. So in the totals it has the screw machine running 8 1/2 which is correct, and the secondary machine running 10 hours, which is incorrect, it should be 5 hours.

On the second ticket I entered 2 times for the screw machine ticket and 3 time for the secondary ticket. I end up with 6 entries on the report. It looks something like this...

sec---screw
1.5-----3
1.5-----4
2.25----3
2.25----4
5.5-----3
5.5-----4

The report should have 3 and 4 hours for the screw machine with a total of 7 hours ran and 1.5, 2.25, and 5.5 hours and total of 9.25 hours ran. It should look like this on the report basically...

sec---screw
1.5-----3
2.25----4
5.5

There is also no relationship between the times from the screw machine and secondary machine, so you could have 5.5 and 1.5 switched, etc... For the run times, I've pulled data from seperte queries also. Here is the DB, you can look at it and see how I'm doing it.

DB
 
When you have a report that needs to show data from a 1-many relationship, you will need to make it a main report with a subreport if any arithmetic is done based on values from the 1-side table.
 

Users who are viewing this thread

Back
Top Bottom