I'd like to be able to return a text cell value from a table that includes
fields for "start date", "end date", and the text value that I'd like to
find.  My plan is to use an update query that would post this value into a
different table.  I'm new to access and would like to be ...

Ihave a query that has returned the results that I need to narrow down
further. I want to show the fastest time at each circuit, together with the
extra detail (Driver, Team etc). Now I can get the right result, showing 72
rows detailing Country, Circuit and Time, using example 1 ...

I am trying to write a query that will be the basis for a report. The
problem is, that there is always a blank line (for a new record) at the last
record of the query (that is, I *never* get an empty query). Sometimes, it
doesn't bother me, since if the query has any results ...

I need to round down the decimal to the flooring integer, i.e.: 4.3 to 4.0
and 4.8 to 4.0. How do i do that in Access?

I'm having difficulty building a query that compares two tables. I'm
using access 2000 on win2000.
I have a hardware db that contains a table with hardware, a table with
users and a table where hardware is linked to users (called tbl_assets)

I have a table named tblBatchHeader with a primary key called
idsBatchHeaderID. It is linked to the primary key lngzBatchHeaderID in eight
other tables named tblCLines, tblDLines... etc. using a
one-many-relationship. For each instance of idsBatchHeaderID, I want to count

I am working with a large database imported from excel.  The address field
may contain a street number followed by a street name followed by an
apartment number.  Some addresses have no street number, some have no
apartment number.  I need to compile a walking list from this data ...

Can someone help me with the following problem:
SQLValid = "Select * from [Item Master] where [part #] = " & _
 "'" & [Forms]![Actual Stocktake]![YPROD] & _
 "' And [valid or invalid]= 'v'"

I'm accessing an MSAccess DB from within VB.NET.  To start here is my OLD
select statement which works 100% and has provided the data I need for many
years:
SELECT TimeSheets.Employee, TimeSheets.[Hol Hours], TimeSheets.[Job Date],

I have created a form to pass parameters to a query.  The first parameter is
the date range: Between [Forms]![frmSelectDateType]![BeginningDate] And
[Forms]![frmSelectDateType]![EndDate].  The next parameter I have on the form
is a combo box with two values, Type 1 and Type 2.  ...

I am building a typical Many to Many application for our training classes.
One of the tables in the design is called tblClasses. We have over 100
classes in the table and about half of them were scheduled in July. When
we're registering students for new classes, obviously we ...

Can someone help me with the following problem:
SQLValid = "Select * from [Item Master] where [part #] = '" _
& [Forms]![Actual Stocktake]![YPROD]& "'"
Now what I am trying to do is select something from the item master where

This may sound familiar to some, but I have tried several approaches to this
problem.  The VB approach is beyond my VB skillset given the timeframe I have
to get this done, so here goes an attempt using and append query...
I have tblCandidates and tblRRDExport.

I have a database of names of people and when that person checks in for a
service their name is scanned in and the date and time is automatically
assigned and kept in the data base when the type of service is selected for
the visit...

I currently have 2 fields, First_Name and Last_Name.  How do I merge them in
a query into one field?
Thanks