Blank fields in query.

[Jeanette]

Hello, I have a table (Projects) with original projects and amended projects. All information regarding each project is inputted in the fields for original projects. Only limited fields are inputted in amended projects;new loan amounts or a new closing date may arise infrequently for amended projects. When there is a new closing date for an amended project, and it becomes part of a query all other fields are blank for that record, How do I populate the original project data into the blank fields of an amended project. I frequently have to create queries based on the fiscal year of closingdate field and I need to know the commitmentdate (field) and other dates that are in the original projects records. I hope this is not confusing thanks in advance.

 

[RV]

How do I populate the original project data into the blank fields of an amended project

Jeanette,

if you would be using amendments against your projects, you wouldn't have to.

Set up a new table tblAmendment to store any amendments.
Create a on to many relationship between this table and your projects table.
Use a subform to maintain your amendments against projects.

HTH,

RV