results of query on a report

  • Thread starter Thread starter LGarcia
  • Start date Start date
L

LGarcia

Hi,
I have to create a summary report. The data I need to summarize exisit in
different tables. I have queries which calculate all the numbers I need.
These numbers aren't related in any way so I can't create a query to base
the report upon. I have placed text boxes on a report and I'm trying to use
the queries as source. This is what I get using the expression builder:
=[qryProj1Totals]![TotalFFQ]
On the report I get #error as a result.

Can someone point me in the right direction?

Thanks!!
LGarcia
 
-----Original Message-----
Hi,
I have to create a summary report. The data I need to summarize exisit in
different tables. I have queries which calculate all the numbers I need.
These numbers aren't related in any way so I can't create a query to base
the report upon. I have placed text boxes on a report and I'm trying to use
the queries as source. This is what I get using the expression builder:
=[qryProj1Totals]![TotalFFQ]
On the report I get #error as a result.

Can someone point me in the right direction?

Thanks!!
LGarcia



.
you don't say if each of the many unrelated queries
Click to expand...
returns one record or many records.

if one record, suggest you set the recordsource of a text
box to show a value from a specific query, as
=DLookUp("FieldName","QueryName")

if multiple records per query, suggest you create a
subreport for each query.

hope this helps.
 
there are 4 which of return a single record. the dlookup works perfectly!
there are 2 which return multiple records. I'll work on the subreports.
Thanks!

tina said:
-----Original Message-----
Hi,
I have to create a summary report. The data I need to summarize exisit in
different tables. I have queries which calculate all the numbers I need.
These numbers aren't related in any way so I can't create a query to base
the report upon. I have placed text boxes on a report and I'm trying to use
the queries as source. This is what I get using the expression builder:
=[qryProj1Totals]![TotalFFQ]
On the report I get #error as a result.

Can someone point me in the right direction?

Thanks!!
LGarcia



.
you don't say if each of the many unrelated queries
Click to expand...
returns one record or many records.

if one record, suggest you set the recordsource of a text
box to show a value from a specific query, as
=DLookUp("FieldName","QueryName")

if multiple records per query, suggest you create a
subreport for each query.

hope this helps.
Click to expand...
 
Back
Top