blank fields in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

buggirl - 12 Mar 2008 21:51 GMT

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

Reply to this Message

buggirl - 12 Mar 2008 21:54 GMT

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

> Hi everybody -
>
[quoted text clipped - 16 lines]
>
> buggirl

Reply to this Message

buggirl - 12 Mar 2008 22:05 GMT

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!

> Hi everybody -
>
[quoted text clipped - 16 lines]
>
> buggirl

Reply to this Message

dick - 12 Mar 2008 23:04 GMT

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?

> Some more information:
>
[quoted text clipped - 23 lines]
> >
> > buggirl

Reply to this Message

buggirl - 12 Mar 2008 23:14 GMT

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

> Start by writing a basic new select query that just extracts the date alone,
> with no restrictive criteria.
[quoted text clipped - 31 lines]
> > >
> > > buggirl

Reply to this Message