query not picking up form dat

[mikeba1]

the following query is not working properly

SELECT RoomBookings.Patient, RoomBookings.Therapist, RoomBookings.Appdate, [Forms]![frmreportga]![fd] AS fd, [Forms]![frmreportga]![td] AS td, 1 AS noof, RoomBookings.TimeFrom, RoomBookings.TimeTo, [Forms]![frmreportga]![ddon] AS roomdon
FROM RoomBookings
WHERE (((RoomBookings.Patient)=[Forms]![frmreportga]![memkey]) AND ((RoomBookings.Appdate) Between [Forms]![frmreportga]![fd] And [Forms]![frmreportga]![td]))
ORDER BY RoomBookings.Appdate;

the fields fd , td and ddo are not displayed from the form
HOWEVER the fields fd and td are dates and are used in the where section and they do work properly.
Why do they work in the where section but are not displayed

thanks

 

[lespaul]

so you want the values from your form to be in the query results?

Leslie

Have you met Hardy Heron?

 

[dhookom]

Where are you not seeing the form/control values: in the actual datasheet view of the query or in a form or report?

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

Yes I want to pass data from the form into the query

Running the query the values are not displayed in the query and underlying report

 

[traingamer]

What about:

SELECT RoomBookings.Patient, RoomBookings.Therapist, RoomBookings.Appdate, [Forms]![frmreportga]![fd][b].value[/b] AS fd, [Forms]![frmreportga]![td][b].value[/b] ...

Are [td] and [fd] text fields?
(What you have works just fine in my test database either with or without the .value when I'm using a text box.) (Access 2003 using Access 2000 format).

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[traingamer]

Ignore earlier comment.
When working with dates in calculated fields, use (tested):

..., RoomBookings.Appdate, [red][b]DateValue([/b][/red][Forms]![frmreportga]![fd][red][b])[/b][/red] AS fd, ...

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[dhookom]

Are you closing the form at any point?

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

Thanks everyone.
DateValue works fine.
The form is closed when the report is closed.