Report to only show specific information

[markswan20]

I've looked on the forum and i think my problem lies with the use of filters.

I have many records on my database 212 on the one table to be exact I have 2 departments when an order is placed it is given a department number. The 2 I use are WFBG and WFJB, following these department numbers is the autonumber from the table.

My problem is this, the department numbers are used to define which person does the specific job. At the end of every month each person invoices us for work completed and we pay them. Now we have lots of customers and don't want to sift through each record to locate each one.

Is there a way I could create a report that could display all the jobs for a specific month that the specific person did?

Kind Regards
Mark

 

[Crowley16]

firstly, you might want to ask report questions in the access report forum instead of this one...

onto your question.

in the underlying query used for the report, can you not specify which department to look for?

e.g.

select blah from blah where LEFT(DEPT, 4) = "WFJB"

you can replace the "WFJB" with forms![frmName]![CtlName] if you want to be able to specify which department from control on a form...

--------------------
Procrastinate Now!

 

[markswan20]

Apologies for posting in the incorrect forum, i did look but couldn't find the report forum.

Anyhows i'm relativly new to reports and i don't understand your response could you elaborate a little or could you place a link so i can search the reports forum.

Mark

 

[Crowley16]

this isn't about reports, it'a about the underlying query you're using to get the records for this report.

I'm assuming you've based this report on a query, so in your query, you need to restrict the records you're getting, you can do this in various ways, the easiest being a WHERE clause...

just google for JET SQL and you should be able to find lots of examples

--------------------
Procrastinate Now!