using make table queries in report wizard

[1-acxi-1]

Hello, try to create a report my make table queries are not available
in the drop down (but their resulting tables are) I'm trying prompt
using the make table queries when the report loads. it prompts on the
query but can't be pulled into the report.

does any one know how to use make table queries in reports?

Also, does anyone know of a site or add-in for report designs, we're in
desperate need of ideas.

thanks.

 

[Steve Schapel]

1-acxi-1,

A Make-Table Query is an action query. Its purpose is to perform a data
operation, not to return a data set. You can't use a Make-Table query
as the Record Source of a report. Can you say a bit more about what you
are trying to achieve? Why is is you can't use the table that the
Make-Table query produces as the report's Record Source?

 

[1-acxi-1]

Well I'm trying to create monthly reports to be generated on a special
key, and the reporting tool we're using (MARS reporting, have you ever
used this) requires a parameter to check against and send the
appropriate report. When i use a make table query i can use the
parameter prompt but it doesn't ask for it in the report. we're
trying to send an individual instance of the report per client.

thanks.

 

[Steve Schapel]

1-acxi-1,

What is the criteria that the prompt is asking for? And what is the
record source of the report... the table that the Make-table makes, or
something else?