Newbies Rer Posted March 19, 2001 Newbies Share Posted March 19, 2001 I must create a summary report of the amount of gasoline used by individual vehicles per month. In a "Vehicle Description" field I created a pop-up list of vehicle identification numbers and then enter amount of gallons in a "Gasoline Amount" field. How would I summarize the amount of gasoline used by each vehicle per month? Could someone enlighten me please? Thanks! Link to comment Share on other sites More sharing options...
Kurt Knippel Posted March 19, 2001 Share Posted March 19, 2001 quote: Originally posted by Rer: I must create a summary report of the amount of gasoline used by individual vehicles per month. In a "Vehicle Description" field I created a pop-up list of vehicle identification numbers and then enter amount of gallons in a "Gasoline Amount" field. How would I summarize the amount of gasoline used by each vehicle per month? Could someone enlighten me please? Thanks! Simply create the necessary summary (i.e. Total Gas = Total of Gasoline Amount) fields and then place them in a sub-summary part, sorted by Vehicle Description. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Newbies Rer Posted March 20, 2001 Author Newbies Share Posted March 20, 2001 Thanks CaptKurt for the solution to the value list problem! I now have a new problem. When I entered additional data for the new month and printed a new sub-summary report, it now only displays a grand total amount and nothing else. Any ideas? Thanks for any help! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8459 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now