I am trying to create a query that will select multiple rows from a table
based on data input by a user.
The main table has a thousand plus records in, from which I want to select
records to print address labels from. The user will know what records they

We have a table that has multiple records for a contact with a code
indicating the contact type.
Example:
NAME    CODE

I'm reposting this because I put in the wrong forum.
I'm looking to write a query to return the amount we should be billing our
customers for freight.
I have a table in which each record is a package. Each record contains our

Data is pulled by random month. In the resulting table there are 2 fields of
information I want to work with. (see below) The Month field is created by
formatting the DateSold date. What I need to do is the populate the Month
field where it is null with the same mmm yyyy as wheen ...

I have written the following SQL Statement:
TRANSFORM Sum(qryTSExportFY.Hours) AS SumOfHours
SELECT qryTSExportFY.ProjNum, qryTSExportFY.ProjSub1,
qryTSExportFY.ProjSub2, qryTSExportFY.LastName, Sum(qryTSExportFY.Hours) AS

I have a table of numbers (ex. 2100-3100).  I have a second table with a
field that accesses the first using a combo box.  Not all of the numbers are
used in the second table.  Is it possible to query the two tables and find
out which numbers in the first table have not been used ...

I found this query in the Northwind sample database.
SELECT Employees.EmployeeID, [LastName] & ", " & [FirstName] AS ReportsTo
FROM Employees
ORDER BY Employees.LastName, Employees.FirstName;

I am working with a table that contains child records. in a new query i would
like to construct a parent record that contains different columns for fields
in the child records depending on the entry of the field. my problem is that
i get more than 1 record since there are ...

I am reposting my current issue because I may have not been very clear.
I currently have a query where I need the criteria of specific fields to be
updated by a combo box linked to other tables.  I have the como boxes in the
form and the query has the following code:

I have a field called destruction date in a table which I enter a year, for
example 2002.  I also have a field called years which is a selection from a
table years.  In my query I am adding the destruction date (2002) plus the
years field (5) in a field called expression. My ...

I need to import data from a live table in one database to a table in another
database. The data I am importing is not indexed. I would like to be able to
import this data into my table that is indexed. My table is indenticle
structure except for the indexes.

I have a query which takes two fields from a table ([MinimumBid] and
[BidIncrement]) to come up with a calculated field in the query...Bid2:
([MinimumBid]*[BidIncrement]).  The [MinimumBid] and [BidIncrement] fields
are formatted with 0 decimal places and that's how they show in ...

I want to show all records of "Falls" that occur between the hours of 11 pm
and 7 am (the night shift) for the dates of 1/1/07 and 3/31/07.  I have
queried the dates fine but not the time.  For the critera I typed:  Between
11:00 pm and 7:00 am.  But I get records that are ...

Hello Access Professionals:
My goal is to be able to print a report every day similar to the pivot table.
Please let me know how I can accomplish this.
Right now, I can accomplish this only by pasting the aggregated data in excel

I  have a query that is picking up information from an imported Excel
spreadsheet.
Under my part code heading i have around 100 codes with no number showing
although they are present in the spreadsheet.