Disappearing Data

  • Thread starter Thread starter Andrew Johnson
  • Start date Start date
A

Andrew Johnson

Faced with a bit of an odd problem, hope it's not sounding too newbie...

I have a table of data, running from surnames a through z (imported from
Excel, incidentally). All the data is displayed in a table. In a form based
on the table, data with surnames beginning "i,j,k,l" do not display. In a
freshly created query, the same problems occuring!

Anyone with any idea why? It's stopping me move forward on a task that needs
to be finished yesterday so I'd be real grateful for any solution!

Andy
 
Are there spaces at the beginning of each surname that would force them to
appear at the top of a sorted recordset instead of where you would expect to
see them?
 
Andrew Johnson said:
Faced with a bit of an odd problem, hope it's not sounding too newbie...

I have a table of data, running from surnames a through z (imported from
Excel, incidentally). All the data is displayed in a table. In a form based
on the table, data with surnames beginning "i,j,k,l" do not display. In a
freshly created query, the same problems occuring!

Anyone with any idea why? It's stopping me move forward on a task that needs
to be finished yesterday so I'd be real grateful for any solution!

Andy
Click to expand...
 
Thanks for your help.

The problem was so simple I overlooked it...there were two related tables;
the records with Surnames ijkl had not been linked and somehow the default
value hadn't been applied.

Thanks anyway.

Andy
 
Back
Top