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

you've probably just got the wrong where clause man


"Tom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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/ex...ributors2.html for contact
info.


"Tom Wickerath MDB" <(E-Mail Removed)> wrote in message
news:e0%(E-Mail Removed)...
> you've probably just got the wrong where clause man

no, I checked that well.
"Tom Wickerath MDB" <(E-Mail Removed)> wrote in message
news:e0%(E-Mail Removed)...
> you've probably just got the wrong where clause man
>
>
> "Tom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>

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.

--
Bill Mosca, MS Access MVP
http://tech.groups.yahoo.com/group/M..._Professionals


"Tom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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

Tom
"Bill Mosca, MS Access MVP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> --
> Bill Mosca, MS Access MVP
> http://tech.groups.yahoo.com/group/M..._Professionals
>
>
> "Tom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>
>

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

--
Bill Mosca, MS Access MVP
http://tech.groups.yahoo.com/group/M..._Professionals


"Tom" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Thanks for the response.
> I found it, it was an extra space.
>
> Tom
> "Bill Mosca, MS Access MVP" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.
>>
>> --
>> Bill Mosca, MS Access MVP
>> http://tech.groups.yahoo.com/group/M..._Professionals
>>
>>
>> "Tom" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>