getting data from other queries into a report

[dave.degroot]

Hi, When attempting to get a total from a different query into a
report, I am using the following expression: =Sum([closed overdue
justified]!CountOfsuspense_id+[closed overdue not justified]!
CountOfsuspense_id)

However, this yields two "Enter Parameter" Popup boxes and the result
is really weird.

Any ideas?

 

[Douglas J. Steele]

You can't refer to other queries (or tables) like that in reports.

You could try using

=DSum("CountOfsuspense_ID", "[closed overdue justified") +
DSum("CountOfsuspense_id", "[closed overdue not justified]")

 

[dave.degroot]

You can't refer to other queries (or tables) like that in reports.

You could try using

=DSum("CountOfsuspense_ID", "[closed overdue justified") +
DSum("CountOfsuspense_id", "[closed overdue not justified]")

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

Hi, When attempting to get a total from a different query into a
report, I am using the following expression: =Sum([closed overdue
justified]!CountOfsuspense_id+[closed overdue not justified]!
CountOfsuspense_id)

However, this yields two "Enter Parameter" Popup boxes and the result
is really weird.

Any ideas?- Hide quoted text -

- Show quoted text -

Why can't you use other queries in a report...? That seems rather
limiting.

 

[Douglas J. Steele]

Just like forms, reports can only have a single recordsource.

If you need to refer to other tables or queries, you can use subreports, or
you can use the Domain Aggregate functions like DLookup and DCount.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

On May 1, 5:21 pm, "Douglas J. Steele"

Why can't you use other queries in a report...? That seems rather
limiting.

You can't refer to other queries (or tables) like that in reports.

You could try using

=DSum("CountOfsuspense_ID", "[closed overdue justified") +
DSum("CountOfsuspense_id", "[closed overdue not justified]")

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

Hi, When attempting to get a total from a different query into a
report, I am using the following expression: =Sum([closed overdue
justified]!CountOfsuspense_id+[closed overdue not justified]!
CountOfsuspense_id)

However, this yields two "Enter Parameter" Popup boxes and the result
is really weird.

Any ideas?- Hide quoted text -

- Show quoted text -

 

[dave.degroot]

Just like forms, reports can only have a single recordsource.

If you need to refer to other tables or queries, you can use subreports, or
you can use the Domain Aggregate functions like DLookup and DCount.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

On May 1, 5:21 pm, "Douglas J. Steele"

Why can't you use other queries in a report...? That seems rather
limiting.

You can't refer to other queries (or tables) like that in reports.
You could try using
=DSum("CountOfsuspense_ID", "[closed overdue justified") +
DSum("CountOfsuspense_id", "[closed overdue not justified]")
--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

Hi, When attempting to get a total from a different query into a
report, I am using the following expression: =Sum([closed overdue
justified]!CountOfsuspense_id+[closed overdue not justified]!
CountOfsuspense_id)
However, this yields two "Enter Parameter" Popup boxes and the result
is really weird.
Any ideas?- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

Ah, Ok... I'm a beginner. Obviously! Thanks!

D.