Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Filtering on more than one field

0 views
Skip to first unread message

KR

unread,
Nov 10, 2009, 10:22:01 AM11/10/09
to
I need help filtering more than one field on my form.

Table Names and Info:
Data (has all the patient info. including type of device and country)
Countries (list all 81 countries in database)
Study (list all 10 devices)

My form is called: DataFM I want to be able to filter all of the records in
the data table by the type of device (there are 10 devices:
A,B,C,D,E,F,G,H,I,J) then I want to be able to filter by Country (there are
81 Countries, no duplicates).

Any suggestions as to how I can do this?

KARL DEWEY

unread,
Nov 10, 2009, 11:55:01 AM11/10/09
to
Use a query to feed your form and have criteria for Device and Country.

--
Build a little, test a little.

0 new messages