Link to home
Start Free TrialLog in
Avatar of Roger Gill
Roger GillFlag for United States of America

asked on

GENERATING a report in a FORM/DIALOGBOX with multiple criteria in MS ACCESS

Trying to generate a report in a form.
1st option:
1.      A report Between 2 dates …for only 1 car or all cars.
In report like to group all like wise states MILES (eg for State miles.  Ca 200 + Ca 210 =  Ca410), same for for GALLONS group all like wise State Gallons (Eg for State fuel GALLONS if in that time period Az 200 + Az 310 = Az 510)

2nd Option
2.      Report for quarters for eg for  1st Quarters (so dates will be 01/018/2018..03/31/2018 ) and same for the rest of the quarters
      In report like to group all like wise states miles (eg for State MILES.  Ca 200 + Ca 210 =  Ca410) and  same for for GALLONS group all like wise State GALLONS (Eg for State fuel GALLONS if in that time period Az 200 + Az 310 = Az 510)

Either you can use trip date or record date of FUEL purchase and date of MILES traveled.
I had include [IDTrip] in both "FormFuel" and "FormMilesTravel" , So I can group all the records with [IDTrip]

When you open this file it will open in a DataEntry form for entering FUEL & MILES. There is button on top right hand side I will open a report form..this is just to give you an idea what I am trying to do . I guess I am doing more than I should be doing.


Thanks in advance
Report.PNG
Learn1.accdb
SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Roger Gill

ASKER

I had uploaded another files , with more information , When ReportForm opens their are two buttons,  i am trying to generate reports with these two methods, When you press these button another form will pop up it will have detail what I am trying to do...Scenario is like this, my students had made multiple tirps out of state , we have to keep record of many miles  our cars traveled in each state and how many gallons  of fuel is purchase in that state.  So When there are hundred trips then we can pull data from our table to find out within two dates how many miles all the cars had travel in each individual state and how much fuel we had purchase in each individual state.  

Thanks
Did you build the queries I suggested?
Thanks everyone, I did figure out ,again thanks for your time.