Hi,
I'm building an app that has to use more than one sql statement to get all the data I want. something like this
SELECT date, teacher, room, hour FROM reservations WHERE date = #14-4-2004# AND room = 'B42' AND hour = '1'.

The returned values have to go into labels on a form......
Can anyone tell me how to complete this. The date, room and hour values will be generated by some combolists and a monthdatepicker.



He who dies with the most toys still dies

hello there..

a few things.. why do you need an sql that returns 3 fields that are the same that you are looking for??

the only thing new from your select is the teacher field...

anyway.. do something like this

dim sSql as string
sSql = "SELECT date, teacher, room, hour FROM reservations WHERE "
sSql = sSql & "date = #" & yourdatepicker.value & "# AND room = '" & comboroom.text
ssql = ssql & "' AND hour = '" & combohour.text & "'"

but i suggest you review what you are doing there...


HTH

Gonzalo

thnx, why do I need 3 fields....
This is part of an app that lets the teachers reserve a computerclassroom. They select a date and a room and after that it gets displayed in a nice format that says hour 1 is reserved so you can't have it and so on.....
If I don't do it like this - not enought people here that are not scared of computers and programs- I'll be busy giving support half the time.

I know it is taking the long way home, but my collegues leave me little choice

He who dies with the most toys still dies