Hi everyone,
Just wondering if anyone can help me. I'm a very new user to access and last time i had a problem this wonderful forum fixed it, so here i am again!!
I'm working off the northwind sample database which has all the functions i need except one!
So my issue is that my company is a wholesaler and retailer - ie different prices are charged to each.
I have set northwind database up so that it looks after retail clients and was wondering how i would go about setting up say a 'New wholesale order'?
The other problem is that wholesale orders have two different prices based on quantity ordered. Regular bottle price and then there is a dozen price.
Not sure if this is going to be well above my skill level, so any help advice would be greatly appreciated!
Trust that i explained the problem well enough but let me know if you need more details.
Thanks in advance!
Cheers,
Jacqui
Just wondering if anyone can help me. I'm a very new user to access and last time i had a problem this wonderful forum fixed it, so here i am again!!
I'm working off the northwind sample database which has all the functions i need except one!
So my issue is that my company is a wholesaler and retailer - ie different prices are charged to each.
I have set northwind database up so that it looks after retail clients and was wondering how i would go about setting up say a 'New wholesale order'?
The other problem is that wholesale orders have two different prices based on quantity ordered. Regular bottle price and then there is a dozen price.
Not sure if this is going to be well above my skill level, so any help advice would be greatly appreciated!
Trust that i explained the problem well enough but let me know if you need more details.
Thanks in advance!
Cheers,
Jacqui