I've changed a SubForms recordsource from
Select TheDate,....
to
"SELECT Format([TheDate],'dd mmm yyyy') AS ChartDate,...
But then the field becomes #Name?
However if I paste the query into design mode and run it, it is okay.
The form is datasheet and I don't know where the Format property for the field.
Can I get around this anyhow?
Select TheDate,....
to
"SELECT Format([TheDate],'dd mmm yyyy') AS ChartDate,...
But then the field becomes #Name?
However if I paste the query into design mode and run it, it is okay.
The form is datasheet and I don't know where the Format property for the field.
Can I get around this anyhow?