Recent content by ShawnH

Format is not necessarily required. I'll switch this to a report and group it that way. Thanks for your help (again)!

Ok, the other form that I was using to display numbers is attached. I think this one does have to be a crosstab, unless I'm not thinking outside the box. Any recommendation on this?

To be honest, I really do not know why I went with a cross tab. I'll switch it to a total query. Same info, cleaner, and easier to work with. Thank you!

Here's a dump of my the main table with dummy data and unnecessary fields removed. The cross tab tells me: Of the individuals that have referrals assigned to, how many referrals are in each category. Both Assigned to and Referral Status is a drop down menu to a look up table.

No real reason why it's a form vs. report. I could easily make it a report if necessary. I just made it a form since it was displaying info, vs. needing to print etc.

Hello, I'm having a problem with a form and was hoping someone can help. I have things assigned to individuals and those things are in different status. I have a crosstab query to count the number of things in each category, per individual. I have a form based off of this crosstab query...

This is the IIf statement that I used =IIf([subreport name].Report.HasData,[subreport name].Report![control],0)

Thank you! This is how I fixed the #Error =IIf([subreport name].Report.HasData,[subreport name].Report![control],0)

Hello, I have a problem with a report and I was hoping someone can help me out. I have a report that has several sub reports. It could be possible that sometimes the sub report(s) returns with no records, which is fine. When viewing the report in report view, the sub report is displayed with...

Disregard, I figured it out. The clause should look like this [qry_Traveler_TDYs]![Course_ID]=[Forms]![frm_Add_Edit_Course]![Assign Travelers]![Course_ID] AND [qry_Traveler_TDYs]![Traveler_SSN]=[Forms]![frm_Add_Edit_Course]![Assign Travelers]![Traveler_SSN]

Greetings, I have an issue that I cannot figure out and was hoping someone here can help. I have a button on a sub form that I need to open another form where two fields equal on both. I have built the WHERE condition and it works fine if I only have one field to match [Course_ID] =...