I have a query which takes all fields from a table and uses the [DATE] field to match the criteria of the DATE(), hence returning all those relevant records with [DATE]=DATE()

Now if I select all records by using SELECT business.* in the QEB and select the [Date] field and set the criteria to =Date() then the returned record set doesn't include the [Date] field and my form control displays
"?Name".

Why does this happen and how can i get the query to return the field with the criteria parameter in it...?

ANY IDEAS


Cheers

Paul

Is that really a field named Date? if so that's the prob.

actually no! its called APP_DATE. I chose a poor example...problem still remains

Can you help

Cheers
paul

Make sure that the control source of the text box refers to the table name as well as the control name. i.e. business.APP_DATE

Thanks all but that doesn't seem to make too much difference...

Still not sure why using SELECT * with criteria returns field results not in the field name but my query returns them as with the column heading of Field0.

Anyone able to help!!

paul

Try removing the Show checkmark from the datefield. You're getting the Field0 because you're attempting to show the date field twice in your query.

Raskew...

What a guy/gal

I new it was simple. My Query understanding is getting better....

Thanks
Paul