Answer needed ASAP

ktfrubel,

I think Doug was picking up on the part of yur posted SQL which says...
WHERE (((Supply_Table.Show) Like Yes))
This would indicate that if you look at the query in design view, you
will have a column in the query design grid for a field named Show, and
in the Criteria of that column is written Like Yes. Is that right? To
re-interpret Doug's comments, it depends whether the Show field is a
Yes/No data type, or a Text data type, or something else. If it's a
Yes/No data type, then the criteria should be simple Yes (or you could
also put True, or you could put -1). If it's a text field, then the
criteria should be in ""s, e.g. "Yes". In neither case should it have
the word Like.

But you are getting a parameter prompt. So here's my question related
to that... Does your Supply_Table table contain a field named
ReOrder_level spelt exactly like that?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12688-answer-needed-asap.html

--
Steve Schapel, Microsoft Access MVP

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12688
ktfrubel wrote:
> Douglas,
> I am not trying to sound ignorant, but I don't write in the SQL area. I
> normally just create the queries in design view. The only thing I did was a
> chose the * to choose all the fields from the main talbe "Supply_Table" to
> create me a query called "ShowYes" In this query is where I have created the
> calulated field as I mentioned below. I do not want anything to show the
> word Yes anywhere. forgive me because I don't understand what your are
> telling me to try. I however would love to. I have been learning access
> going on 2 years now, and have never really dove into this language.
> Anything you can do to help will be greatly appreciated

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

OK...I understand that! I will fix that right away. Would this help with my
calculation question?

"Steve Schapel" wrote:

> ktfrubel,
>
> I think Doug was picking up on the part of yur posted SQL which says...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12688
> WHERE (((Supply_Table.Show) Like Yes))
> This would indicate that if you look at the query in design view, you
> will have a column in the query design grid for a field named Show, and
> in the Criteria of that column is written Like Yes. Is that right? To
> re-interpret Doug's comments, it depends whether the Show field is a
> Yes/No data type, or a Text data type, or something else. If it's a
> Yes/No data type, then the criteria should be simple Yes (or you could
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12688
> also put True, or you could put -1). If it's a text field, then the
> criteria should be in ""s, e.g. "Yes". In neither case should it have
> the word Like.
>
> But you are getting a parameter prompt. So here's my question related
> to that... Does your Supply_Table table contain a field named
> ReOrder_level spelt exactly like that?
>
> --
> Steve Schapel, Microsoft Access MVP
>
> ktfrubel wrote:
> > Douglas,
> > I am not trying to sound ignorant, but I don't write in the SQL area. I
> > normally just create the queries in design view. The only thing I did was a
> > chose the * to choose all the fields from the main talbe "Supply_Table" to
> > create me a query called "ShowYes" In this query is where I have created the
> > calulated field as I mentioned below. I do not want anything to show the
> > word Yes anywhere. forgive me because I don't understand what your are
> > telling me to try. I however would love to. I have been learning access
> > going on 2 years now, and have never really dove into this language.
> > Anything you can do to help will be greatly appreciated
>

Ktfrubel,

As I understand it, your "calculation question" relates to the fact that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12688
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12688
you are receiving a Parameter prompt, which means there is something in
the query that Access can't evaluate. So, as per my earlier question...
Does your Supply_Table table contain a field named ReOrder_level spelt
exactly like that?

--
Steve Schapel, Microsoft Access MVP

ktfrubel wrote:
> OK...I understand that! I will fix that right away. Would this help with my
> calculation question?
>

How's it going?
If you're still having problems, you could email me an (empty?) copy of your
database if you like, and I'll have a quick look. This is starting to
intruige me now...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12688

Remove Elvis's Shoes (Blue Suede) from my email address to reply.

Cheers,

Chris.

"ktfrubel" wrote in message
news:B68AA6CD-3B0C-49AF-8167-91BEB31676AD@microsoft.com...
> OK...I understand that! I will fix that right away. Would this help with
> my
> calculation question?
>
> "Steve Schapel" wrote:
>
>> ktfrubel,
>>
>> I think Doug was picking up on the part of yur posted SQL which says...
>> WHERE (((Supply_Table.Show) Like Yes))
>> This would indicate that if you look at the query in design view, you
>> will have a column in the query design grid for a field named Show, and
>> in the Criteria of that column is written Like Yes. Is that right? To
>> re-interpret Doug's comments, it depends whether the Show field is a
>> Yes/No data type, or a Text data type, or something else. If it's a
>> Yes/No data type, then the criteria should be simple Yes (or you could
>> also put True, or you could put -1). If it's a text field, then the
>> criteria should be in ""s, e.g. "Yes". In neither case should it have
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12688
>> the word Like.
>>
>> But you are getting a parameter prompt. So here's my question related
>> to that... Does your Supply_Table table contain a field named
>> ReOrder_level spelt exactly like that?
>>
>> --
>> Steve Schapel, Microsoft Access MVP
>>
>> ktfrubel wrote:
>> > Douglas,
>> > I am not trying to sound ignorant, but I don't write in the SQL area.
>> > I
>> > normally just create the queries in design view. The only thing I did
>> > was a
>> > chose the * to choose all the fields from the main talbe "Supply_Table"
>> > to
>> > create me a query called "ShowYes" In this query is where I have
>> > created the
>> > calulated field as I mentioned below. I do not want anything to show
>> > the
>> > word Yes anywhere. forgive me because I don't understand what your are
>> > telling me to try. I however would love to. I have been learning
>> > access
>> > going on 2 years now, and have never really dove into this language.
>> > Anything you can do to help will be greatly appreciated
>>