Query not showing new records added though they exist in table.

[HRN_SciTech]

Many thanks.
I beleive the problem has been solved.
Firstly after using vbaInets logical suggestion of removing and re building the query got it working again and made me realise it really was a null character problem.

The Nz. method suggested by GalaxiomAtHome was used in the query via design view.

Many thanks guys you both have helped solve a problem in the universe!

Hi there. Sorry to bring up an old thread.. can you please post the SQL code you used with the Nz method?

Cheers