Hi There
This may be a total access newbie question but I cant find the answer in my Access books.
I have in an access database sales history. This is segmented in several ways - eg brand/season/product line.
I want to be able to apply something over the top of those numbers that Access will drive down by the sales history.
I think this needs an example:
I sell 300 reds, 30 green type a and 200 green type b.
I want to give my customer a 10% rebate on all sales except green type a.
I could figure this out so far - but I need to be able to analyse the rebate in the same detail as the sales (so I can cut the data by various segments) to generate a full P&L.
There are many different combinations of product type/season/brand/customer and type of term.
The only way I can find to do this is to put the data in excel, apply some formulas and copy the data back into access.
Is there an easier way of doing this? I was thinking of setting some sort of template up where I could enter all the parameters for the rebate that would pick up the sales and apply a set rebate rate to these sales - but I'm not sure how to do this.
In terms of access skill I can build queries in the builder but I've never used the VBA side of it (have done in Excel though).
Thanks in advance.
Jessica
This may be a total access newbie question but I cant find the answer in my Access books.
I have in an access database sales history. This is segmented in several ways - eg brand/season/product line.
I want to be able to apply something over the top of those numbers that Access will drive down by the sales history.
I think this needs an example:
I sell 300 reds, 30 green type a and 200 green type b.
I want to give my customer a 10% rebate on all sales except green type a.
I could figure this out so far - but I need to be able to analyse the rebate in the same detail as the sales (so I can cut the data by various segments) to generate a full P&L.
There are many different combinations of product type/season/brand/customer and type of term.
The only way I can find to do this is to put the data in excel, apply some formulas and copy the data back into access.
Is there an easier way of doing this? I was thinking of setting some sort of template up where I could enter all the parameters for the rebate that would pick up the sales and apply a set rebate rate to these sales - but I'm not sure how to do this.
In terms of access skill I can build queries in the builder but I've never used the VBA side of it (have done in Excel though).
Thanks in advance.
Jessica