Hi there,
I've used Access before but it's been a while so I consider myself a newbie again. I am currently using Access 365 and Windows 10.
I am working on some sales analytics and need to cap sales at $500k. I don't want to exclude any sales, but rather I want to do a find and replace and make all those items with sales greater than $500k equal to $500k. I hope that makes sense?
There is already a query in place (created by my predecessor), that brings this field into a new table so I'm hoping I can find and replace within this query.
The query starts with SELECT Sum([A4-planned placement ty sales].[26WK PROJ SALES]) AS [PROJ 26WK SALES]
I would need to do the find and replace after the sales have been summed.
Thanks so much!
Sam
I've used Access before but it's been a while so I consider myself a newbie again. I am currently using Access 365 and Windows 10.
I am working on some sales analytics and need to cap sales at $500k. I don't want to exclude any sales, but rather I want to do a find and replace and make all those items with sales greater than $500k equal to $500k. I hope that makes sense?
There is already a query in place (created by my predecessor), that brings this field into a new table so I'm hoping I can find and replace within this query.
The query starts with SELECT Sum([A4-planned placement ty sales].[26WK PROJ SALES]) AS [PROJ 26WK SALES]
I would need to do the find and replace after the sales have been summed.
Thanks so much!
Sam