Hi.  I hope someone can help me. I have a Projects table I would like
to query on 2 date columns. I want to calculate the difference between
the "requested delivery date" and "shipment date" columns. In order to see
which orders were delivered late. I want this to come up ...

I have a program that uses Access 2003 and VBA. I have several queries
that need to be dynamically generated. For example, I want to get all
the information about a particular program from the program table.
Currently I would construct an SQL string and execute it as follows:

I am trying to do a database search using LIKE using the following code:
Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles btnSearch.Click
If Page.IsValid Then

I have a database for a fundraising organisation. They want to know who they
can go to so if someone gave a donation in the last six months then they
don't want to go to him so i did a query for that but then if the guy gave 2
donations and his first one was given more than six ...

I am trying to perform a query in Access using the LIKE operator. When I use
the following SQL command:
SELECT members.organization, artists.artist, artists.email, artists.website
FROM members INNER JOIN artists ON members.memberid = artists.memberid WHERE

I am doing a select query for a lookup list (bound to a form) for street
names (to alleviate frequent misspellings by the users) and when I did
the initial select query, it came up with several blanks in the dynaset
(some of the records don't have a street name assigned yet).  How ...

I am setting up a parameter query. I need to know if there is a way to put up
a error message if the input by the operator is not valid. For example if the
users has to search for a name and the name is not in the database a message
pops up and says wrong name entered

I am trying to use the following expression as criteria in a query:
IIf([forms].[frmreportsmenu].[cbolocation].[listindex]>0,[forms].[frmreportsmenu].[cbolocation],Is
Not Null)
The problem is that I never return the value - Is Not Null... at least it

Hi there -is it possible in a query that if the value in one field "is not
null" to read true in a check box in another field within the same query.  
Thanks

am trying to construct a Query using anoither query and table.  for each
employee in the Query there are multible entries in the Table.  Currently the
Query shows all entries equal to the empNum and PosID but multilpe prioritys.
I want to select the Top 01 for prioity which ...

I GET AN UNIDENTIFIED FUNCTION MESSAGE WHEN I TO OPEN A FORM WITH DATE()
FUNCTION IN CRITERIA IN AQUERY CAN SOMEONE TELL ME HOW I CAN FI X THIS

I have two fields.  A return date and a sold date.
I want to have the criteria for the return date to be "if the return
date is greater than the sold date field"  (basically to check if
something had been returned before it was recorded as bought so I can

I have a drop-down menu that has 6 choices (A, B, C, D, E, F).  They convert
loosely to fields in a table (i.e. Last Name as choice, LName as field).  I'm
trying to right a single query that will look at the choice and then pull the
corresponding records.

I have two access 2003 tables.  One is Client and contains name, index#, and
age... The other is HistoryOfWhoClientDated and contains index# of client and
index# of someone they dated.  I want to list every client and give a list of
at least 4 people they have NOT dated before ( ...

How can I convert a date to the beginning of the nearest odd numbered year
that is equal to or before the selected year?
 Example: 6/15/05 would convert to 1/01/05
               4/15/06 would also convert to 1/01/05