To create view with parameter

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

Please anybody can advice me with the steps to create a veiw with parameters
in MsAccess 2007 . I have the following colum

invoicemonth numeric
invoiceyear numeric
invoiceamt double

the parameter

where invoicemonth >= ar_monthfrom and
and invoicemonth <= ar_monthto

Please help . It would be very helpful.

With thanks

Pol
 
Are you saying that you want the user to be prompted for ar_monthfrom and
ar_monthto?

Put the following as the criteria under the invoicemonth field in your QBE
grid:

Between [ar_monthfrom] And [ar_monthto]

Or are you saying that ar_monthfrom and ar_monthto are fields in another
table linked to the original table via an Inner Join?

Go into the SQL of the query and replace the ON clause with your
inequalities.
 
Back
Top