I know, it not query related, but I'm looking for any help. I have a Access
2K database running fine for a couple years with a VFP ODBC link and
networked with about 25 users. Recently two things have happened. About half
the users are Access 2003, and the ODBC link datafiles ...

I'm trying to write a query that will look through the master database table
and a file import table, compare duplicate account numbers, and only update
the master with new information based on the last payment date on said
account number. However, the date the original data was ...

I have seen the responses to the calculating ages questions and see that Tom
Lake's response to Todd does work.  However, I need to produce the child's
age in years and months.  The db is for a child care center where the more
exact age is needed.  I do not want the age in months ...

I have a main form with a tab control that contains several tabs showing
subforms. On the main form, users are required first to select a state and
then to select a series of categories from cascading combo boxes. When
specific values are selected in the third ...

I have a db that has only a single table.
Each record contains 55 fields.
Most of the fields contain a value of 1, 2, 3, 4, or 5.
The rest are text fields that will simply be printed.

I am working with a database that tracks when patients need their next
visit. Each visit must be 90 days from the last. I did this using a query
"NextVisit: [Current Visit]+90". That works. However, I need to see all
patients per team that are coming up to a visit. I also need to ...

My task is to convert an old MS Access database with Austrian Schilling
values into Euro. I use the following update statement:
UPDATE RateTrain SET Rate=Rate/13.7603;
This basically works fine! The problem is that, for example, the value 31 is

i can not send an e-mail to a DVD company. There basically is no send button

I have a transactional table called Tickets.  It has fields such as Date,
Item, Amount, and Type.  I have a query called ProductRevenueQuery1 which
runs against this Tickets table and is designed to list all items sold for
the week. I use a date restrictor to do this along with a ...

I am trying to create a mailing list of everyone in the database, but I do
not want duplicate records to show. I am going to use the phone number as the
search field, but i don't know what critera to put in the query to check for
this. Do I have to delete the duplicate records ...

Here's what we currently have - a query that looks for information in
a certain month of a range of years. So, for example:
#>8/31/2005# AND <#10/1/2005#
#>8/31/2004# AND <#10/1/2004#

i need assistance extract the following
12345 from 3001-12345Y
653 from 2007-653Z
23 from 4009-23p

I have created a small database for a reporting system.  As candidates are
allowed to choose the subjects they take, some of the subject fields will be
empty for most candidates.  I used the #2 outer type of join to relate the
tables in a query that consist of candidate name, ...

Some time ago I asked if there was a way to get around the fact that queries
became case sensitive when linked to oracle tables.
No one answered so I assumed the answer was no. The other day I stumbled
across the strconv function. Got it out of a PC Mag article on excel macros.

Is there any kind of "command prompt" in access to allow you to directly
type SQL in and get results returned?
Thanks