D
Della
To whom it may concern,
I'm setting up an Access data base for a small business,
the problems lie in queries where calculated fields need
to be set up to summarize information. The access books
from the University where I attend are not helpful. Here
is the scenerio: There is daily sales everyday being
recorded for different vendors, some are taxable, some
are not if the customer is a wholesale vendor purchasing
from another vendor. So there is a field that stipulates
taxable sale or nontaxable. The next important issue is
what type of commission is being extracted from the sale
based on where the vendor is located in building and time
of year the sale was completed on. We are trying to use
a combo box to list the commissions so we can select the
appriopriate commission to be calculated on the sale
based on the date. The queries won't let us calculate
using combo box, therefore we are having to implement
more fields into the tables, taking more time to record
daily sales transactions. Can you recommend a solution
or the proper book to help finish setting the data base
up?
Fields in daily sales table
Dealer# Name ItemDescrip Inv# SellingPrice TaxOption
CommOption DateSold
This is where we want to use combo
box to select 12% or 30% based on
location of item and date (Note the sales tickets are
specially marked so we know where they are coming from in
the building, so a location field isn't necessary).
Again in the query we are unable to get the calculation
to occur so reports can be generated summarizing all the
data based on total sales at 12% taxabe, total sales at
12% nontaxable, total sales at 30% taxable, total sales
at 30% nontaxable, total commissions at 12%, total
commissions at 30%, then rent, adjustments and so forth
are needed in report.
Thanks for your time,
Della
I'm setting up an Access data base for a small business,
the problems lie in queries where calculated fields need
to be set up to summarize information. The access books
from the University where I attend are not helpful. Here
is the scenerio: There is daily sales everyday being
recorded for different vendors, some are taxable, some
are not if the customer is a wholesale vendor purchasing
from another vendor. So there is a field that stipulates
taxable sale or nontaxable. The next important issue is
what type of commission is being extracted from the sale
based on where the vendor is located in building and time
of year the sale was completed on. We are trying to use
a combo box to list the commissions so we can select the
appriopriate commission to be calculated on the sale
based on the date. The queries won't let us calculate
using combo box, therefore we are having to implement
more fields into the tables, taking more time to record
daily sales transactions. Can you recommend a solution
or the proper book to help finish setting the data base
up?
Fields in daily sales table
Dealer# Name ItemDescrip Inv# SellingPrice TaxOption
CommOption DateSold
This is where we want to use combo
box to select 12% or 30% based on
location of item and date (Note the sales tickets are
specially marked so we know where they are coming from in
the building, so a location field isn't necessary).
Again in the query we are unable to get the calculation
to occur so reports can be generated summarizing all the
data based on total sales at 12% taxabe, total sales at
12% nontaxable, total sales at 30% taxable, total sales
at 30% nontaxable, total commissions at 12%, total
commissions at 30%, then rent, adjustments and so forth
are needed in report.
Thanks for your time,
Della