Unable to Append Imported data

R

rjmnwso

I am able to Import and Append data to my Client List Table to reflect
the new and lost clients that my company has. The Client list table
readily accepts the appended data but the queries, forms and reports
do not show that any data has been added to the Client List Table.

I have tried the copy append method of making a table of the New/Lost
Clients and using the copy append as well as the append query. both
work well to add the Data to the Client List Table but the queries
forms and reports to not reflect the change.

Can anyone help me on this problem?

Thank You
 
O

OldPro

I am able to Import and Append data to my Client List Table to reflect
the new and lost clients that my company has. The Client list table
readily accepts the appended data but the queries, forms and reports
do not show that any data has been added to the Client List Table.

I have tried the copy append method of making a table of the New/Lost
Clients and using the copy append as well as the append query. both
work well to add the Data to the Client List Table but the queries
forms and reports to not reflect the change.

Can anyone help me on this problem?

Thank You

If you have opened the table and verified that data is being appended,
then select one query or report and find out which qualifying field is
missing or has the wrong data. For example, you can take a query and
simplify it until data displays in the browse. This should tell you
where the problem lies.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top