Data entry connected to daily date (over multiple months)

G

Guest

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

Guest

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

Similar Threads

union range 5
Multiple Dates 7
What's the fastest way to push this data around? 2
Problem designing tables: Too many fields 20
trying to unravel a spreadsheet 8
DATE REVIEW BY COLUMN 1
Update Query problem 5
form for data entry 4

Top