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

Javed Baloch
Javed Baloch used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
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.

Author

Commented:
Thanks a Lot Scott This really helped me solve my problem

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial