Filter

  • Thread starter Thread starter shapper
  • Start date Start date
S

shapper

Hello,

I created a SQL query as follows:

SELECT *
FROM Books
WHERE Value>[@Min];

I then created a report.
How can I make my report to use this query as a filter to the records
that should be displayed?

Thanks,
Miguel
 
If this query has all the fields which your report requires, then open the
report in design view, click on Properties, click on the Data tab and, next
to Record Source, choose the name of your query.
I'm assuming here that @min is a Parameter rather than the name of a field.
I'm also assuming that Value is the name of a field. Is that correct? I'm
no Sql expert. I'm not quite so comfortable about that, if that is the case,
because VALUE is a word used in VBA coding. If you ever come across
inexplicable errors (reports which suddenly show Datatype mismatch for
instance, when there is no mismatch, queries which work until you copy and
paste them and other weird happenings) then you may need to consider
renaming that field.
Evi
 
Back
Top