No records show up in Query

  • Thread starter Thread starter My-Yen
  • Start date Start date
M

My-Yen

Hello,

I have imported a table (rep_table) into Access, and copy
and paste into another Access table (contact_table) that
was created from scratch. When I try to run a query none
of the data show up. However, when I manually input data
into the form based on the 'contact_table' it shows up in
the query. Why is that? As well, how can I correct it
without having to manually input everything again.

Thanks,
My-Yen
 
Hello,

I have imported a table (rep_table) into Access, and copy
and paste into another Access table (contact_table) that
was created from scratch. When I try to run a query none
of the data show up. However, when I manually input data
into the form based on the 'contact_table' it shows up in
the query. Why is that? As well, how can I correct it
without having to manually input everything again.

Thanks,
My-Yen
Click to expand...

There's probably nothing wrong with your table; the error likely
resides in your Query. Perhaps you could post the SQL view of the
query.

Note that copy and paste is NOT the best way to do this, and it may
not have worked as you expect; an Append query is the preferred method
to get data from one table into another.
 
Back
Top