Here's the table:
acct_id char(4)
age      int
acct_bal currency

I have a field "REF" where the first part of the text is common but the text
in brackets is not. The text lenght varies as well:
REF
Application progess (oc:Mr C Battin)

I have the following expression in a query. I need to sum this colum. How?
I tried changing the total to sum. No change in data. Still displays all
records.
Expr1:

I am trying to run a query from a 900MB table. I have successfully ran the
query (about 4 million records), but when I try to save it, an error message
appears stating "invalid argument".  I have saved a similiar query just like
before.  Why will it not allow me to save this one? ...

I am trying to find an average for 52 different fields and the query won't
calculate.  When I initially set it up, it worked, but after I started
inputting data in the other fields it stopped.
Here is the expression I'm using:

an someone please assist me in fine tuning this query?
My ultimate goal is to get the first 50 results back from the [15]
columns where the field is 0 (zero).
Here is the SQL statement as it now...

What is the formula to figure out what week of the current month?
for example: today is 7/27/05 so it is the week 4.  i want my query to say
"week 4"
Thank you!

I have a macro that I run daily that imports information from a server.  When
I run this macro I am constantly getting the above error when the information
is not available for a particular import.  I would like to set this up on a
schedule, but have to run it manuel in order to ...

I have a table that includes dates in a "DATE" field.  How do I design a
query to pull records, where the date in the "DATE" field would equal today's
date?  Thanks.

I am trying to convert the a date like 20050621 to a numeric format in the
same layout as shown.  I  made a new function in the data base to do this
converting (see below) but everytime I try an run it in the query I get the
Undefined Function  ConvertDatetoNumeric in Expression. ...

  I got the next doubt:
  Im developing an Agenda. But I need to know if there's a way to have a
watchdog to update the table in anothe user.
i.e.

Ihave the following expressions in my query. I trying to convert a stiring
date into a real date. format is 20050727
This one works fine.
LetDate: CDate(Left([PUBLIC_T_CONT_CRIT_DT].[ACTL_DT],4) & "/" &

i am making a gui, and i am using a query to find a record with a
user-inputted ID number.
for example if i use ID number of 4, the search goes as planned, but you
have to scroll through the records before it comes up, as if you were just

Can someone please assist me in fine tuning this query?
My ulitmate goal is to get the first 50 results back from the [15]
columns where the field is 0 (zero).
Here is the SQL statement as it now...

I have two tables with an Index of 3 fields. I want to append table 1 to
table 2 if the index is not same. Can the indexes be compared like that in a
querry? I had to have three fields in one index because each time 2 of the
three fields are same in both tables. Currently I have ...