K
kevin
I modified the Northwind example database to track a Accounts
Receivable application. So far everything is working well. I need to
make a few modifications that I will get to below. A problem( not
really but an annoyance) is when I run reports I get the dialog to
enter date twice whenever I run I report that tracks employee
commissions.
First it asks for parameter value for Beginning date, then End date:
then
it asks for the Forms!Sales by Year Dialog!BeginningDate and Forms!
Sales by Year Dialog!EndingDate
I don’t know where these get generated from so I don’t know how to
eliminate one.
I also would like to add a parameter to choose only records that have
a check box field checks for PAID.
(the paid checkbox is on the form and in the table ORDERS.)
I am thinking that it may be easier to create or modify the "Sales by
Year Dialog" form to pass whatever variables I need to ALL reports.
Is there a way to have access use the SALES DIALOG and only the sales
dialog for reporting parameters?
So far the only additional reports required are:
EMPLOYEE COMMISSION
(a report that is generated by product sale - freight based on
commissionable amount that varies between 0 and 50 percent)
This works well now but I have a issue that need addressing. I have a
field in orders for commissionable amount and percent commission but
the commission amount is calculated in the report and not stored in
the table ORDERS. This is a problem b/c if a partial payment is made
is messes up the commission.
CUSTOMER AGING
I would like to get the report to group 0-30, 30- 60, > 60 if it isnt
too complicated. My biggest issue is the check box PAID thing to keep
paid invoices from appearing in the report.
This is the same kind of thing I need for commission paid report .
2 Fields INVOICE PAID and COMMISSION PAID in ORDER TABLE and in ORDERS
form to track info.
I would also like to get this report to run for single customers as
well as all customers.
Please Keep in mind I have only been using ACCESS for about 2 weeks if
you decide to help....... LOL
( I am way over my head)
Thanks
Kevin
Receivable application. So far everything is working well. I need to
make a few modifications that I will get to below. A problem( not
really but an annoyance) is when I run reports I get the dialog to
enter date twice whenever I run I report that tracks employee
commissions.
First it asks for parameter value for Beginning date, then End date:
then
it asks for the Forms!Sales by Year Dialog!BeginningDate and Forms!
Sales by Year Dialog!EndingDate
I don’t know where these get generated from so I don’t know how to
eliminate one.
I also would like to add a parameter to choose only records that have
a check box field checks for PAID.
(the paid checkbox is on the form and in the table ORDERS.)
I am thinking that it may be easier to create or modify the "Sales by
Year Dialog" form to pass whatever variables I need to ALL reports.
Is there a way to have access use the SALES DIALOG and only the sales
dialog for reporting parameters?
So far the only additional reports required are:
EMPLOYEE COMMISSION
(a report that is generated by product sale - freight based on
commissionable amount that varies between 0 and 50 percent)
This works well now but I have a issue that need addressing. I have a
field in orders for commissionable amount and percent commission but
the commission amount is calculated in the report and not stored in
the table ORDERS. This is a problem b/c if a partial payment is made
is messes up the commission.
CUSTOMER AGING
I would like to get the report to group 0-30, 30- 60, > 60 if it isnt
too complicated. My biggest issue is the check box PAID thing to keep
paid invoices from appearing in the report.
This is the same kind of thing I need for commission paid report .
2 Fields INVOICE PAID and COMMISSION PAID in ORDER TABLE and in ORDERS
form to track info.
I would also like to get this report to run for single customers as
well as all customers.
Please Keep in mind I have only been using ACCESS for about 2 weeks if
you decide to help....... LOL
( I am way over my head)
Thanks
Kevin