Re: move data from list box or combo box to another list

Carma thank you again for your suggestions. The reason to choose seperate
employees is because each employee gets paid commission on the service they
provied i.e. hair style, pedicure, etc and on retail they sell. Altoough
rare it is possible that one employee would do hair service another do nail
service and another sell retail item. Thus I need to track the commission
rates.. We don't need to wory about that I have the payroll protion of the
database working. I like your suggeston about the report and that may be all
I need to do, Just haden't thought of it. I should get time to try it
tonight or tomorrow and will let you know. The customer and dates are
already being tracked and the main form has the customer on it and can track
individual orders by filter. I also like you approach with the table for
taxable items and will have to work on that. Unfortunatly it may be the
week-end before I get the chance but I will keep you posted. Thank you again
... Roger
"Carma via AccessMonster.com" wrote:

Hey Roger! Well I'm glad that we made a good start to this but I'm pretty
sure we can overcome your other problems too. Ok I have several idea's and
several questions so lets get to it...

Why is it important/beneficial to allow a different employee for services vs
retail items?

Lets address your problem with your report which seems to be your main
problem. I'm assuming your report is based upon a query which puts all the
data together. Your report problems should be solved by making several
groupings. You want to group Customers and Orders, and also hide duplicates.
This way you should get a report like this...

Oh yeah and also you should/could have a filter in your query so that your
report will only show the data for one customer and one order. That way you
can make it look like an individual receipt... unless you want it to show all
orders???

<Now as also mentioned below you may not want the customer infor to be part
of this system but the logic for the rest is still the same>

Customer: Frank Zoodle

Order: 1000596

Date:

Items Purchased Quantity Price

Shampoo 1 $5.00
Hair Wash 1 $15.00
Perm 1 $40.00

Subtotal 3 $60.00
Taxes 5.45

Total $65.45

Customer field would be in teh customer header. Order in the Order hearder,
and Your items-qty-price would appear in teh detail part of the report. the
calculations would be in the report footer or probably better in the Order
footer. Now to calculate the correct taxes you need to try one of two things.
.. see if you can create a formula to isolate the taxible items and calculate
the tax on those or... create a subreport based upon a query which WILL
isolate them. This will be discussed more later so keep reading...

Also describe to me in more detail what the problem is with the appearance of
your form.

So my suggestion for your form is if you plan to track customers then to have
a main form based upon table Customers. Otherwise the main form can be based
upon table 'Orders' Lets assume for now that you don't track customers. In
ths case you only need three tables...
1. You will have a table tblItems which will simply contain all possible
things that can be purchased at your salon. This table will have fields Item,
Price, and one other field that could either identify the item as Service or
Product or taxible vs non.

2. The second table will track all orders placed with simply have an
autonumber primary key--> OrderID to track your orders, and probably a Date
field to automatically enter the current date. You could also have a
combobox based upon another table to select employee taking the order.

3. The third table will track Order details with a OrderID, OrderDetailID and
ItemID field which will be a lookup field from table tblItems.
So your form with have simply one main form based upon table Order and one
sub form based upon tblItems.

for your tax calculation what I suggest is creating a query which identifies
all items on the current order which are taxible and then having another
subform on the main form which will display the total tax amount. This is
why we created the field to isolate taxible vs non in the tblItems. There
may be a formula you can create on the main form only to identify and
calculate them without the query but offhand I don't know how to do so.
Someone else may though. To ensure the query gets the correct value ensure
the subform refreshes each time you either select a different order or change
or add an item.

This might be the best type of technique to calculate taxes ont he report
also but using a subreport there.

I know this is a lot but I hope this helps.

Roger wrote:
I have done exactly what you sugested with one subform for retail and another
sub for services. This is good because it alows me to choose a diferent
employee for services and retail items. This all works and all control on the
main form work also. The problem with that is wiith the report and the overal
appearance of the main form. Since the main fom is linked by child and master
on the subs it gives one order id on the main form that corelates to several
records on the subs. This causes the report to list each reecod seperately.
So in that case the report repeates the orider id from the main form serveral
times . I hope that made sense. Thank you for your idea it does work that way
but isn't quite what i'm looking for. Roger..

Unfortunately I don't know how to do exactly what you want but I'm sure its
possible and someone more knowledgable than I can tell you cause I'd like to
[quoted text clipped - 18 lines]
calculating tax on retail. Basicaly I want the list to look like a receipt.
Any suggestions on how to do this would be appreciated. Thank You.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200702/1


.

Relevant Pages

  • RE: Sub report message
    ... performs the first join and then include that query in your SQL statement." ... Left join employee table to issue table. ... 1.I checked the main report query to see if there was a problem. ... All site staff are listed including all of the Food Service ...
    (microsoft.public.access.reports)
  • Re: Help ... Creating an invoice
    ... So what you will want is a query that will return the required information ... for a report to use. ... for just the records for that customer. ... > if I want that order to be placed on the invoice? ...
    (microsoft.public.access.forms)
  • Re: Help ... Creating an invoice
    ... That query should use the customerID value to filter> for just the records for that customer. ... >> if I want that order to be placed on the invoice? ... My original answer was that you would> automatically generate a report including all orders for that customer. ...
    (microsoft.public.access.forms)
  • Re: Report / Sub-Report Problerm
    ... the customer account in the mainform, so equipment that does not match the ... It might be easier to do this with just one report instead of a report and ... Create a query using just tblCustomers and tblProductGenerics. ... this combination of customer and product exists in the tblCustomerEquipment ...
    (microsoft.public.access.reports)
  • Re: Im stuck can not get total sum correct
    ... It works, I went through my SQL and saw that Total Accident was still there, ... I remove it from the query and run my report, ... You have stated earlier that each employee belongs to a single department. ...
    (microsoft.public.access.reports)