I desperately need to know how to count how many records have an entry in
this particular date field. It gets complicated because I need to make sure
it only shows records where 2 sets of criteria's are met first. I have an
'Area' field with about 4 options, then I want to see ...

I have two tables in my query.  Table one is call "Claims" table two is
called "Billed"  The claims table has a field called "policy number" which
will match with the billed table field "policynumber" in the query.  I get
the results what I needed (inter join), but there are two ...

I can’t understand why my query is returning nothing – I have set 2
criteria in the query design:
DATE DEPOSIT RECEIVED  <> IsNull    i.e. presence of date indicates deposit
received

Came Across some interesting reading, enough for me to see if I can do the
same thing.
This guy writes he has a form that has (1) a combobox where he reads from a
table. (2) command button that runs a query where the criteria is based upon

I need help creating a query criteria that would reveal any sequential
price range increase of $3 or more over a period of so many days. So,
if we have a closing price history going back several years and we're
trying to see any consecutive increase, like from $33 on 4/1/01 up to

i have a query that consists of various fields among which i want to
manipulate the following:
i have a unique field (ID) for which i have multiple entries on the
following fields:

I need a query that will take the first 200 records that fit the parameters
(or, any 200, as long as they meet the query parameters and we do not get
more than 200).  I do not know SQL, so I need something I can do in query
builder.  Can anyone help??

I want my query to show unmatch results of two tables.  For example in one
table I have certain rows of data that are not in another table.  I want to
show those rows that are not in the other table in my query.

I have a query that requests a from and a to date from the user and
then finds records that fall between the 2 dates. I have also got a
calendar control in my database. How can I change my query so that
instead of a box appearing to request the date, the calendar contol

I am running a query that uses the WHERE Clase on a lookup field. The lookup
field contains lookup dates. I have noticed that they are not stored as
dates. Coud anyone help in figuring this one out please?
Thanks

I have searched and not found THE answer to this problem. I have a date
field which I need to find the date a week later, i.e. Date to Close +
7 = DateToCheck. No matter what I try in the query to insert the
expression, whenever I run the query I am asked to supply a parameter.

I am using MS Access 2003.I have a client who is using our service a certain
number of times during the contract. The information is entered using forms
and the details given are the Start date, end date and frequency(either
weekly, fortnightly etc.) I would like to calculate the ...

I am using a parameter query [enter days] to retrieve records whose dates are
more than [enter days] beyond today. I am using Expr1:
DateDiff("d",[invoiceDate],Date())in the field box and then using[enter days]
in the criteria line. This returns dates more than 30 days from today ...

Hello to all,
I recently began to support an access 2000 application programmed by
someone else than me.  The original programmer poured a couple of
thousand hours in it, so you can expect it to be huge.  He is not an

Still learning Access, am used to Excel/VBA.  I asked this question at
MdbMakers.com (formerly AccessVBA.com) and it's still not working right for
me.  (Link: http://www.mdbmakers.com/forums/showthread.php?t=19767)
I have a query I want to produce.  There are multiple fields in a ...