{Probably a stupid question....

[loriek]

How can I tell where a report is getting it's data? I've got a report that I thought was using a query to build off but I've renamed them all and the report still runs...

After that, I need to figure how it's requesting parameters such as a valid date so if you know that answer, please clue me in.

Thanks.

 

[MajP]

In design view go to "properties", "data" tab, "recordsource". You can create a query specifically for the report by clicking the three ..., and this will not appear in the database window.

 

[dhookom]

Open the report in design view and find the Record Source property. This is where the records come from unless you have some code that modifies this property.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MajP]

Beat ya.

 

[dhookom]

MajP,
And more complete also ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[loriek]

That was great.

What I haven't solved yet is how to have the query prompt me with a like statement. For example, select * from mytable where myname like [enter a name here]

The only thing I can figure out is "Select * from mytable where myname like [] and then input *joe*

 

[dhookom]

IMHO parameter queries aren't adequate user interface. I use references to controls on forms for all criteria. Your SQL might look like:

SELECT *
FROM MyTable
WHERE MyName like "*" & Forms!frmMyForm!txtMyTextBox & "*"

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]