Disappearing Data

[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

 

[Cheryl Fischer]

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?

 

[meyasakakenji]

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

 

[Andrew Johnson]

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