Dlookup on cross tab query?

[cram]

Hi all,
I'm trying to pull a specific value from a cross tab query for a report. Is Dlookup the proper function to use?

Also, I need to key off the column name instead of the column index for the appropriate field, because the query is dynamic.

Any thoughts?

Thanks,
Cram

 

[dhookom]

Any value that displays in a crosstab can be pulled from a standard totals query. Your column heading is just one of the group bys in your totals query. Crosstabs are great when you are looking at multiple rows and derived columns. It's over-kill when you want to return only one value.

Duane
MS Access MVP