Need help with EXPRESSIONS

[Jker]

I have the following expression in my report that is working correctly:

=IIf([product_compare_cost1]<[product_cost] And [product_compare_cost1]<[product_compare_cost2] And [product_compare_cost1]<[product_compare_cost3] And [product_compare_cost1]<[product_compare_cost4] And [product_compare_cost1]<[product_compare_cost5],"BEST","")

what i want to do is to check if product_compare_cost1 is not null. If it is NOT NULL then continue with the above expression ...... I dont know how to work this condition into this expression

 

[theDBguy]

Hi. Welcome to AWF!

You could try something like:

IIf(IsNull([product_compare_cost1]),"",<Insert Your Other IIf() Expression Here>)

 

[plog]

I know I said this on your other post. But let me give it one last shot and then I'll leave you to your spreadsheet database.

field will not print in DETAIL section, only if moved to HEADER section

in my report i have UNBOUND field that will not print when it is in the DETAIL section.. When I move it to HEADER section, it prints. I have never seen this problem before. Notice: the #ERROR for SUPPLIER1 ... that is where i place field in DETAIL section NOTICE: $1.11 value prints when moved...

www.access-programmers.co.uk

Access is not Excel With Forms. It's an actual database. Why not use it like it's intended and get its full functionality? If you properly lay out your tables you can then write a query that easily finds the "Best" price. You've implemented a hack around your poor structure. It would actually be less work and less wonky if you used Access as intended.