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

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.

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You will almost certainly have to flesh those out a bit, but with a structure like this you'd have 8 records in the tblNozzle table, and each time a "transaction" is performed, you'd add a record in tblTransactions. You could then query tblTransactions to determine the total amount of sales in a given date period, the cumulative "readings" for that period, etc.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.