Form with Dates as Column Headers to Update Table with Dates as Rows (1 Viewer)

[PeterOC]

Hi,
My question is pretty much what the title says - I'm wondering if there's a way to have a form with Dates as column headers to update a table where the dates are stored in rows???

The table set up is like this:
tblOpHdr
DiaryID (PK) - OpDate (Date)

tblOpDetail
DiaryID (FK) - CostCode - MachineNumber - MachineHours - etc

I'm just wondering if there's any way I can do this with a datasheet or a crosstab type setup?

It's Access 2010.

Cheers,
Peter

 

[JHB]

Yes you can, but not without VBA code. I would use a recordset and a loop.