I want to make a report that will display the 10 best customers accordingly to their purchases! In my customers table i have a total purchases field that show the amount of purchases the customer has.... Anyone can help me with this ?
Thank you
sample
this is my sample so that you can see my tables and the ivoice input form.... the code for deducting must be added on the show me how it looks button i think....
sample
actually i do not take orders, i sell things and the qty sold will be deducted when pressing the create report button ... i will post a sample for you to see....
sample maybe?
ok because i am a newbie in access(relatively) a sample would really really help because i do not know how to do what you said...
if i am asking a lot i am sorry....
but this help will be much appreciated....
once again, thank you all
i think that what i need is something like
find product by using product code(i think is something WHERE ...)
product code = me.cmbpc (pc = product code)
and less me.qty
I have a invoice form from which my invoice report takes the details! The form is like this:
Product Code | Description | Qty | Unit Price | Amount
In the product code I have a combo box. Now what i need to do is to less the quantity from the "in stock" in the record of the product(find it...
security
i have already disabled the navigation pane from the left so that the user cannot jump directly to the switchboard before loging in BUT if the user that logs in is "Administrator"(only one administrator) then i want the right click to be enabled, else it must be disabled(this is the...
admin
no i need to have only 1 file and when a user logs in the moves must be limited(no design view), but when the administrator logs in he must be able to do whatever he wants!
hide database window
i have done that but once you open the form through the switchboard you can right click and view design mode!!!!
is there a way to disable the righ-click for all the users except the user "administrator"?
If i do this will the administrator be able to switch to design view?