not seeing my invoice number

hi



this is a formula that is working ok and giving me the result " invoiced " from the invoiced and invoice old

Quote:

Status1: IIf(Nz([InvoiceNo],0)>0,"Invoiced",IIf(Nz([invoice old],0)>0,"Invoiced",IIf(Nz([pco No],"")<>"" Or Nz([pco purchased old],"")<>"","parts ordered","Waiting Purchasing")))

this part of another formula is not counting the invoice in one field called "invoiceno" yet it is in a field called " invoiced old "

Quote:

invoiced: Sum(DCount("*","order status","Status='Invoiced'"))

the difference between the 2 is

that the invoice old is a number field

and the invoice number is a autonumber field

would that be the problem and how can I modify the formula see both both



thanks

steve

not seeing my invoice number