born2gamble
Registered User.
- Local time
- Yesterday, 17:21
- Joined
- Aug 16, 2011
- Messages
- 31
Hi..having trouble with how to attack this.
Attached a pdf (showing how the form will look) and my access table is attached.
What I need at the end of the day is for me to be able to just look at how much total miles were driven in each state. This pdf represents 1 trip, and there will be many many trips. Every three months I will have to run a query to see the total miles driven in each state.
I can have TripsheetTotalMile1 = TripSheetMainOdometer2-TripSheetMainOdometer1
But I am completely lost, since TripsheetTotalMile1 wouldnt be attached to any specific state.
The order of States will also vary....it wont always be UT,AZ,NV,CA etc
So far doing this by hand has been very VERY tedious!
Attached a pdf (showing how the form will look) and my access table is attached.
What I need at the end of the day is for me to be able to just look at how much total miles were driven in each state. This pdf represents 1 trip, and there will be many many trips. Every three months I will have to run a query to see the total miles driven in each state.
I can have TripsheetTotalMile1 = TripSheetMainOdometer2-TripSheetMainOdometer1
But I am completely lost, since TripsheetTotalMile1 wouldnt be attached to any specific state.
The order of States will also vary....it wont always be UT,AZ,NV,CA etc
So far doing this by hand has been very VERY tedious!