Im using the design view to build a query, and what I need to extract
is all the fields which value is all digits. I've found the suggestion
on this group which says it should be formed like this:
Not Like "*[!0-9]*"

Is there a way to pass a password using a remote Query?
If the following "c:\database.mdb" is password protected, running  the
following results in a "not a valid password" error. Is there a way to pass
this password with the query?

I have a report that links two tables together, "Contacts" and "Calls".  I
have created a query (see below) that has an inner join so I can display all
of the wholesalers that don't meet certain criteria in a report.  However,
only records with linked data in both "Contacts" and ...

I need to add criteria to pull through all records where visit date is
current month and next 2 months (i.e. 01.09.06 to 30.11.06).  Can
anyone advise what I should do?
Many thanks

I have a query that sums daily oil production and groups it by month. This is
a make table query. I use DateValue(Format([Date],"mm/yyyy")) to group the
date by month. In the table the field for the date still shows a day value
(i.e. 1/1/2006). This is okay but I need the field ...

Hello Fellow Access User!
In my data, I have two fields that contain dates, say Field1 and Field2. I
have a query that creates another date field, say Field3, so that if the
combination of Month&Day in Field 1 (say 51 for 5/1/2005) is greater than the

Hello!!
When I create a query on multiple tables, it becomes sometime impossible to
edit the result of the query.
I know that it has to deal with the index of the table that are joined, they

I had a quick search for this but couldn’t find anything.
I have a one to many relationship. Unique ID in table 1 and multiple in
table 2. Table 2 also has a code name for each occurrence. I want these codes
names brought back into one string in table 1 against each ID. I did it ...

I'm trying to extract information in an Access table into another table
which shows information in a tabular format.
For example the table I have consists of basically a list of staff names
along with skills/training they have undertaken for example;

I have a query that runs fine until I put >0 in the criteria.  When I do that
and try to run the query I get an error "OVERFLOW".  The SQL for the query is:
SELECT FullYrDeprMichele1.intAssetCost, FullYrDeprMichele1.AccumDeprec,
[intAssetCost]-[AccumDeprec] AS [Book Value],

I recently had my PC shut down suddenly whilst Access 2003 was open
and appeared to loose some queries. They reappeared when I selected
"show system objects".
But! I cannot open some of them - I get "could not read definitions;

Hi: I try to print data from LastValidTech even one of the condition
Join/Where dont match. But it shows empty record.
SELECT
LastValidTech.Account1,

I have a Query which stores the prices
charged by suppliers.
I need to keep a record of price
fluctuations, so this would mean storing any

I have a simple table in Access with four cols, as an output from my
GIS:
BUILDING_ID , ROAD_ID , ROUTE_ID , DISTANCE
The table shows the distance of each building from each road, and many

I have a table used to sign up students for a class.  The maximum per class
is 20 in each class and I use a unique class ID for each course.    How do I
have the number of people who sign up stop when the class is full?
I use a query to count the CourseID.  If the participation ...