To create view with parameter

[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

 

[Douglas J. Steele]

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.