How can I use the "< or <=" operator(s) in this situation
<(In(select [dateField] from [tbl_dates]))
I want to circle tha values in a table (which I can do) but use the boolean
operator as a filter condition.

I'm trying to extend a date which is based on a dated in one field and a
number of weeks in another field.
When I entered this:
=ExtendedDate:[DateEntered]+[InternalLTW]*[7]

I have a large number of SQL pass-thru queries that look at a particular SQL
server and database.  For an extensive upgrade, I'm setting up a test
environment on a development server.  Rather than going in to change each
connect string, then going back in to change it back again ...

I have a table of notes. Notes are tied to a Project ID so any particular ID
could have several notes. I would like to do a query that would pick only the
latest note for each project number. Any help would be appreciated.

Seems too simple to be so difficult..
Table looks like:
Sales No    cust    Count    Amt
GA    576    6    ($4,010.58)

How would I go about setting up this criteria?
I have two fields from the same table
LOB_CLASS and IRS_CD. If LOB_CLASS = "61" and IRS_CD is not equal to "4"
then show W2 in a made up field named "1099/W2". If the above is different in

Here is my SQL statement
SELECT a.name, b.meterno, c.meterstatus, d.accountno, d.creation_date
FROM fmdata.location a, cisdata.service_meters b, cisdata.meter_master c,
    cisdata.Account_Master d

I have this query:
SELECT tblA.*, tblB.cID
FROM tblA LEFT JOIN tblB ON tblA.fNum = tblB.fNum;
Now I want to see all the records from tblA and the cID from tblB if

I'm trying to insert a list of values from a table into the where
clause of a query. I have a several sets of values stored as text that
I'd like to use as criteria in a query on a different table, for
example,

I want to change the default information which prints at the top/bottom of a
query – currently I have the query name and date in the “header” and page
number in the “footer”.  
I see from Page Setup that I can uncheck Print Headings to remove all of

I'm joining two files, one has anumeric filed that after the querry runs the
out put is text. This has been work fine for years, just happened in the last
week. access2003

when i run a union querry acces is changeing the field format from a number
to text. I use the output of this querry to make a chart in excell. before i
would have months 1-12 now 1,10,11,12,2....

In a table I log the user's IP when the connexion is made. I'd like to query
the mostly used IP, meaning:
userID             date     IP
1          10012006        1.1.1.10

I want to make a query for search by enter a value from a column.I maked
this with this code [Enter a value] writed on criteria field of the column.
But now I want this search to be on 2 columns at the same time.
Example :

OK, I have some sample data, not real good with IF statements in Access, Need
to know if it can be done with the reult I need and how the iIF statement
looks.  If this can be done, thank you in advance for the help.
PackagingString                      Result