queries with * ??? Whats that all about then...

[paulmcdonnell]

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

 

[Rich]

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

 

[paulmcdonnell]

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

Can you help

Cheers
paul

 

[DJN]

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

 

[paulmcdonnell]

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

 

[raskew]

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.

 

[paulmcdonnell]

Raskew...

What a guy/gal

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

Thanks
Paul