Rebuild Flat-File Look from Query

[RobNauticus]

Hello, I am trying to create a spreadsheet view in a query that will allow edits. I was starting to build a query using dlookup but that will not allow edits.

Is there any way to achive this? It is a useful view that I hopefully will not have to abandon, due to normalization.

Any help would be VERY appreicated!

Thanks,
Rob

SELECT DISTINCT DateLog.JobID, DateLog.LotID, DLookUp("TaskDate","DateLog","TaskID = 1") AS LathDate, DLookUp("TaskDate","DateLog","TaskID = 2") AS ScratchDate, DLookUp("TaskDate","DateLog","TaskID = 3") AS ScratchWaterDate, DLookUp("TaskDate","DateLog","TaskID = 4") AS BrownDate, DLookUp("TaskDate","DateLog","TaskID = 5") AS BrownWaterDate, DLookUp("TaskDate","DateLog","TaskID = 6") AS FoamTrimDate, DLookUp("TaskDate","DateLog","TaskID = 7") AS FinishDate, DLookUp("TaskDate","DateLog","TaskID = 8") AS FinishWaterDate, DLookUp("TaskDate","DateLog","TaskID = 9") AS ScaffoldUpDate, DLookUp("TaskDate","DateLog","TaskID = 10") AS ScaffoldDownDate, DLookUp("TaskDate","DateLog","TaskID = 11") AS CleanupDate, DLookUp("TaskDate","DateLog","TaskID = 13") AS FoamOrderedDate, DLookUp("TaskDate","DateLog","TaskID = 14") AS FoamRecdDate, DLookUp("TaskDate","DateLog","TaskID = 15") AS SandOrderedDate, DLookUp("TaskDate","DateLog","TaskID = 17") AS MaterialOrderedDate, DLookUp("TaskDate","DateLog","TaskID = 18") AS MaterialArrivalDate, DLookUp("TaskDate","DateLog","TaskID = 19") AS ScratchInspectionDate, DLookUp("TaskDate","DateLog","TaskID = 20") AS WalkCompleteDate
FROM DateLog;

 

[LonnieJohnson]

You could use your above query as a MAKE A TABLE query to create a temptable for editing. Without knowing why you want to edit and what you are going to do with it after you edit, it is hard to direct you.

Can you create a form and use subforms to display the data you want to edit?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[hneal98]

You could also build a form with several subforms based on each table you want to edit and arange them next to each other to resemble the view you want.

You can then link the tables together and still have it updatable.

 

[RobNauticus]

It will be for the user to be able to see multiple records at once and visually compare them in a spreadsheet like view.

I will give the Form idea a shot.

Thank you both for the help.

Rob