I have one table and want to create a report on fuel costs by community
gas price diesel price heating oil price
town 1 3.00 3.50 3.75
town 2 2.00 2.50 2.75
town 3 1.00 1.50 1.75
I have 1000's of meter tickets that I want to add into a table or report by ticket number based on product sold:
AA12345 gas 50 gal town 1
AA12346 gas 75 gal town 3
AA12347 diesel 80 gal town 2
AA12234 gas 20 gal town 3
AA12254 heating 400 gal town 1
I want a report that gives me the answer:
AA12345 gas 50 gal town 1.....50 x 3.00 = $150.00
AA12346 gas 75 gal town 3.....75 x 1.00 = $ 75.00
AA12347 diesel 80 gal town 2.....80 x 2.50 = $200.00 etc
AA12234 gas 20 gal town 3
AA12254 heating 400 gal town 1
I have 25 communities and 3 prices for each community.
How best can I approach this, without writing a lot of If statements.
I am an intermediate Excel user but a pre-basic user in Access.
Thanks
Steve