Queries returning different formats

  • Thread starter Thread starter youkr
  • Start date Start date
Y

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,
 
I cant work out how to remove my post - but I have sorted the issue - sorry
for wasting everyone time.
 
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.
 
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!

Gina Whipp said:
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 said:
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,
Click to expand...

.
Click to expand...
 
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!

Gina Whipp said:
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 said:
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,
Click to expand...

.
Click to expand...
 
Back
Top