We help IT Professionals succeed at work.

How do I make a database in Microsoft Access 2016, with the Same Fields but with Different Data?

Javed Baloch
Javed Baloch asked
Last Modified: 2017-04-09
I am trying to make a small database in MS Access for a Gas Station, where I need to store data for every Single Fuel Dispenser's Current and Previous Readings. Which will then subtract Previous Reading from Current Reading and Calculate the Sales on a Given Rate. There are 4 Fuel Dispensers Installed on the Gas Station and every dispenser has 2 nozzles. I have Created 1 table for each Nozzle. Now I have a total of 8 tables with these fields (ID, Date, Rate, Current Reading, Previous Reading, Total Sale, Credit Sale, Cash Sale, Total Amount, Discount and Description).

I also want to make Forms so that the User can enter the data from the Forms for each Nozzle. Can someone please help me with this? I have been trying it for the last four days and I am still stuck and cannot go further.

NOTE: For each nozzle the readings will be Different.
Watch Question

Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)


Thanks a Lot Scott This really helped me solve my problem