How to change the properties in SQL view

[kloot1rr]

In this query I have setup I need to get my Dates field into short date format and another field needs to be with 0 decimal points. I take it there is code I have to enter but I cannot find it anywhere.

 

[bob fitz]

Please post the SQL statement of your query

 

[kloot1rr]

here it is, union query

 

[JLCantara]

The solution is a bit tricky (note that I don't understand why you want to do that at the query level...):
1 - Create a new query using the union query as a data source.
2 - Define a column for every select items.
3 - For the date column: select it then right click it, then select properties and there specify your date format...
4 - Do the same with real numbers...
Good day.

 

[spikepl]

What difference does it make what the properties are in SQL view?

Such things are set in forms and reports. You do not access SQL views during normal operations.