I have a database for managing a review process that has several steps.  The
data are stored in the table tblCAR.  Each step has an employee assigned to
it.  The employee name is selected from a combo box that uses the Roster
table (tblRoster) as its row source.  The EmployeeID ...

I am trying to create a query with parameter entry c/w list/combo box for the
user to chose? But i can't. Pls help.
Eg. [Enter the Stock Name] { I hope that a list/combo box will come together
with the prompt so that the user don't need to know what the stock name}

This is my first attempt at writing a subquery...I am trying to return the
top 3 records for each itemname. Here is what I have written:
SELECT tblProduction.Date, tblProduction.ActivityName,
tblProduction.ItemName, tblProduction.Qty,

My Table has Few Fields two of them hold dates. the two date fileds are
"FROM" and the other is "TO". I want to be able to run a query that will
bring me back the upper limit from the "FROM" field and the lower limit from
the "TO" Field.

All,
I know the issue is in the number of quotation marks that surround the variable however with every attempt to solve the problem I continue to get and "Enter Parameter Value" dialog box or the sequel returns no records.
SELECT [_Print].[printID], [_Print].[printTitle], [_Print] ...

I have a Query that includes Authors,Rating Books and other fields. The
criteria control is in Rating Books and is (is Null). This criteria will
list all the unread books, but will not list Authors who do not have unread
Books. I would like to show all Authors irrelevant of ...

I have a table with the following
Master Stock Code
Header ID
and I want to append this information to a table, kind of ike a cross tab

I have a DB that creates new tables weekly for tracking changes to
another system.   When I launch the DB I would like to have a button
to open the most recent table that I am working on.  I know how to
create the button but I don't know how to specify the table that I

I have a Query that is used to support a read-only continuous form.
I am trying to include a Comments section in this form where only the most
recent comment is shown.
It was suggested through this forum to develop a SUBQUERY within the main

My queries are truncating memo field after 255 characters.  I want the entire
memo field displayed

Attempting to place this in a query .... DueDate: DateAdd("y",3,
[MyDate]) returns an error message "undefined function 'DateAdd' in
expression"
Also placing =DateAdd("y",3,[MyDate]) in the control source in a text

I am trying to find how many people of a certain sex returned in the same
year and it keeps giving me both records of the same person. How do i get it
to return only the one record. Also if there is a null response it needs to
return a zero.

Hello,
i am importing a excel table to my access database and i want to delete the
first two rows of the table. these two rows are above the field headings. is
this possible, or it's there a better way to do it. help will be appreciated.

I set up a query for the report, there are two criteria,
one is date for enter the begining date and ending date, another one is for
example group1 & group 2. I set this criteria for group2.
but it doesn't pick the recent data for group 2, it only picks the old data

I would like to combine 3 fields with 3 different data types: string, date
and integer.  I would like to combine them into a string.  What do I need to
do to convert the datea nd integer values into strings in order to save the 3
together as a string field.  I would like to do ...