How to exclude blank field from SUM calculated field

[BoltV]

Hi,

Hope someone can help.

I would like to sum up the records that has VoucherNumber group by VendorName. Ignore or excludes the ones without VoucherName. In this case, the query should only show this result with VoucherNumber
Bob T with total of 1100.00,
Kay C with total of 400.00
Rex M with total of 700.00

I have attached screenshot of my query.

 

[silentwolf]

Hi,

in the Criteria of the Voucher field you add <>""

HTH

 

[BoltV]

Hi Silentwolf,

It did filter out the blank VoucherNumber field (attached photo), however I'd also like to SUM the PurchaseInvoiceAmount group by VendorName.

 

[silentwolf]

Hi,

ok well I need to pass on that one .. never used it but what about sum function?

Otherwise someone here I am sure knows the secret to that problem ..)

 

[Gasman]

Crossposted https://www.access-programmers.co.uk/forums/threads/query-criteria-fomula.319968/

 

[theDBguy]

Hi @BoltV. Welcome to AWF.

Can you post a sample db with test data?

 

[theDBguy]

Ah, crossposted here with an accepted answer. Good luck!

Redirecting