Two formatting questions 1

[cranebill]

I have a timestamp in a field that I would like to just show the daye in a query, in Oracle I would use Trunc(date)... what would be the correct function for access to do the same?

Format question # 2

In Oracle I could use a decode in the select portion of a query to change the way a result looks...

for example if a field showed 0 then the query would show "No". Is there a function that I could use with this?

 

[PHV]

Have a look at the Format function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cranebill]

Format worked for the date...

any ideas about the second question?

 

[PHV]

Format([your field],"Yes/No")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886