Mini-report in Report Footer?

[eepok]

MOVED DEVELOPED QUESTION TO QUERIES SECTION
MOVED DEVELOPED QUESTION TO QUERIES SECTION
MOVED DEVELOPED QUESTION TO QUERIES SECTION


Hello again!

Is it possible to append a summarized report of a report in a report footer? (Too much report?)

I have a list of 40 or so records each with values in 12 fields listed in a report. I want to be able to show that:
of all the values displayed, at least one value = X
of all shown, at least one value = Y
of all shown, at least one value = Z

so on and so forth.

The logic for some reason gets all fuzzy in my head when I think about it. I assume that if I simply put

iif( [field1] = "Required Value", "Requirement Met", "Requirement Unmet")

I feel as though that statement would come out as both true and false as it would check against all records in the query.

 

[KenHigg]

Not exactly sure what you're trying to do but I would suspect you could do it with a sub-report - ??

 

[eepok]

Not exactly sure what you're trying to do but I would suspect you could do it with a sub-report - ??

You're right about my lack of clarity. I was describing what the report itself would look like instead of what I would like to do to a query.

I want to search an entire column for a value. If that value exists in that column, I want to output a value.

Iif columnA contains Value1, then say "Gotcha", else "nope, not here"

I think dlookup() may be the right function. Care to confirm/deny/put me in check?

 

[KenHigg]

Seems to me like a dlookup would work.

 

[eepok]

I seem to have run into a snag. I'm pretty sure this would work otherwise:

DLookup(iif(Left( [GenericFieldname1], 4) = "C101","Offered","NOT OFFERED"),"Generic Query")

When I added this field/function to the query, I got #error values and when I clicked on one, I got an error that said:

The expression you entered as a query parameter produced this error:The object doesn't contain the automation object 'Please Enter Year'.'

I assume the problem is that I have the user filter the report by use of the Like() function for [Year] in the query when the report is accessed. How do I tell the DLookup function to search the column as filtered by the Like() function?

 

[eepok]

I'm going to effectively kill this post since its relevance to the Reports section is questionable at best and move this developed question to the Queries forum where it belongs.

 

[JoeyY]

What about...

If I understand you correctly, you may not need a query to get you what you want.

In your original post, you are trying to flag whether a field has at least one required value in it. I believe you can get that my replacing your

[field1] = "Required Value" expression with a DCount expression.

=IIf(DCount('[field1]','tableorqueryname',"[field1]='Required Value' ")>0,"Requirement Met","Requirement Unmet")

 

[eepok]

If I understand you correctly, you may not need a query to get you what you want.

In your original post, you are trying to flag whether a field has at least one required value in it. I believe you can get that my replacing your

[field1] = "Required Value" expression with a DCount expression.

=IIf(DCount('[field1]','tableorqueryname',"[field1]='Required Value' ")>0,"Requirement Met","Requirement Unmet")

I tried this expression in a field on the report and then just putting it in the query and I keep getting the same error as I listed above (2 posts prior). It's really bugging me because logically, what you suggested seems like it SHOULD work.

Do you think it has something to do with the query criteria I have?
For the [Year] field I have the following Criteria: Like([Enter Year]). This is to allow the user to filter the query to the fields relevant to that year.

 

[JoeyY]

Yes, I think using the criteria [Enter Year] in DCount is a problem.

There is probably a better way to do this, but you could try adding a field (ex. [othertextfield]) with a control source of

IIf([field1]='required value',1,0)

under 'Detail' and set the 'Visible' property to 'No' and the 'Running Sum' to 'Over All' and then put in your text field

IIF([othertextfield]>0,'Requirement Met','Requirement Unmet')