Data entry connected to daily date (over multiple months)

[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.

 

[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