I have been racking my brains how to sort this one!
eg A
APPOINTMENT DATE   Difference in Days
20-Nov-03                      0

What would be an equivalent Access query for this SQLBase query?
select @nullvalue(@nullvalue(d.warehouse_id, ln.warehouse_id),
co.warehouse_id ), 0, from location;
Thank you.

I have a field which I need to break up in 3 different ones. This field has
the following format:
XXX YYYY ZZZZ
XXX YYYYYY ZZZ

I want to create a query that displays ONLY records where the two
joined fields are equal. The catch is that I only want the first 4
numbers in one field to be used otherwise it won't work.
Field 1                   Field 2

I'm trying to add a primary key (Unique Index) on a table via a SQL query,
but it's not working the way I expected.  My SQL is:
Create Unique Index Unid
On mytable (Id);

I have a table (Table1) with questions: each row has a question number
(1,2,3,4...) and the text (e.g. "Date of Procedure", "Procedure", "MD Name",
"Start Time", ...).  A separate table (Table2) contains the answers: in this
table each row is for a particular case and has columns ...

I used the example database DUANE HOOKOM has on a website, so I hoping he
sees this and responds.  I am not by any means a programmer and welcome all
input.  A person in my company used crystal reports to dump all of the
information into an Access database.  Every incident is ...

I have a table of sales orders having the following columns:
SalesRepID SalesRepName MonthofSale Product Type Amount
1                       AB            Jan2006        C                 10
1                       AB            Jan2006        C                 10

Hello wise ones,
I am using Access 2003, but working in an Access 2000 database.
I am trying to create a subform that will show a delivery schedule for the
next 7 days.

I have create an query in access like blow, which named spProductList:
SELECT ProductID,ProductName,CategoryID FROM Product
And I want to do a filter by CategoryID,then create an another query
named spProductListByCatID:

SELECT [q#Asgnmnt].CallID
FROM [q#Asgnmnt] LEFT JOIN [q#CallLog] ON [q#Asgnmnt].CallID =
[q#CallLog].CallID
WHERE ((([q#CallLog].CallID) Is Null));

I have a text field in a database where several rows are apparantly empty.
However when I try and apply criteria to a Query to return only these rows, I
can't get them. All of the following return 0 rows:
IsNull

Strange problem.
I have a set of databases combined in a query in order to make some
documents in Word: confirmation for visit, document to the chef de cuisine
with some details....

I have a program (Thermodata Suite) that has been designed to automatically
download information from temperature data recorders (i buttons). The default
database with this program is an ACCESS database. It has 3 tables:
Loggers – this table records information about each logger ...

I have a table say table A with customer information.  I need to count each
pending record for each month where the ReceiveDate <= that month, but the
CompleteDate is null or > that month, and have it broken down by for each
month of a quarter.