Invisible records

[DennisJones]

I have a simple database used for competition entries and scoring where I capture the entrants' details (and later their scores) in a single table. If an entrant returns to have another go I can either type in his details again or choose one of his earlier entries and issue a "duplicate" command (I have a button on the form to do this). This seems to work OK and a new record is created and I can see it in the underlying table and it looks OK. However despite restarts, refreshes and requeries none of my queries seem to be able to see a record created in this manner. Any suggestions?

Office XP with latest service pack3 update.
Thanks Dennis

 

[MStef]

In which moment you run a query???

 

[DennisJones]

It doesn't matter when I run the query, I have even run it after closing down and restarting the MS Access system so I don't think that it's a case of flushing buffers etc. I can clearly see the records in the underlying table but when I apply my query they are not there. It's as if there is some form of corruption of the record which renders it invisible to a query.

 

[MStef]

It must be a mistake somewhere.

 

[DennisJones]

After more research I think it is something to do with the copying of a date field when I duplicate the record. It looks as if the format of the date changes and the query can't then see it.

 

[Moniker]

Couldn't you just make the date field default to Now() or Date()? Why would you want to carry an old date (unless you're tracking historical information)?

 

[DennisJones]

Some of the data is historical and I have already used both now() and date() to store the date and tried storing as long date and short date etc. The fields look OK in the tables but the query can't see the ones that have been created by duplication. I was wondering if somehow the absolute date (which would include the time might also be being stored) in which case the absolute date would never match. It's really wierd!