I have a form in which the user will select a value from the combo box,
which then passes the value to a query. The value being passed though,
corresponds to the name of a field in the query. I would like to return
records where the value of the selected field is not null.

I have a table in which I'd like to depict a rotating shift schedule. I can
generate a complete rotation in Excel and then import into Access, but I'd
like to automate the process by using a query. How do I build a query to
append to my schedule table?

I would like to create a query with 3 fields (columns).
First column: ID (primary key field)
Second  column: Sugar cane species (duplicate records)
Third column: Average productivity for the respective sugar cane species

Im a SQL Server developer who is currently using Access, so I'm
probably doing something really dumb. I have a simple query that is
searching on the criteria WHERE field = ''  ie find me the records
where the text field is blank. I have two such records but the query

I have a query that I would like to use based on the 6th character.  The
first 5 characters can be whatever, but the 6th character needs to match
whatever is entered.  I know how to use the "like" criteria I just don't know
how to make it count over the 6 characters.  Any ...

I am running into a problem with the following code that I am testing.  I
get a syntax error on the third DDL SQL statement.
I can't see what I am doing wrong.  Perhaps what I am attempting is not
possible using DDL and I will have to use DAO to build the relationship?

I have a database. My main table is a STUDENTS file. Each week I run an
update query to add a new record to the ATTEND file for each student, adding
in a week no (WEEKNO) and a date(EMADATE). I pick up the values I want from a
table tblDATEFILE

I am trying to create an employee schedule - 24/7 tracking.   What i would
like to see is a report or datasheet form with the hours 7AM-6AM on the left
side as rows and the days of the weeks, M-Sun, as column headings - and i
would like to know the total number employees working ...

Access 2003
On 3 PCs the query works, on two PCs it gives the error message
Undefined function DATE
when I use Date()    as a query Criteria

My table has only three fields: Date, Price1 and Price 2
I need to know if, during the first 7 days of the month, price2 was $4 more
or less than price1 was on the first of the month.
I developed my query using the wizard and then tweaked it because I couldn't

I have two queries, one based on another.
The first query is this.
And is called "QHasChecks"
SELECT tblChecksTMP.ChkTabID, tblChecksTMP.ChkPaid,

For a parameter for a report, I have a multiselect listbox to choose
districts.
Using a global variable, I form a string with all the codes of the districts
that were chosen.  I have checked the string and the lists of district codes

How does one seach a 'type date' field (e.g.; 11/17/2007) for a bank entry?
Ed

I am using Access 2007 and I have a table tblCustomer that lists customer id,
name, address, city, state, zip, contact first, contact last, telephone
number, and fax numbers for each customer. I have 25 records but some records
are missing information in various fields.

I have a simple table of dates over several years and two fields of prices
in dollars for each date.  I want to write a query that would look at ONLY
dates that are from the first of the month to the seventh of the month,
compare the two prices, and return to me only those dates ...