how do i find what "query or tables " a report is using . this is on access 2003

I need  to find which tables or query make up a report so that I can then build a new report using some of the fields from the original. This may take more than one table and or query .
Kirk saintSoftware Designer(Trainee)Asked:
Who is Participating?
Ryan ChongConnect With a Mentor Commented:
if you mean just to find out...

go open the report in design view, and then look for the properties: Record Source

Kirk saintSoftware Designer(Trainee)Author Commented:
Thanks Ryan,
I think today the brain doesn't want to work , think it switch of for Christmas already . I knew that too . feel like an idiot .

Ryan ChongCommented:
do you need further assistance here or shall we proceed to close this question?
Kirk saintSoftware Designer(Trainee)Author Commented:
close the question
Ryan ChongCommented:
as proposed
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.