Access reports

[eddiepenn]

I have a record with multiple publications. I'm tring the print a
report that will show the draws for Saturday if the publication is the
HC,WSJ or NYT and monday draw if the publication is BAR and IBD.
I've created a query that gives me all the right information, but
cannot combine the two fields into one.

Following is an example some far, but can't get it to work.
IIf([Pub]="HC" Or "WSJ" Or "WS-AM",[Saturday_Draw], Or IIf([Pub]="BAR"
Or "IBD",[Monday_Draw],0))


Thanks,Eddie

 

[Ofer Cohen]

Try

IIf([Pub] In("HC","WSJ" ,"WS-AM"),[Saturday_Draw], IIf([Pub] In
("BAR","IBD"),[Monday_Draw],""))

 

[eddiepenn]

Try

IIf([Pub] In("HC","WSJ" ,"WS-AM"),[Saturday_Draw], IIf([Pub] In
("BAR","IBD"),[Monday_Draw],""))

--
Good Luck
BS"D

I have a record with multiple publications. I'm tring the print a
report that will show the draws for Saturday if the publication is the
HC,WSJ or NYT and monday draw if the publication is BAR and IBD.
I've created a query that gives me all the right information, but
cannot combine the two fields into one.

Following is an example some far, but can't get it to work.
IIf([Pub]="HC" Or "WSJ" Or "WS-AM",[Saturday_Draw], Or IIf([Pub]="BAR"
Or "IBD",[Monday_Draw],0))

Thanks,Eddie- Hide quoted text -

- Show quoted text -

Thanks, BS"D

but It didn't work. Says a syntax error (comma) in query expression.
i really apprecate you taking the time on this.

 

[eddiepenn]

Try

IIf([Pub] In("HC","WSJ" ,"WS-AM"),[Saturday_Draw], IIf([Pub] In
("BAR","IBD"),[Monday_Draw],""))

I have a record with multiple publications. I'm tring the print a
report that will show the draws for Saturday if the publication is the
HC,WSJ or NYT and monday draw if the publication is BAR and IBD.
I've created a query that gives me all the right information, but
cannot combine the two fields into one.
Following is an example some far, but can't get it to work.
IIf([Pub]="HC" Or "WSJ" Or "WS-AM",[Saturday_Draw], Or IIf([Pub]="BAR"
Or "IBD",[Monday_Draw],0))
Thanks,Eddie- Hide quoted text -

- Show quoted text -

Thanks, BS"D

but It didn't work. Says a syntax error (comma) in query expression.
i really apprecate you taking the time on this.- Hide quoted text -

- Show quoted text -

BS"D

I really apprecate your help. It works great. I mistyped the code.
Thanks again, because I've been working on this all week.

Have a great day