Multiple Columns from 1 data field

K

kjk

I am creating a report based on a query and need to know how I can
reference the same field over again in a tabular report. Example: the
field is called description and shows 'cap' or 'exp'. Instead of doing
a report and just grouping or summarizing by these values, I need to
show separate columns for 'cap' and 'exp'. Any ideas would be
appreciated. If I need to explain myself further please let me know.
Thanks in advance.
 
L

Les

I hope I understood your post. You could create 2 column
headings and 2 text boxes on your report, but not have
them tied directly to your query field. Instead, create
expressions for the report text boxes. Something like:

=IIF(queryfld="cap","cap","")
=IIF(queryfld="exp","exp","")

This way, if the query field equals cap, your cap column
gets a value. If it equals exp, your exp column gets a
value.

Hope this helps.
 
Top