report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi to all.... I have a question.
I have a report that shows all the Computer Repair Requests (CRR) that
people from the company made to the IT Department. It shows all the CRRs from
the beginning of the database to date. Now, I only want to show the ones that
are for 2006. I don't care now about the ones in 2005.

How can accomplish such a thing?? I have no idea on how to do it.
thank you very much for your help in advance...
 
Base your report on a query. In the query type in a field that looks like
this:
YearOfCRR:Year([CRRDate])
Note: [CRRDate] is the date of the Computer Repair Request. Use your field
name for this date field.

Set the criteria for this field to 2006.
 
lula,
First, you will need to create a "Date parameter" criteria in your query
that produces the report,. Open the query in design view, pull down the
"Date" field into query, then put youe date parameter in the criteria field
(ex. >=01/01/2006). Save and Close query. Next time you run the report,
you'll only get 2006 data. Hope this helps?
 
thank you caloy for your answer...
I had this

SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag];

and now I added the following
SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag]
WHERE [CRR].[date_CRR]>=01/01/2006;

although is not doing anything different. It's still bringing me the same
data... can you help me again????
thanks
 
Actually, the query did change but now I have to figure out how to do it in
the report, as I had it from the table and not from the query.... jaja

lula said:
thank you caloy for your answer...
I had this

SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag];

and now I added the following
SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag]
WHERE [CRR].[date_CRR]>=01/01/2006;

although is not doing anything different. It's still bringing me the same
data... can you help me again????
thanks

caloy said:
lula,
First, you will need to create a "Date parameter" criteria in your query
that produces the report,. Open the query in design view, pull down the
"Date" field into query, then put youe date parameter in the criteria field
(ex. >=01/01/2006). Save and Close query. Next time you run the report,
you'll only get 2006 data. Hope this helps?
Click to expand...
Click to expand...
 
You can try creating a new report using the the query instead of the the
table. You can do this either through the report wizard (using the query
instead of table) or making a copy of the report, then saving it with a new
name. OPen the new one in design view then replace the fields you need using
the fields from the query.
--
Caloyski


lula said:
Actually, the query did change but now I have to figure out how to do it in
the report, as I had it from the table and not from the query.... jaja

lula said:
thank you caloy for your answer...
I had this

SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag];

and now I added the following
SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag]
WHERE [CRR].[date_CRR]>=01/01/2006;

although is not doing anything different. It's still bringing me the same
data... can you help me again????
thanks

caloy said:
lula,
First, you will need to create a "Date parameter" criteria in your query
that produces the report,. Open the query in design view, pull down the
"Date" field into query, then put youe date parameter in the criteria field
(ex. >=01/01/2006). Save and Close query. Next time you run the report,
you'll only get 2006 data. Hope this helps?
--
Caloyski


:

Hi to all.... I have a question.
I have a report that shows all the Computer Repair Requests (CRR) that
people from the company made to the IT Department. It shows all the CRRs from
the beginning of the database to date. Now, I only want to show the ones that
are for 2006. I don't care now about the ones in 2005.

How can accomplish such a thing?? I have no idea on how to do it.
thank you very much for your help in advance...
Click to expand...
Click to expand...
Click to expand...
 
thank you.... I will try the second option as I'm having an issue with the
wizard... I posted another question regarding that, but noone answered me
yet...

this is my previous post.
Hi to all.... I have a question.
I have a report that shows all the Computer Repair Requests (CRR) that
people from the company made to the IT Department. It shows all the CRRs from
the beginning of the database to date. Now, I only want to show the ones that
are for 2006. I don't care now about the ones in 2005.

How can accomplish such a thing?? I have no idea on how to do it.
thank you very much for your help in advance...

if you can help me in any of this I would appreciate it!
thanks again


caloy said:
You can try creating a new report using the the query instead of the the
table. You can do this either through the report wizard (using the query
instead of table) or making a copy of the report, then saving it with a new
name. OPen the new one in design view then replace the fields you need using
the fields from the query.
--
Caloyski


lula said:
Actually, the query did change but now I have to figure out how to do it in
the report, as I had it from the table and not from the query.... jaja

lula said:
thank you caloy for your answer...
I had this

SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag];

and now I added the following
SELECT [CRR].[id_CRR], [CRR].[date_CRR], [CRR].[id_tag], [CRR].[id_urgency],
[CRR].[id_employee], [CRR].[id_category], [CRR].[first_time],
[CRR].[otherHW_working_properly], [CRR].[description], [Employees].[Name]
FROM (Employees INNER JOIN Equipment ON
[Employees].[id_employee]=[Equipment].[id_employee]) INNER JOIN CRR ON
[Equipment].[id_tag]=[CRR].[id_tag]
WHERE [CRR].[date_CRR]>=01/01/2006;

although is not doing anything different. It's still bringing me the same
data... can you help me again????
thanks

:

lula,
First, you will need to create a "Date parameter" criteria in your query
that produces the report,. Open the query in design view, pull down the
"Date" field into query, then put youe date parameter in the criteria field
(ex. >=01/01/2006). Save and Close query. Next time you run the report,
you'll only get 2006 data. Hope this helps?
--
Caloyski


:

Hi to all.... I have a question.
I have a report that shows all the Computer Repair Requests (CRR) that
people from the company made to the IT Department. It shows all the CRRs from
the beginning of the database to date. Now, I only want to show the ones that
are for 2006. I don't care now about the ones in 2005.

How can accomplish such a thing?? I have no idea on how to do it.
thank you very much for your help in advance...
Click to expand...
Click to expand...
Click to expand...
 
"PCD" <[email protected]> schreef in bericht
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1150 users have come to me from the newsgroups requesting help '1150 users ????
(e-mail address removed)
Click to expand...

--
To Steve:
Over 550!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R
 
You are nothing but an OBSESSED, egocentric A$$. You revel in tracking every
post I make in the newsgroups and do not make any contributions to our
newsgroup. Take the advise that was given to you by aposter not too long
ago and grow up and get a life. We don't need the likes of you in our
newsgroup! Just get lost and quit filling our newsgroup with your slanderous
garbage!!!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help
(e-mail address removed)




"PCD" <[email protected]> schreef in bericht

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
'Resource ????
Over 1150 users have come to me from the newsgroups requesting help
'1150 users ????
(e-mail address removed)
Click to expand...

--
To Steve:
Over 550!! users from the newsgroups have visited the website to read what
kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dcount question 3
if clause in access 2000 12
Report Question 4
Grouping and sorting 14
New column on report 6
Report Missing Data 2
Monthly Inventory Report 18
refresh on a form 2

Back
Top