simple query 1

[mikeba1]

I am trying to create a simple select query with data on a form, all ok apart from a date field which is on the form but does not display on the query ???

beaten !!!

SELECT [Forms]![frmCreateDayApptsSTARTA]![Therapist] AS Expr1, [Forms]![frmCreateDayApptsSTARTA]![dayinweek] AS Expr3, [Forms]![frmCreateDayApptsSTARTA]![fordate] AS Expr2;

 

[SkipVought]

HI,

Where's the rest of your query?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[mikeba1]

Thanks for the reply

There is no further query, I just wanted to select data from a form but the date field (epr2) doesn't show although the other two do.
It seems to be a problem with the date field.

Eventually I wanted to use this data in an append query, I just used the select to test my logic.

 

[dhookom]

A simple query should have at a minimum SELECT and FROM clauses. I don't see a FROM in your SQL. Also, has your focus left the fordate control?

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

Thanks chaps

Focus was still on date field

Solved