Reports

  • Thread starter Thread starter Keith
  • Start date Start date
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.
 
Change your query to a parameter query. Instead of keying
a date in the criteria, have something like this:
[Enter Date]

Each time you run the report, you will get the prompt from
the query to enter date. You won't have to change the
report or the query.
 
Hi Les,

I ahve tried creating a new query named testquery and used
a paramater query of enter completion date.
I do see a dialog box which says enter completion date but
when it returns no data.
I also have a completed = yes in the same query.

What am i am doing wrong?

Cheers Keith

-----Original Message-----
Change your query to a parameter query. Instead of keying
a date in the criteria, have something like this:
[Enter Date]

Each time you run the report, you will get the prompt from
the query to enter date. You won't have to change the
report or the query.

-----Original Message-----
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.
.
.
 
Les,

I can get data from your reply however it only gives me a
specific date e.g. 31/05/04.
What if i want the report to produce a between option.
e.g. between 01/01/04 and 31/05/04 how do i achieve this?

Cheers Keith


-----Original Message-----
Hi Les,

I ahve tried creating a new query named testquery and used
a paramater query of enter completion date.
I do see a dialog box which says enter completion date but
when it returns no data.
I also have a completed = yes in the same query.

What am i am doing wrong?

Cheers Keith

-----Original Message-----
Change your query to a parameter query. Instead of keying
a date in the criteria, have something like this:
[Enter Date]

Each time you run the report, you will get the prompt from
the query to enter date. You won't have to change the
report or the query.

-----Original Message-----
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.
.
.
.
 
Back
Top