help with syntax please!

[Guest]

In 2002, my query has two "hours" fields: Hours Offered Hours Used. I only
want one kind of hours shown for each record.

I'm trying to use the criteria so that if the Hours Offered=0, the Hours
Used will be actual hours used, but if the Hours Offered>0, the Hours Used
will be 0.

I'm using an IF statement under the Hours field as follows:

=IIF([Offered Hours]=0,[Hours],0)

I keep getting an error message that my syntax is wrong or it's too complex
(HA!)

Any help would be hugely appreciated. Thanks.

 

[Rick B]

In a query, you would rarely (if ever) use the equal sign.

You should have something more like...


HoursToPrint: IF([Offered Hours]=0,[Hours],0)

 

[Guest]

Thanks for your speedy response, Rick.

Not to be too dense, but where would I put that HourstoPrint command?

Thanks so much,

Nomi

In a query, you would rarely (if ever) use the equal sign.

You should have something more like...


HoursToPrint: IF([Offered Hours]=0,[Hours],0)


--
Rick B

In 2002, my query has two "hours" fields: Hours Offered Hours Used. I only
want one kind of hours shown for each record.

I'm trying to use the criteria so that if the Hours Offered=0, the Hours
Used will be actual hours used, but if the Hours Offered>0, the Hours Used
will be 0.

I'm using an IF statement under the Hours field as follows:

=IIF([Offered Hours]=0,[Hours],0)

I keep getting an error message that my syntax is wrong or it's too complex
(HA!)

Any help would be hugely appreciated. Thanks.

 

[Rick B]

It becomes a field in your query. You'd use it as you would any other field
in a report or form.

--
Rick B

Thanks for your speedy response, Rick.

Not to be too dense, but where would I put that HourstoPrint command?

Thanks so much,

Nomi

In a query, you would rarely (if ever) use the equal sign.

You should have something more like...


HoursToPrint: IF([Offered Hours]=0,[Hours],0)


--
Rick B

In 2002, my query has two "hours" fields: Hours Offered Hours Used.

I
only

want one kind of hours shown for each record.

I'm trying to use the criteria so that if the Hours Offered=0, the Hours
Used will be actual hours used, but if the Hours Offered>0, the Hours Used
will be 0.

I'm using an IF statement under the Hours field as follows:

=IIF([Offered Hours]=0,[Hours],0)

I keep getting an error message that my syntax is wrong or it's too complex
(HA!)

Any help would be hugely appreciated. Thanks.

 

[Guest]

It actually worked! Thank you SO much!!!

Nomi

It becomes a field in your query. You'd use it as you would any other field
in a report or form.

--
Rick B

Thanks for your speedy response, Rick.

Not to be too dense, but where would I put that HourstoPrint command?

Thanks so much,

Nomi

In a query, you would rarely (if ever) use the equal sign.

You should have something more like...


HoursToPrint: IF([Offered Hours]=0,[Hours],0)


--
Rick B



In 2002, my query has two "hours" fields: Hours Offered Hours Used. I
only
want one kind of hours shown for each record.

I'm trying to use the criteria so that if the Hours Offered=0, the Hours
Used will be actual hours used, but if the Hours Offered>0, the Hours Used
will be 0.

I'm using an IF statement under the Hours field as follows:

=IIF([Offered Hours]=0,[Hours],0)

I keep getting an error message that my syntax is wrong or it's too
complex
(HA!)

Any help would be hugely appreciated. Thanks.