Enter Parameter Value

[ngweixiong]

Hi,

I have a query to check for condition. but when i execute, a message box apprear. "Enter Parameter Value"

below is my code.

Stat: IIf([AvgOfTL PO and Inv]<7,[StatA],IIf([AvgOfTL PO and Inv]<10,[StatB]))

[puppydogbuddy]

Hi,

I have a query to check for condition. but when i execute, a message box apprear. "Enter Parameter Value"

below is my code.

Stat: IIf([AvgOfTL PO and Inv]<7,[StatA],IIf([AvgOfTL PO and Inv]<10,[StatB]))

If [StatA] and [StatB] are textboxes on your form, you need to provide a full reference as shown. Replace yourForm with the actual name of your form.

Stat: IIf([AvgOfTL PO and Inv]<7,Forms!YourForm![StatA],IIf([AvgOfTL PO and Inv]<10,Forms!YourForm![StatB]))

[NeoPa]

What's the prompt in the Message Box?

[ngweixiong]

If [StatA] and [StatB] are textboxes on your form, you need to provide a full reference as shown. Replace yourForm with the actual name of your form.

Stat: IIf([AvgOfTL PO and Inv]<7,Forms!YourForm![StatA],IIf([AvgOfTL PO and Inv]<10,Forms!YourForm![StatB]))

Hi,

I don't have any form in my Ms Access.

All i have is tables and query.

[ngweixiong]

What's the prompt in the Message Box?

Hi,

the prompt is " Enter Parameter Value"

[NeoPa]

You should have a Title (Enter Parameter Value), then a Prompt (?), then a box to enter your value in.
What is the Prompt?

[ngweixiong]

You should have a Title (Enter Parameter Value), then a Prompt (?), then a box to enter your value in.
What is the Prompt?

Hi,

the prompt is Stat A and Stat B

[ngweixiong]

Hi,

the prompt is Stat A and Stat B

SOrry,

what i mean is, firstly the prompt is Stat A, then after pressing enter,
it come out another prompt which is Stat B.

hope it will be clearer.

[NeoPa]

Right, in that case you are missing both of those fields from your query input.
As you have spelled them differently even here between two of your own posts, I think it very likely that you have done the same in your query. Check the spellings. Are they [StatA] or are they [Stat A]?
Do the same for [StatB] of course.

[ngweixiong]

Right, in that case you are missing both of those fields from your query input.
As you have spelled them differently even here between two of your own posts, I think it very likely that you have done the same in your query. Check the spellings. Are they [StatA] or are they [Stat A]?
Do the same for [StatB] of course.

Hi,

WHat do you mean by...
"missing both of those fields from your query input"

Please help..

[NeoPa]

I do TRY to help ;)
Your query must be taking its data from somewhere. This can be a single or multiple data sources. In the SQL view of your query you will see this (these) defined in the FROM clause. In the design view you will see it in the Tables area (above the definition of the fields you want the query to return).

It may be easier to help you if you posted the SQL string of the query that you are working on. That way we can help you more easily.

[ngweixiong]

I do TRY to help ;)
Your query must be taking its data from somewhere. This can be a single or multiple data sources. In the SQL view of your query you will see this (these) defined in the FROM clause. In the design view you will see it in the Tables area (above the definition of the fields you want the query to return).

It may be easier to help you if you posted the SQL string of the query that you are working on. That way we can help you more easily.

Hi,

below is my query codes:

SELECT [Average time lead between PO date and Inv Date].[AvgOfTL PO and Inv], IIf([AvgOfTL PO and Inv]<7,[StatA],IIf([AvgOfTL PO and Inv]<10,[StatB])) AS Stat
FROM [Average time lead between PO date and Inv Date];

Thanks alot

[NeoPa]

I'll have to look at this when I return on Thursday.
Please bump the thread if I skip it.

[ngweixiong]

I'll have to look at this when I return on Thursday.
Please bump the thread if I skip it.

*knock knock*

=)

kiNdly please help..

[NeoPa]

"Bump" received and understood. I'll do what I can when I can :)