Report Field Problem

[cc143most]

I am still not understanding why I cannot get this field to work. Karl has
been kind enough to give me code, but I can't get it to work, either. So,
I'd like to try again.

I have a query that combines two different crosstabs. My columns are:

Month
Branch
Hospital
Link_Total
Declined by Fam.... (multiple reasons/columns)
Declined by Us....(multiple reasons/columns)
Obtained by.....(multiple reasons/columns)
Declined
RO
Obtained

My report is by Hospital (one on each page). I need the Months of the Year
to be my column headings with a TOTAL at the end. My reasons are now my Rows.

I cannot get the report to pull the right Link_Total for the right month. I
have written a function in the control property field every which way I know
how. SELECT [Total_Link] WHERE [Month]="Jan", etc. It is just not working.

Can I not do this at the report level? Do I need to create another query of
some sort? I had originally pulled in my raw data one month at a time, but
thought I needed it all on one table and/or query for my report since I can
only select one record source.

Can someone PLEASE help me understand?

Thanks so much!

 

[Duane Hookom]

I don't have a clue what you original posts were but there is a solution for
creating monthly crosstab reports at
http://www.tek-tips.com/faqs.cfm?fid=5466.

There is also a method for creating a crosstab with multiple values at
http://www.tek-tips.com/faqs.cfm?fid=4524.

 

[cc143most]

Duane,

Just looking at the link, I "Might" be able to figure this out. Thank you
so much!

I don't have a clue what you original posts were but there is a solution for
creating monthly crosstab reports at
http://www.tek-tips.com/faqs.cfm?fid=5466.

There is also a method for creating a crosstab with multiple values at
http://www.tek-tips.com/faqs.cfm?fid=4524.

--
Duane Hookom
Microsoft Access MVP

I am still not understanding why I cannot get this field to work. Karl has
been kind enough to give me code, but I can't get it to work, either. So,
I'd like to try again.

I have a query that combines two different crosstabs. My columns are:

Month
Branch
Hospital
Link_Total
Declined by Fam.... (multiple reasons/columns)
Declined by Us....(multiple reasons/columns)
Obtained by.....(multiple reasons/columns)
Declined
RO
Obtained

My report is by Hospital (one on each page). I need the Months of the Year
to be my column headings with a TOTAL at the end. My reasons are now my Rows.

I cannot get the report to pull the right Link_Total for the right month. I
have written a function in the control property field every which way I know
how. SELECT [Total_Link] WHERE [Month]="Jan", etc. It is just not working.

Can I not do this at the report level? Do I need to create another query of
some sort? I had originally pulled in my raw data one month at a time, but
thought I needed it all on one table and/or query for my report since I can
only select one record source.

Can someone PLEASE help me understand?

Thanks so much!