Rows and Columns in database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I show this form in a datasheet view. I havent created this in access
yet but i have this in excel. It goes like this:

Description 10/1/05 10/2/05 10/3/05.... etc.
PRoj. #1 3 4 1
PRoj. #2 3 4 3
PRoj. #3 2 4
 
Use this table structure—
Proj -
Desrciption - text
StartDate - DateTime
QTY – number

Then use a CrossTab query to display.
 
Thanks I will try this.


KARL DEWEY said:
Use this table structure—
Proj -
Desrciption - text
StartDate - DateTime
QTY – number

Then use a CrossTab query to display.
Click to expand...
 
Back
Top