Search results

thanks,vbaInet. works like a charm. thanks for the quick response guys.

sorry i forgot to mention. this is a code i am running on a form.

can any one please give me an expression, what i am trying to achieve is: KPI=[DeliveryDate]-[SubDate] if [DeliveryDate]IS NULL, Date()-[SubDate] OR [DeliveryDate]-[SubDate]

can any oone please give me an expression, what i am trying to achieve is: KPI=[DeliveryDate]-[SubDate] if [DeliveryDate]IS NULL, Date()-[SubDate] OR [DeliveryDate]-[SubDate]

Thanks a lot for the help. working perfect just as I wanted it to.:) can you just update me what was it that I was doing wrong.:banghead:

i have a form to generate report with 3 filters, 1.sales_person, 2.Client_Name, 3.Product_ID these are combo selection and the report is working fine with these 3 filters. filtering by a query. all 3 feilds on the same table. what i am unable to do is make these filters as option to select with...