Can Access format the data presented to the query?

  • Thread starter Thread starter Noozer
  • Start date Start date
N

Noozer

Hi!

Just wondering if MS Access can format the data presented to an SQL query.

For example, if I have a table with 10 digit telephone numbers and I store
only the digits, is there a way to tell Access to format the column as (###)
###-#### so that SQL queries on that column (with no extra formatting code)
see the data in that format? If so, is it smart enough to accept data in
that format and pull out the data required to go back into the table?

Thx
 
Hi,


Try to transfer you data as data, and apply the "decoration",the
formatting ( $, grouping the thousands, etc) in a form you use to display
the data. The formatting just change the appearance, NOT the data behind,
not the data as it is stored in the table.

That being said, you can format each selected column in the query
designer (remember that the data stay data, a format is just added
decorations): LEFT click on the bar on top of the column, the bar just on
top of the line Field; have the properties visible and the "Field
Properties" will be displayed with 5 properties under General, among them,
you have the Format property that you can use for the formatting of the
result.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top