I am trying to find experation dates of products  in a 90 day window.  ie, if
product expires 06/30/06 it will show, if product expires 10/30/06, it will
not show.  I have tries the following with no luck, they both show all dates.

Hi there,
I think the answer to my question is fairly easy, but for some reason, I
just can't figure it out!!  I must still have vacation brain.  ;-)
Anyway, here it goes.

I'm creating a database to track student tardies. I have one table that
contains the student info, with StudentID as the primary key. I also have a
Tardies table that uses Date and Period as combined keys, and also has a
Remarks field and is joined on StudentID in a one-to-many ...

I have three update queries updating Letters to Numbers to produce a graph.
Origin Field  > [Bank]
Update Field > [UBank]
Criteria =

I've got two tables:
(1) Rate table -  details the rate charged from a certain date (two columns:
date and rate)
(2) Transaction table -  details transactions executed as per a certain date

I'm trying to make a query with the criteria from the 1st day of the
current year to now. Right now, I am using the criteria:
Between [EnterStart Date] And Now()
But the user always uses the first of the year of the current year.

It may be  trivial.
What is the right syntax in SQL to delete all records from " mytable" where
myfield is empty ?
What is the differance between null and empty string?

I have a somewhat LONG sql query that's not working for me.  Seems simple
enough.  I have two tables.  I just want to count the number of times the
record appears in the sub-table.
Main Table is Donors

I have a system that records when a customer calls.
The date / time is entered (in one field formatted as date time).
eg: 27/05/2006 6:02:03 PM
I want a query to count the number of calls that occur between certain

Just started at a new workplace and this error popped up on one of the user's
computer and I'm trying to fix it.
Basically there's a query that used LCase on one of its text fields, and the
following error occurs:

I need to come up with a way that from a drop down list when the user makes a
selection, the next drop down list, lists only a group of choices that can be
picked.
For example the first drop down list has:

Hi group,
I'm rather new to Access so bare with me.  I have a table of survey
results where a person could answer yes or no.  If they answered yes
then the appropriate cell is filled in with a yes.  However if a person

I want to select records between two dates by am not getting the final date.
I am sure it has something to do with Access defaulkts of 12.00am in date
calcs and need a solution.
My data set example is as follows

Hi all..
 What I need to do is create a query based on the following.
 If the location has a hit before or on July 4th 2006.  If it does show me
all the hits including the one(s) that are on July 4th, 2006.

Hello Group,
I have a qry using [WOID] as the criteria to pull up a number of records.  
The criteria is set at 28286.  This produces 8 records.  Another field in the
qry is [PROID].  Of the 8 records, 4 have a [PROID] of 91234 and 4 have 94321.