querys and reports


G

Guest

The problem i am haveing is, I have a query that works ( calcs the total due)
and when i run it the values come up just fine... I cant seem to get my
report to see the query and when i try to "run" my report it brings up a pop
up box that asks for the values instead of getting them from the query....
what is the proper way to address the query in my report. query name is
totalcalc and report is report1. any help would be great! thanks! the more
detail the better as i am preaty new to access :)
 
Ad

Advertisements

T

tina

is your report bound to query totalcalc? or to some other query or table?
how are you *currently* trying to get the report to "see" the query? we need
more info before we can help you troubleshoot, please.

hth
 
G

Guest

my report was "started" useing the wizard from a table called maintable, i
have no idea how or if my query is bound to the report. i just went in to
the record source of the field in my report and used the builder box thing
haha
it reads =[query]![totalquery] and when i would run the report it would
pop up a box asking for the values.
i also tryed entering the calculation directly into the record source of the
report and i did get values but thay were all wrong. the data i got was all
the records added together, not the indivual records in a list. but the other
data was showing corectly like this:
customer id 1 billing data "the right date" total bill 300.00
customer id 2 same same total bill 600.00
customer id 3 same same total bill 900.00

it should have been:
id 1 total bill
150.00
id 2 total bill
50.00
id 3 total bill
100.00
i hope this helps... i am at a loss. help!
 
Ad

Advertisements

T

tina

okay. the *ControlSource* of a control can't be bound to a query in the way
you described. to find out what the RecordSource of the report is, open the
report in Design view, and in the Properties box click on the All tab and
look at the RecordSource.

remember, we can't see your database, so you'll need to describe the report:
does the report show individual records, or just aggregate information? how
is the data in the totals query related to the data showing in the report,
and where do you want to display it?

hth


datahunter said:
my report was "started" useing the wizard from a table called maintable, i
have no idea how or if my query is bound to the report. i just went in to
the record source of the field in my report and used the builder box thing
haha
it reads =[query]![totalquery] and when i would run the report it would
pop up a box asking for the values.
i also tryed entering the calculation directly into the record source of the
report and i did get values but thay were all wrong. the data i got was all
the records added together, not the indivual records in a list. but the other
data was showing corectly like this:
customer id 1 billing data "the right date" total bill 300.00
customer id 2 same same total bill 600.00
customer id 3 same same total bill 900.00

it should have been:
id 1 total bill
150.00
id 2 total bill
50.00
id 3 total bill
100.00
i hope this helps... i am at a loss. help!



tina said:
is your report bound to query totalcalc? or to some other query or table?
how are you *currently* trying to get the report to "see" the query? we need
more info before we can help you troubleshoot, please.

hth


total
due) a
pop
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top