Rookie Query question

[Danny]

I am working on a database in Access 2007 that keeps track of the contracts
our department uses. I can add new vendors and contracts to the table, but
I am having trouble trying to run a query so I can see what contracts we
have by vendor and/or date. Any help is greatly appreciated.

 

[bhicks11 via AccessMonster.com]

Hi Danny,

What trouble are you having and what have you tried? You could make a
parameter query that asks for input of vendor or date when run or you can
pass the parameter(s) from a control on a form. To make a parameter query
you would put something like this in the criteria of the vendor field:

[What vendor?]

To grab the criteria from a control on a form you would put something like
this in the criteria:

forms!whateverform.whatevercontrol

Bonnie
http://www.dataplus-svc.com