Data Display Help

[FadingAPE]

I'm in need of some help!

I work in a GP Surgery and I am trying to create a form that will display who is 'On Call' for that day. I have created a table that has a months worth of schedules in but I only want the form to display who is 'on call' that day not for the month.

Can anyone help me at all please? It would be much appreciated.

I have good knowledge of Access but not to the point where I'm a Pro!!! i.e VBA

[NoellaG]

Hi,

without any knowledge of your table structure, and form/report you use to display the one "on call" it's very hard to help...

grNG

[FadingAPE]

Ok,

I have a table that has 5 columns,

ID (Auto number)
Date (Date&Time)
Urgent Care Doctor AM (text)
Urgent Care Doctor PM (text)
Stand By Doctor (text)

So far in this table I have entered all of Octobers schedule for our Urgent Care Surgerys.

I have not yet created the form as I was unsure where to start. I know how to create forms just not how I go about making this one,.. whether I'll need to create it by query or whether to create straight from the table. What I want is for the Receptionist to be able to go onto our database and view, in a simple form that I can add to maybe our main page as a subform, who is Urgent Care Doctor for that morning and afternoon and the standby for that day also. So it will need to update itself everyday. I want to keep it as simple as possible really.

Does that give you a clearer picture of what I'm trying to do??

Thanks

[NoellaG]

Hi,

First of all I would change the name of the field [Date] ; As "Date" is a reserved word in Access this could give you a lot of trouble. You could name it ConsultDate or so. Personally I also wouldn't use spaces in object names.

To show the names of the Urgent care doctors, just create a single form with as recordsource:

select * from [your table name here] where ConsultDate = Date()

Date() is a function that returns the current date.

grNG

[FadingAPE]

You're a star thank you so much - you don't know how much that was doing my nut in! I think I'll need to invest in an advanced manual or something. Your help is much appriciated!!