Query field from form

[Ian Rhodes]

Have have a table that is created from a spreadsheet to create an
appointment diary with 30 field names (27 names of clinics) which gives
me 30 columns. The first three columns are date day time. I want to set
up a query with four fields that will allow me to use criteria on the
first three columns for date day time. I then want the forth column in
the query to switch between the remaining 27 fields by being fed from a
list box on a form. The subform of the query would then just display
the info for that clinic.

Any help greatly appreciated

 

[MacDermott]

While that sort of table design can work well in Excel, it's extremely
rarely appropriate in Access.
Do you have to import the data repeatedly from the spreadsheet? Or can
you set up your own table structure in Access?

 

[Ian Rhodes]

MacDermott wrote:
I upload the spreadsheet every four weeks after the availability has
been programmed in. about 20 of the clinics vary their availability
each week so makes it very difficult to use a roster programme. I
looked at some of the available programmes but none would allow us to
block slots in such an ad hoc fashion. The access programme works fine
apart from when I want to show a clinic individually without having 30
different forms. Hence one form selecting the field by list box

regards
Ian