blank fields in a query

  • Thread starter Thread starter buggirl
  • Start date Start date
B

buggirl

Hi everybody -

I started a database with data that I collected last year. It was all going
fine, until I started entering older (2006) data. Now, when I run a query,
some of my fields are left blank for the 2006 data but not for the 2008 data,
even though I know that there should be data in there.

I thought there may have been a problem with the way I pasted data in from
Excel, so I deleted all of that 2006 data and then re-entered it manually.
This didn't help.

I don't think it's a problem with inner/outer joins. If it was, then I don't
think the 2007 data would show up. I think it's a problem with data entry.

Any advice? I would like to repair the problem and avoid going through this
again!

thanks,

buggirl
 
Please note that 2007 AND 2008 data is working ok (I re-read my original post
and realised that it's a bit confusing).
 
Some more information:

When I expand the subdatasheet in my primary table, all of the fields are
blank for the 2006 data but are correct for the 2007 data.

HELP!
 
Start by writing a basic new select query that just extracts the date alone,
with no restrictive criteria.
If none of the 2006 dates appear, but 2007 and 2008 does, then you have a
date entry problem.
Just try changing one of the 2006 dates until you can get it to appear, and
also look at the design view of the table to see what date format you have
set there. Are you entering the 2006 dates in accordance with this format?
 
Thanks Dick -

This is exactly what I did. I re-ran the query and fooled around with the
"Join Properties" options. It gradually dawned on me that Access was
recognising the data, but not my primary key. Then I realised there was some
problems with the input mask when entering my primary key, so I fixed it up
and typed in the data again.

Phew!

After jumping through all those hoops, it's working now!

Thanks for your response,

buggirl
 
Back
Top