Access query expression issue

[angela.gay]

I have a table that includes a list of all payments (check number,
amount, supplier, date). For each payment there is one of three
different company numbers associated with it. I made a query that is
able to return all records within a user defined date range. I now
need help creating a query that will pull out of that query, but I
only want to see all of those records that are for a specific company
number which the user will need to define.

Please help, I am super new at Access and I can’t seem to figure this
one out.

Thanks a bunch.

 

[John W. Vinson/MVP]

I have a table that includes a list of all payments (check number,
amount, supplier, date). For each payment there is one of three
different company numbers associated with it. I made a query that is
able to return all records within a user defined date range. I now
need help creating a query that will pull out of that query, but I
only want to see all of those records that are for a specific company
number which the user will need to define.

Please help, I am super new at Access and I can’t seem to figure this
one out.

Thanks a bunch.

A "Parameter Query" is what you need here. The simplest way would be
to put

[Enter company number:]

on the Criteria line under the company field.

Better would be to create a little unbound form, frmCrit let's say,
with a Combo Box on it, based on the Company table. Use a criterion of

=[Forms]![frmCrit]![comboboxname]

to select just records for that company.