Queries returning different formats

[youkr]

Hello,
I have cut and paste the same expression from a query to another, however
when i do this it changes the format of the information returned.

In the inital query it returns (Hours:Minutes) perfectly, expression is
"LOS (Hours:Mins)":
(EDMain!EDDischargeDate+EDMain!EDDischargeTime)-(EDMain!EDPresentationDate+EDMain!EDPresentationTime).
When I paste it, it returns a decimal value (which I presume is the way
access formats time), and adds '[]' to the expression i.e.
"LOS (Hours:Mins)":
([EDMain]![EDDischargeDate]+[EDMain]![EDDischargeTime])-([EDMain]![EDPresentationDate]+[EDMain]![EDPresentationTime]).
I have tried removing the '[]' however they automatically return. Any ideas
how I get the expression to work in the same way that it does in the first
query?

Thanks,

 

[youkr]

I cant work out how to remove my post - but I have sorted the issue - sorry
for wasting everyone time.

 

[Gina Whipp]

youkr,

You can't remove your post... posting that you found a solution let's us
know to move along... posting the solution is even better as it is bound to
help someone else!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I cant work out how to remove my post - but I have sorted the issue - sorry
for wasting everyone time.

 

[youkr]

Of course...
I changed the format of the return to be 'short date' - this made it the
same as my other query.

is there a way to format it h:n:s? When I tried to format it this way it
just returned 'H:n:s' in every record!

youkr,

You can't remove your post... posting that you found a solution let's us
know to move along... posting the solution is even better as it is bound to
help someone else!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I cant work out how to remove my post - but I have sorted the issue - sorry
for wasting everyone time.

Hello,
I have cut and paste the same expression from a query to another, however
when i do this it changes the format of the information returned.

In the inital query it returns (Hours:Minutes) perfectly, expression is
"LOS (Hours:Mins)":
(EDMain!EDDischargeDate+EDMain!EDDischargeTime)-(EDMain!EDPresentationDate+EDMain!EDPresentationTime).
When I paste it, it returns a decimal value (which I presume is the way
access formats time), and adds '[]' to the expression i.e.
"LOS (Hours:Mins)":
([EDMain]![EDDischargeDate]+[EDMain]![EDDischargeTime])-([EDMain]![EDPresentationDate]+[EDMain]![EDPresentationTime]).
I have tried removing the '[]' however they automatically return. Any
ideas
how I get the expression to work in the same way that it does in the first
query?

Thanks,

.

 

[Gina Whipp]

IYoukr,

I think what you are looking for is HH:MM:SS

How exactly are you trying to use this?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Of course...
I changed the format of the return to be 'short date' - this made it the
same as my other query.

is there a way to format it h:n:s? When I tried to format it this way it
just returned 'H:n:s' in every record!

youkr,

You can't remove your post... posting that you found a solution let's us
know to move along... posting the solution is even better as it is bound
to
help someone else!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I cant work out how to remove my post - but I have sorted the issue -
sorry
for wasting everyone time.

Hello,
I have cut and paste the same expression from a query to another,
however
when i do this it changes the format of the information returned.

In the inital query it returns (Hours:Minutes) perfectly, expression is
"LOS (Hours:Mins)":
(EDMain!EDDischargeDate+EDMain!EDDischargeTime)-(EDMain!EDPresentationDate+EDMain!EDPresentationTime).
When I paste it, it returns a decimal value (which I presume is the way
access formats time), and adds '[]' to the expression i.e.
"LOS (Hours:Mins)":
([EDMain]![EDDischargeDate]+[EDMain]![EDDischargeTime])-([EDMain]![EDPresentationDate]+[EDMain]![EDPresentationTime]).
I have tried removing the '[]' however they automatically return. Any
ideas
how I get the expression to work in the same way that it does in the
first
query?

Thanks,

.