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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"pol" <(E-Mail Removed)> wrote in message
news:03A2E68B-9E89-4A46-9F9C-(E-Mail Removed)...
> 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