To start, let me say that I had no idea what Access was before last week. On Thursday, my boss at my internship asked me to create a database, so I started looking at online tutorials. This means that it is really easy to talk over my head on these things.
Here is my problem: I need to generate a report that reconciles records from two different tables. One is internal to the database, fed by a form, and it lists material movements as recorded by material handlers. The other is linked from Excel and is read only for the database. This table shows my system's material movement records. I need to compare the quantity moved on each table, while referencing both date and part number to ensure that it is the same movement. I have tried creating relationships, creating a new table, creating queries... I have no idea how to get this done and I don't know how to code.
Ideally, what I want to generate is a report that compares the two tables and will display part number, quantity reported by the material handler, quantity recorded in the system and the difference between the two. I also want it to flag if there is an entry for a date in one table but not the other. I have also been asked to note the quantities that we have on hand and allocated for orders and the difference between them, but that is all on the same table and I know how to reference that, for the most part.
I guess it boils down to a few main questions:
1. How do I make one report list several results based on date?
2. How do I create a report that references two tables contrasted against one another via both date and part number?
3. Can I do both of these and still include regular computed data off one of the tables?
Thank you in advance for all of your help. I got this assignment yesterday and they want it by the end of the week and I am mostly lost.