Help...

B

bionicman

Registered User.
Local time
Today, 01:00
Joined
Jul 22, 2003
Messages
145
I am trying to use subreportss (mistake #1) to display information for employees broken down by weeks of the month. so i have a main report that just has a page heading, and it should display the employee name. I then have 4 more reports that display the information for the given weeks (each one is linked to a query to display my information for the dates of the month). So although i do not know a single thing about subreports, i was able to stumble through it and make it give me what i wanted.... here is the problem, i am asked to enter the employee name 4 times (for each one of the reports), because it is linked to it's own query. Is there some way to store the data so that i only have to enter it once? if this is difficult, can you please explain in detail, my access knowledge is limited :)

Thanks
 
Use a form to enter the employee name, then have the queries point to the form to get its criteria.

Look in Access Help under:
reports, criteria to select data to include
Use a form to enter report criteria
 
hhhhmmm either i don't understand again, or i am passed what you are saying.

I already have all of my data, and i have a form i enter the info into.

I have my report setup now, to where it will print the information per person, but i only have one weeks data on the sheet. (for a months data, i will have 4 papers), they would like the data to be on one sheet for easier tracking and trending, so the only way i could think to do so was using a subreport and copy my report (and query) that i am using now. i know this is probably my problem, but i don't know how else to do it. if i don't get it, it is no big deal.

Thanks again.
 
i am asked to enter the employee name 4 times (for each one of the reports), because it is linked to it's own query
Click to expand...

I am assuming that you are using a query that asks for a parameter in the criteria section. True? The criteria would look like: [Enter Employee Name] and that is what you are being prompted with. If you have a form that has the employee name, then your criteria would look like: [Forms]![Frm_GetData]![Emp_Name] and you would not have to re-enter the data for each query.

Maybe I am missing something here ...
 
still could not get it to work.... i am probably not explaining good enough. is there some way i could make a macro to copy the information one time and then have it put it in in the other queries? even if there is not, do you know a place i could learn about macros?

Thanks for all the help
 
Can you zip and attach your DB here? It really isn't that hard once you see the construct, and you will find yourself using it all the time. It really is worth learning.
 
unfortunatly, i can't send the DB because of the information in it.

sorry, thanks for attempting to help anyway :)
 
Make a copy ... remove the information ... populate with just a few dummy records ... zip ... post.
 
Here ya go...

I also included a quick synopsis of what i am wanting.

Thanks again!
 
I made the updates I was referring to. You should be able to recognize my objects. Open the help file I referenced above and follow it while you see how it all works together. Here is a small synopsis:

When you open the report, it first opens a form where you input the info that your query criteria points to that the report is based on.
(I had to delete some stuff to get it to fit here)
HTH
 

Attachments

Excellent, i think this will work for me. I just have a quick question though.

Can you explain this "DateAdd('m',1,[Forms]![Frm_Enter_Criteria]![Beg_Date])" from the query, i don't understand this part.

is this making todays date the ending date?

Thanks again for all the help!!
 
One more question...

I want to be able to run this report based on the call center information instead of the persons name, however i still want it to display each persons information on one page. i changed the "enter criteria" form to point to the call center field instead of the name field, and changed all of the other needed information as well. the problem is that i am getting everyones totals on the same page, instead of it being seperated by employee.

Any ideas?
 
ok... i got it seperated by person when i enter just the call center info... here is my new problem :)

it only shows one line of information again, and it displays "October week (whatever record number i am on) Total"

oh jeez...
 
Have you looked up the DateAdd function in Access Help? Does just what it says. Adds on month to whatever date you put on the form.

You are going to have to change your grouping on the report to being grouped by the CSR_ID or the AlphaName(?) field.
 
OK, i'm sorry, but i still can't get this grouping right. Can you take a look at this and tell me what is going wrong? I have tried to set the grouping by the alphapart, and it still does not come out right....

thanks again!
 

Attachments

I didn't use your db. It seems you have decided to use the subreport method. Try going my direction.
 

Attachments

whoops, i uploaded the wrong one. I am trying to use your method, i just can't get it to sort the way i need....
 

Attachments

Well, work with my last DB I posted. It's all there.
 
ok, still can't get that the way i wanted, so i went back to work with the one that you created. i discovered a problem for me though. if an employee has 0 errors, it throws of the data for the following weeks.

if an employee has 0 errors for week 1, it makes week 2 into week 1, week 3 into week 2 ect. Any idea how to fix this? i know it probably has something to do with ISNULL, but i don't know where to put that into the code.

Any more help would be appreciated... thanks :)
 
You must log in or register to reply here.

Similar threads

D
Trying to total a calculated field form a group footer in another group footer
Replies
5
Views
770
mike60smart
mike60smart
E
Generating report on a dynamic subform
Replies
6
Views
536
The_Doc_Man
The_Doc_Man
S
Solved Report Sent to Printer?
2 3
Replies
46
Views
2,414
arnelgp
arnelgp
mike60smart
Logos
Replies
8
Views
776
NauticalGent
NauticalGent
Safaa
How to display a specific number of records in a subreport linked to the original report with the patient code
Replies
18
Views
1,784
arnelgp
arnelgp

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom