This is what I have done. I know it is not correct. I have added this to the
'Link Master Fields' property in a subform :
Between [Forms]![SUB_ORDERS]![StartDate] And [Forms]![SUB_ORDERS]![EndDate]
However, I cannot get the form to output on this criteria. Instead when I run

We are scheduling appointments for trucking companies to arrive with freight.
I have a table that we enter the scheduled date in one field and the
scheduled time in another.  If the carrier is bringing more than one vendor
on each truck, we use the same appointment time.  ...

I did this once but fogot how.  I have an order table with an order entry
time.  I have several months worth of data.  I built another table that has
time intervals.  Example
Interval        Stime              ETime

I forgot how to do this.  I have a table of orders with the order entry time
and I want to count how many where entered each hour.  I remember something
about building a seperate table of time frames but I do not recall the rest.  
CAn anyone shed some light on this for me?

  I want to use date variables in the criteria of a query.
When I put Between #1-1-07# and #1-30-07# it works
but if I try to use a date variable it doesn't work. In
the query by example view. The field in the database

I need a comparison within an iif statement to identify a time value of
00:00:00 and don't know what to enclose the time in, have tried
'00:00:00'
"00:00:00"

I am trying figure out how to get access to do the following:
Column 1 = Name
Column 2 = Project1
Column 3 = Project2

I'm trying to created report called Intransit list, report would look at the
each entry in table tblFileLoc and find out last entry for each case (cases
are entered multiple times as location of case file changes) and then check
if the case was sent or received and if last entry ...

Hi I know this is simple but cant seem to get my head around it.
I have two columns "Address Postcode 1" e.g. N3 and "Address Postcode 2"
e.g. 4LL. I want to combine them into one postcode with a space in between
e.g. N3 4LL.

I need to create a query based on two tables.
The one table includes a 'Visited Date' field.  It is based on these dates
(of which there will be an increasing number as I want to link the table to
an excel spreadsheet, for others to update) that I need to extract premiums

I have an unmatched query (Using the wizard) that is returning only a portion
of the results I need because there are two primary keys in the related
tables.  I need to add a something to the SQL statement to account for the
Join on the second primary key but can't quite get it - ...

I'm trying to build a query that counts the number of students who
registered for our classes between two dates, and I also need to count the
number of students who actually attended the class. I can get the first one
[registered] easily, however, whenever I add another field to ...

I am running a query from a table that limits the output of data to a
specific time frame.  I am working on the last month minus 12 months.  So
what I want to see is from April of this year to May of last year.  This is
progressive as the months change. i have been using:

I have two tables:
actual_job_data:
job_id - long - fk to job table
job_data_dt - date/time - time that event occured

Guys,
I need to convert the following excel formula into Access
=PROPER(LEFT(MID(A19,FIND("CN=",A19)+3,255),FIND("/OU=GB",MID(A19,FIND("CN=",
A19)+3,255))-1))