Re: Data style?

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 02/02/05 

Date: Wed, 02 Feb 2005 22:04:53 +0100

On Tue, 1 Feb 2005 20:39:35 -0800, Wendy W wrote:

>Hi, I would like to change the data output style
>generated from the SQL query. So, how can I go about
>doing it? Example : display 59766 as 59,766 and also
>datetime as date.
>
>Please help....thanks a lot!
>

Hi Wendy,

The formatting of the output of a query is entirely up to the client. If
you access the same data using Query Analyser, Enterprise Manager, Access
and some other tools, you'll already see a variety in formats used, as
each of these tools has it's own defaults.

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • Re: mySQL Problem
    ... Don't be an asshole again, ... one of which is that your screen realestate is far less expensive than spending the time it takes to debug non-functioning queries...especially when the query is more complex that what it seems you've written in the course of your experience. ... I said your method of formatting is lousy. ... And in the almost 25 years I've been doing SQL, I can probably count on two hands the number of experienced programmers who write SQL as you did. ...
    (comp.lang.php)
  • Re: Simplest way to create a report to look like a mail merge document
    ... For simple mail merge letters without Word, consider the Query By Form ... You could also send the report to Word for further formatting. ... > called (c/w writing an appropriate data file). ...
    (microsoft.public.access.reports)
  • Re: CAPS and Date/Time formatting
    ... Just a question about UCase. ... In a query where there is a join, ... The date/time formatting was perfect! ... The> in the Format property merely displays the data in upper case, ...
    (microsoft.public.access.reports)
  • Re: mySQL Problem
    ... when was i being an asshole at all, jerry? ... queries...especially when the query is more complex that what it seems ... your method of formatting is lousy. ... version of formatting sql v. the way I format mine. ...
    (comp.lang.php)
  • Re: Query is failing in Runtime
    ... I have a query that I call to fill a list box. ... formatted fields - formatting phone from just numbers to include ... strOrder = " ORDER BY LastFirst" ... strOrder = " ORDER BY Address, ...
    (microsoft.public.access.queries)