Hello experts in Access!
I'v got some problem with a query. In this query there are several connected
tables.
When I run a query  I get empty lists. For example there is some info in

I am having a little bit of trouble with a query of mine relating to
training courses. This query is supposed to look at the last date a person
took a particular training course and calculate a "DueDate" based on that.
From there, I would like to see what quarter and year, ...

I think there's a bug in an ODBC driver (Advantage ODBC 9.0.0.1).  Here's
the SQL:
SELECT TRDATA.ACCT, repolog.Acct, TRDATA.STATUS
FROM TRDATA LEFT JOIN repolog ON TRDATA.ACCT = repolog.Acct

I am having an interesting problem with mail merge.  I have a query which
will not show up on the mail merge window.  I see other tables and queries
but not the one I am looking for.  So experimenting around I removed all of
the criteria (i.e. looking for a specific month [month ...

I have a table like this:
tblEACodes:
==============================
SK    AQ_FKEY   aqeEA_FKEY

Hello Access experts!
I have a question is it possible to make more text fields in a query? I have
a query that needs to take out a lot of info from connected tables. The numbe
of text fields that I see in query design is 17. Is it limited or there is a

There’s a table, with the format:
Table1:price,with only one column.
I want to use query to Make it output as follows:
1.

I am having trouble constructing an Update query using Lpad. I keep getting
an "unidentified function 'Lpad'" error message. The same happens in Query.

Hello NG,
is there something like SUM, but for strings?
I can do
SELECT SUM(colname)

Hi..
i want to find a number (employee code) and if that exists in the table
(employee master), then retrieve the rest of the details of that record and
display those deails in either textboxes or labels (which would b not

I have downloads from the bank including
check numbers containing leading zeros.
eg 0002356, where what I want is just 2356.
How do I enter formatting in the query column

I have a table 1, information of customer, primary key custID;
Table 2 , information of accounts, primary key account number, one account
number is under  one custID.
Try to link two tables to generate a query with all the fields of table

I seem to have developed a talent for breaking Access. I have a table of user
data with near-duplicate rows. I want to pull out the most recent account for
each user based on their name (yes I know this is not robust, the "John
Smith"s will be under-represented,  but that's ok).

I'd like to have an EXISTS clause in and ORDER BY Clause, but I keep getting
a syntax error, even though it looks clean.
Here it is:
ORDER BY  Exists (SELECT [Record-Details-Sales].[ID] FROM

I would like the query to display product under warranty for 90 days from the
repair date(s) and display product that have expired past the 90 day warranty
up to 30 days