Access Query Help!

[jack]

My knowledge of Access is limited mainly to knowing it would help me
right now!

I am trying to create an inventory/production database that will allow
me to upload inventory reports in one table, make production
comments/edits in another, and create a query that will tie the two
together. Also, I want the query to track all edits and comments, not
just the most recent. How can I do this?!?

Much thanks ahead of time!

 

[Jason Lepack]

Create two tables:

tbl_inventory: - import your reports into here
- partNumber - assuming that this will come from your import and be a
unique number
- all other info from your import

tbl_comments:
- commentID - unique identifier for each comment
- commentText - where you make the comment
- partNumber - linked to tbl_inventory
- commentDate - date that a comment was made

Create a form based on tbl_inventory. On this form create a subform
based on tbl_comments and link the two forms on partNumber.

Start with that and go from there.

If you really need a query to link the two then it would be:

SELECT tbl_inventory.*, tbl_comments.*
FROM tbl_inventory INNER JOIN tbl_comments
ON tbl_inventory.partNumber = tbl_comments.partNumber

Cheers,
Jason Lepack

 

[Jeff Boyce]

Jack

I'll offer a "friendly amendment" to Jason's response.

If you could have more than one comment per part per day, use a datetime
value, rather than a date-alone value.

Regards

Jeff Boyce
Microsoft Office/Access MVP