Search results

Thanks for your help. Ill explain the my database in more detail. In the Equipment table the fields are: Equipment ID, Name of Equipment, Size, Description, Colour, Condition and Cost of equipment (this is the cost to hire the equipment) Loans table- Loan ID, Player ID, Equipment ID, Date...

I am pretty new to access and am making a database for my Alevel project. Its for a sports club that lend out equipment. I have a prices table which has the name of the equipment, equipment ID and price. Also I have a loans table and a equipment table. I have created an update query which...