By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,985 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,985 IT Pros & Developers. It's quick & easy.

Name of query/table from where values are pass into table

P: n/a
There is a form where it ask the two dates and then run a query then
report.

Private Sub Command36_Click()
DoCmd.OpenQuery "qryResultsReport"
DoCmd.OpenReport "rpt_TopTen", acPreview, "", ""
end sub
qryResultsReport
SELECT tblCallSummary.* INTO tblResults
FROM tblCallSummary
WHERE (((tblCallSummary.[Date/Time]) Between
[forms]![MainMenu]![txtStartDate] And
[forms]![MainMenu]![txtEndDate]+1));

When i open the report rpt_TopTen the values which pass into the report
is totall different the values which are in that table. How to i know
the name of the table/query from where the values are comming into the
report. I am trying to find the name of table/query but i dont know how
to i find the source. For example when i click on the properties of one
textbox it shows some thing like that in the control source:

=Sum([Connecticut])

Another textbox control source shows some thing like that:
=[CombinedCountOfCallID]/Sum([CombinedCountOfCallID])

None of these variables are found in the table. I need help how to I
know the name of their table or query from where the values pass into
the report.
Thank You.

Aug 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Baz

<co*********@gmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
There is a form where it ask the two dates and then run a query then
report.

Private Sub Command36_Click()
DoCmd.OpenQuery "qryResultsReport"
DoCmd.OpenReport "rpt_TopTen", acPreview, "", ""
end sub
qryResultsReport
SELECT tblCallSummary.* INTO tblResults
FROM tblCallSummary
WHERE (((tblCallSummary.[Date/Time]) Between
[forms]![MainMenu]![txtStartDate] And
[forms]![MainMenu]![txtEndDate]+1));

When i open the report rpt_TopTen the values which pass into the report
is totall different the values which are in that table. How to i know
the name of the table/query from where the values are comming into the
report. I am trying to find the name of table/query but i dont know how
to i find the source. For example when i click on the properties of one
textbox it shows some thing like that in the control source:

=Sum([Connecticut])

Another textbox control source shows some thing like that:
=[CombinedCountOfCallID]/Sum([CombinedCountOfCallID])

None of these variables are found in the table. I need help how to I
know the name of their table or query from where the values pass into
the report.
Thank You.
With the report open in design view, click on the square in the top left
corner. If the properties window is not already open, press F4. Click on
the "Data" tab. What you are looking for is in the "Record Source".
Aug 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.