Data into table

[Tom]

Hi all

When I enter date stright into table, I cant find the record with a query,
only if I enetr the record with the related form.

I paid extra attention no to have any mistakes in trms of spelling etc..

What can cause this?

Thanks,

Tom

 

[Tom Wickerath MDB]

you've probably just got the wrong where clause man

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Tom]

no, I checked that well.

you've probably just got the wrong where clause man

 

[Bill Mosca, MS Access MVP]

It could be that the form is adding data that you do not see. It would be
helpful if you posted the query you are using. Open the query in design view
and then click on View>SQL View. Copy the syntax into your post.

Also include sample data (not real data) you entered into the table that is
not showing.

 

[Tom]

Thanks for the response.
I found it, it was an extra space.

Tom

 

[Bill Mosca, MS Access MVP]

Good for you! Next time that happens you will have a headstart on finding
the bug.