K
Keith
Hi group,
I have the following tabels in my very simple DB
Sales
Users
Customers
Both customers and users are lookups in the Sales table
I have created a query in my DB named sales_by_user.
This query takes the following fields from the
following tables.
Username -Users
CustID - Cutomers
Salestime,Salesdate, Sales, completed (Y/N), completed_
Salesdate
I then created a report named sales_by_user_report by all
fields in the afforementioned query.
The problem i am having is this*****
When i want to ouput a report that tells me what sales the
user has achieved this month i have to manually create a
new report by adjusting the original query/report.
The field i need to adjust in the query is the sales
field. I have to type in the criteria >31/04/04 to obtain
figures for this month.
That means i will need to manually create a new query and
report every month for all users.
I know there must be a quicker way to achieve this but
does anyone know how?
I am using Access97.
i really want a user to have some sort of dialog box
appear which can prompt them username and then prompt
sales completed date and have the report appear that way.
Any suggestions most welcome.
P.s I a'int no programming guru very new to access.
I have the following tabels in my very simple DB
Sales
Users
Customers
Both customers and users are lookups in the Sales table
I have created a query in my DB named sales_by_user.
This query takes the following fields from the
following tables.
Username -Users
CustID - Cutomers
Salestime,Salesdate, Sales, completed (Y/N), completed_
Salesdate
I then created a report named sales_by_user_report by all
fields in the afforementioned query.
The problem i am having is this*****
When i want to ouput a report that tells me what sales the
user has achieved this month i have to manually create a
new report by adjusting the original query/report.
The field i need to adjust in the query is the sales
field. I have to type in the criteria >31/04/04 to obtain
figures for this month.
That means i will need to manually create a new query and
report every month for all users.
I know there must be a quicker way to achieve this but
does anyone know how?
I am using Access97.
i really want a user to have some sort of dialog box
appear which can prompt them username and then prompt
sales completed date and have the report appear that way.
Any suggestions most welcome.
P.s I a'int no programming guru very new to access.