hi
below is 2 formulas that this forum kindly help me with and works great
what I want to do if possible is add another formula
is count the amount of records that are waiting purchasing up to 91 days from present day
I can have a date field with this in it "<=Now()+91" and filter it but still needs a formula after filter but if possible I would like the formula just to look at the dates to give me the results without filtering
but any of the 2 is great
Status: IIf(Nz([Invoice No],0)>0,"Invoiced",IIf(Nz([invoice old],0)>0,"Invoiced",IIf(Nz([pco No] Or [pco purchased old],"")<>"","parts ordered","Waiting Purchasing")))
Waiting purchase: Sum(DCount("*","order status","Status='waiting purchasing'"))
thanks
steve
below is 2 formulas that this forum kindly help me with and works great
what I want to do if possible is add another formula
is count the amount of records that are waiting purchasing up to 91 days from present day
I can have a date field with this in it "<=Now()+91" and filter it but still needs a formula after filter but if possible I would like the formula just to look at the dates to give me the results without filtering
but any of the 2 is great
Status: IIf(Nz([Invoice No],0)>0,"Invoiced",IIf(Nz([invoice old],0)>0,"Invoiced",IIf(Nz([pco No] Or [pco purchased old],"")<>"","parts ordered","Waiting Purchasing")))
Waiting purchase: Sum(DCount("*","order status","Status='waiting purchasing'"))
thanks
steve