-- if column has datatype money then you can use query i've mentioned
earlier.
-- or else you will explicitly have to convert numeric value to money.
-- see 2nd query below.
create table t(money_column money)
insert into t values (123456)
SELECT '$' + CONVERT(VARCHAR(50), money_column, 1) AS column_name
FROM t
-- query if datatype is not meney
create table t(money_column int)
insert into t values (123456)
SELECT '$' + CONVERT(VARCHAR(50), cast(money_column as money), 1) AS
column_name
FROM t
Re: Please Help with Query Calculations ... As for the other fields I put SUM but its not summing them up. ... of the query, go up to View and select Totals. ... maybe a few more fields) and an Sum the Amounts Owed and Amounts Paid... is several dates of when people were billed money and paid money. ... (microsoft.public.access.queries)
Re: Doctors Income ... That you pose the query you do in the vague/open-ended form in a way ... Even way out here in the bowels of fly-over country, I'm often pleasantly surprised to discover the depth and breadth of info that the libraries place at my fingertips. ... Of course, every other budget cycle the libraries are targets for the politicians who want to spend the money on sexier projects, so vigilance is always necessary. ... (soc.retirement)
Re: Update Query & Expression Help ...AccountID integer,...Qtr1 money,... > I have a Query I want to run, to update a field in the MASTER table. ... > examine 4 fields each record of MASTER to find the Highest Max value; ... (microsoft.public.access.queries)
Re: My design - where did I go wrong? ... > money S1, ... Is it the combination of CustID and SaleDate? ... then the query will be as fast as possible. ... beyond the 4th decimal is lost in a money data type,... (comp.databases.ms-sqlserver)
Re: Time fields ... Put two calculated fields in the query:...time difference and the other to calculate the money.... <MS ACCESS MVP> ... (microsoft.public.access.dataaccess.pages)
