Help...

[bionicman]

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

 

[pdx_man]

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

 

[bionicman]

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.

 

[pdx_man]

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

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 ...

 

[bionicman]

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

 

[pdx_man]

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.

 

[bionicman]

unfortunatly, i can't send the DB because of the information in it.

sorry, thanks for attempting to help anyway

 

[pdx_man]

Make a copy ... remove the information ... populate with just a few dummy records ... zip ... post.

 

[bionicman]

Here ya go...

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

Thanks again!

 

[bionicman]

ok, let me try to attach it again...

 

[pdx_man]

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

 

[bionicman]

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!!

 

[bionicman]

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?

 

[bionicman]

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...

 

[pdx_man]

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.

 

[bionicman]

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!

 

[pdx_man]

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

 

[bionicman]

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....

 

[pdx_man]

Well, work with my last DB I posted. It's all there.

 

[bionicman]

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