Data entry connected to daily date (over multiple months)

T

Teratogen

Hi. I'm trying to design an access database. I want to have a given lot
name in one table connect to a daily measurement number in another table.
Setup would look like this:

LOT# date1, date2, date3, date4, date5, date6, date7, date8
07DDLL 40 39 37 30 22 20 7 1

Question is, do I need to make a separate date for every single entry? This
will be a multiple month database (3-5 months of dates) I may have access to
Microsoft Project in the near future, and I do not know if it would be better
to use that or even if you can enter that for data entry.
 
D

Duane Hookom

You need to build a database, not a spreadsheet. I would create tables and
records like:

tblLots
==========
LotID autonumber primary key
LotNumber

tblLotDates
=============
LotID
LotDate
LotMeasure
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top