Specifying Data Type in a Query(non-parameter)

[Faction21]

How would you specify the data type for say, shortdate in a query when you calculate time? Or if I wanted to add and subtract numbers with a fixed decimal point.

I know you can specify datatype with a parameter query, but then it asks for the parameter, which I dont want. Is there any way to do this?


-thnx

 

[Mile-O]

How would you specify the data type for say, shortdate in a query when you calculate time? Or if I wanted to add and subtract numbers with a fixed decimal point.

I know you can specify datatype with a parameter query, but then it asks for the parameter, which I dont want. Is there any way to do this?


-thnx

Just format it. If it's a calculated field then it makes no difference. As long as it looks good.

 

[Faction21]

I did format the field, but the problem is that Im not saving this data, im using the calculations as I need them.

In particular im calculating time, and on my form it works just fine, but in my query it comes up as a negative double number.

 

[Mile-O]

In particular im calculating time, and on my form it works just fine, but in my query it comes up as a negative double number.

That's how dates and times are stored and treated. What did you format it to? hh:nn:ss should show a double data type as a date.