User Prompt to select field in query?

M

marelcon

can I set up a select query to prompt the user to ask for the name o
the field to filter? Each month in my table has it's own field and
want the user to specify which month to run the "Is Not Null" filte
on. Otherwise I'll have to have 12 queries..
 
K

KARL DEWEY

Dates need to be in a single field and not in 12 different fields.

This said you can prompt one time and used the same criteria on different
rows and under each field.
JAN FEB MAR APR
[PMT]
[PMT]
[PMT]
[PMT]
 
M

marelcon

The data is arranged by events that happen in various months. It wa
originally a spreadsheet and if that event happened quarterly it woul
have a Q in Jan Apr Jul and Oct columns. Each event is a record.

Each month I want to filter the data for just that month - henc
wanting to query what is now a field in Access
 
K

KARL DEWEY

I do not think you can get your data out the way your table is laid out. You
need to revise so it is in database style instead of spreadsheet.
 
Top