Search results

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...

Hmmm,, not the help i was looking for.... When i initially designed the report yesterday, ex everything worked perfect.... then today,,, that one feld is not printing , only in the HEADER section. I am not worried about the table design since this is a small local datatbase on a freinds...

I am very new to this... and yes,, I have a PRODUCT table that has a main supplier id and his cost and 5 alternate suppliers ids and their costs. each of those 5 alternate suppliers are in my SUPPLIER table... the reason for the DLOOKUPS at detail level is to pulled out the 5 alternate supplier...

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...