I was wondering how I can get my numbers to two decimal places? I have it
working in access but then I try and put it in an asp site using dreamweaver
and it removes the zeros when i'm using: Round(labour, 2) AS Labours
Is there another method I need to use if it's currency I'm ...

I hae a series of quieries rolled into a macro.  Large amount of data
and many transitional steps results in an hour or more runtime, and of
course, lots of messages saying there is inusfficient memory to undo...
Now, I have seen the Reg fix where you increase the the number of ...

If this has been answered already, or is better answered somewhere else, then
please let me know.
I have done many joins in Access before - to databases in Access, on SQL
server and to Excel spreadsheets. However, I have hit a problem that I don't

I have the following code
   Public Function f(strSql As String, ...
   ...
   r= CurrentDb.OpenRecordset(strSql)

I have a database of my residents with DOB and age. I need to create queries
by age groups and I don't know how to do it, can someone please help me?

I have a function that creates a custom list of values.
I want the values to be usable from a query such as this one.
SELECT *
FROM tbl

Can anyone help me out there?
I have a subform, and when entering data into the field and when that field
has lost focus I ask it to check the value in that field and if it is 0 then
a msgbox gives advises user that they must enter a number in that field.

I got a question concerning a query.
In this query I combine columns from several tables and other queries.
Besides that there is a calculation in this query for a new column. The
simplified query result looks like this:

Hi
Can anyone help me with this.
I have a subform where I enter items which are orderlines, the row contains
a field called subtotal which adds up the total of that row, a simple sum

In my query I have a field called Rec'd date it has a date and time stamp.
How can I show only the date but not the time in my query.  Any help will be
appreciated.  Thank you in advance.

I would like to find the MAX value from 3 fields (i.e. f1, f2, f3).
I could do this the long way with IFF (i.e. iif(f1>f2 etc), but is there a
function like MAXA that can do this? Am using Access 2k with SP3
Rgds,

I have 2 queries that have data. I have a join query that joins all the data
together. In one of the columns (in both queries) there is the phraze
"$Free". I need to change that to "Free".
From what I can understand, I can not do that function after the union. Is

I have 2 tables called Listino1 and prenotazioni
my data in prenotazioni right now are:
ID_prenotazioni    ID_hotel            id_room    tipo_room    nome_room    pax    sell_q    dal        al
1        24 Roma: prova 2        1    dbl        standard        2    1    20/06/2005    25/06/2005

Help!  I have a program in which there are two tables (more than 2, but for
now...). Table A has fields that include CustomerID (autonumber, primary
key).  Table B has fields that include CustomerID (Long Integer) and PetID
(autonumber, primary key).  Table A--parent--is linked ...

I have used Access a little and want to know how to compare last week sales
to this week sales or last month to this month etc
Thanks for any replies
Bert