Hello I am a newbie in Access 97.
When I run the query :
SELECT DISTINCTROW MAX (TbTrans1.Date)
FROM TbTrans1

in design view have a DOB field (date of birth)
need the query to find those 18 and older....thus the criteria would need to
be a DOB that is:
< CurrentDate - 18 years

I have inherited a database that has rather a personal method of taking
telephone numbers i.e. 12345c ext 1234, Mob12345, EX12345, 12345ex dir etc...
I want to run a query that will trim out all the non numeric chaacters but
don't know where to start.

I am having problems with 1 query.  I keep getting a timeout error.  I have
changed the timeout value in the control panel on the data source, I have
changed the timeout under tools/options and I have also changed the timeout
value on the query itself and no matter what I do I ...

Is there any way that I can pass a variable (year) to a cross tab query.
I know I can "hard code" it into the query itself as a selection but I want
to leave it so that a user coming in after me can change the year without
having to access the query itself?  If I can not do this, ...

...though I'm not so sure myself!
Hello,
From the following list in a query
product

Irun a query to build a temporary table of staff who have completed a
training course in the last 12 months.  Some people have done this
course twice in that period.   Can someone advise how to alter the
code below so that is only shows the most recent date entry per

I have a table than joins several other tables and it consists mostly of
AutoNumber records. The query gets the results I want, but displays them as
AutoNumbers.  Whenever I try to add another table to get meaningful
descriptions I get an error of either Left or Right Join errors ...

On building a query based on 10 subqueries, the time to run is pretty fast.  
On adding 5 more for a total of 15, it's about 20 seconds.  If I add even one
more, the query doesn't come back.  I only need 22 subqueries and my work is
done...

In a query, under field, I have the following:
Month: Format$([dateQArelease],"mmmm yyyy")
In this query I also have Analyst and Count: Analyst.
This is an example of a line from the result returned:

I have a very complex matrix of 15 columns and 70 rows. The matirx has 49
potential results. Each of those results in one of 17 codes. I have 20000
lines of data that have the various factors that are part of the matirx and
need to eventually end up with one of the 17 codes. I am ...

Hi there I would like to be able to filter words with a certain length and
format and then delete the last 2 letter of that word using a query update.
Any ideas?

For financial and budgeting purposes, we want to allocate a total project
value across the 4 quarters of the year based on the start and end date. I'm
looking at calculating either a weekly or daily average based on the date
range but I'm stumped as to how to best distribute the ...

I have an access 2003 db and I wish to produce a report.
The report is based on one record and its information.
The information is contained in the 'main table' and some of this information
is obtained by selecting from a cbo attached to a 'look up table.'

Got a query with two tables in it, but when in database view or in a form
using the query, you can't edit the data.  Anyway to fix that?
Curtis