G
Guest
I have set up a query that has several tables associated. (All the tables are
linked)
tblProjects - pulls basic project information
tblBAIRCV - pulls option group value description (based on option group
found on frmProjects)
tblT&MLSNTE - same as BAIRCV
tblJobStatus - same as BAIRCV
tblBillStatus - same as BAIRCV
tblCustomers - Pulls Customer name based on Lookup field from tblProjects
tblProjectManager - Pulls PM Name based on Lookup field from tblProjects
tblEmployee - Pull Employee Name based on Lookup field from tblProjects
There are several parameters set that allow the query to filter info based
on form entries or to retrieve all records when the form is left blank.
Currently the query will return information for every record that was
already entered before I started building the query but won't return data for
any new records that are created.
I don't know why it won't retrieve the new records, it does retrieve updated
info on the records that were previously created.
I would appreciate any help to get it to retrieve all records not just the
old ones.
Thanks.
linked)
tblProjects - pulls basic project information
tblBAIRCV - pulls option group value description (based on option group
found on frmProjects)
tblT&MLSNTE - same as BAIRCV
tblJobStatus - same as BAIRCV
tblBillStatus - same as BAIRCV
tblCustomers - Pulls Customer name based on Lookup field from tblProjects
tblProjectManager - Pulls PM Name based on Lookup field from tblProjects
tblEmployee - Pull Employee Name based on Lookup field from tblProjects
There are several parameters set that allow the query to filter info based
on form entries or to retrieve all records when the form is left blank.
Currently the query will return information for every record that was
already entered before I started building the query but won't return data for
any new records that are created.
I don't know why it won't retrieve the new records, it does retrieve updated
info on the records that were previously created.
I would appreciate any help to get it to retrieve all records not just the
old ones.
Thanks.