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.

NOTE: For each nozzle the readings will be Different.
Javed BalochAsked:
Who is Participating?
I wear a lot of hats...

"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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I have Created 1 table for each Nozzle.
That's not the right way to structure this. You should have a single "Nozzle" table, and then a "Transaction" table:

tblNozzle
NozzleID
NozzleName
etc

tblTransactions
TransID
NozzleID
TransactionDate
TransactionType (cash or credit)
TransactionAmount
Reading

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.
1

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.

Start your 7-day free trial
Javed BalochAuthor Commented:
Thanks a Lot Scott This really helped me solve my problem
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.