General Question

[Bobbo]

I am hoping for some suggestions. I need to create a db from a spreadsheet
that is tracking the delivery of a document. I will have a date field in the
table that will show the date it is delivered but how would one suggest to
track the dates if it is delivered multiple times without losing the previous
entry. If there any samples out please direct me to one.

Thanks
Bob

 

[Jeff Boyce]

First, Access is not a spreadsheet. If you understand and use spreadsheets,
sorry, but you'll need to unlearn some of what you know to use Access as
designed/intended.

Next, if your situation can allow for "many" deliveries per document, then
the standard way of representing this in a relational database (ahem,
Access) is to use one table for the document(s), and another table for the
(many) deliveries.

That way, each "delivery" has a document and a date/time.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.