If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query field from form
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
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 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |