Formating query output

[Guest]

I have 2 queries that pull the identical currency-formatted field from a
table. When I run the queries or use the output in a report, one query has
this field left justified and one has it right justified. I looked at the
properties of each and they are both blank (I highlighted the top row of the
query in Design view, right clicked and went to Properties.) Is there some
other place where I might find the difference?

 

[Brendan Reynolds]

Look at the SQL. (SQL View from the View menu in query design view.) If you
still can't see it, you can copy the SQL view and post it here.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Michel Walsh]

Hi,


Access can remember a format for each explicit column in the grid. Right
click on the column grid to get the properties of the column. Note that
there is also the possibilities that the columns are not of the same data
type: strings are left justified, integers are right justified.


Hoping it may help,
Vanderghast, Access MVP