I am trying to figure out the best way to set up tables that have
value ranges. This is to be used for entering Plant Information.
Heights,etc are typically expressed in ranges, i.e. 10-12', 12-14',
14-16' etc. Sometimes it might be necessary to create an entry where

Hi, please help me!
i am making a database for my own restaurant. To make it easier for my
staff, i am creating a database which allows the users to input the food
orders.

I was setting up a query that had been troublesome so I was pulling each
element of the query separately to locate which of 5 related tables was
causing the problem.
I forgot to enter a criteria in the first element of the query so it should

This query creates two columns with aliases and a literal as the value.  It
works fine in Access but falls over when using a table linked to SQL Server
because the generated SQL uses the literal as the column name not the alias
(see below).  I have tried using column number (ie ...

I have a database that is used to track total cost for projects.  So, my
highest (hierarchial) table is the list of projects, the next table contains
the budget lines, and the last table contains updated costs for each budget
line.  I would like to view the data in a cross-tab ...

I would like to run queries with just one botton and a date dispalyed in a
form.
If Sunday March 09, 2008, is dispalyed I would like to click on a button and
run a query that will select emloyees that are scheduled to work on this day

I will like to change the value of a check box at runtime. I have a
database with a field "multiple_print_select", which stores a value of
"1" when it is checked so that the record can be printed.
This allows only the records selected to be printed, but wen another

I have a query that I am trying to find out who did not submit a report
during a particular time period. The unmatched works for all if I do not have
the date filed in the query.  Following is the SQL Statement with the date
field.

i need to have a running total in a query.
example
date             item     qty needed    onhand   available
03/18/08       1              500              2000       1500

The table looks like this:
EMPLOYEE        $$$_SALES            DATE
JOE            100                1-1-06
MARY            500                1-1-06

I have a form with a list of items for a shopping list.  I have check boxes
next to them that add them to the shopping list when selected.  Is there a
way to add a master check box at the top of the form to de-select all of the
boxes when it is selected?  It is very annoying to ...

Here's my setup.  I have 3 tables--Child, Adult and Track.  Adult has a
1-to-many relationship with Child.  Child has a 1-to-many with Track.  I am
filtering my query on a field in Track called Type with the Criteria=Like
"Initial".  When run, there appear multiple Adult IDs due ...

I have an Access 2003 database running multiple queries that was written on
XP, where it works perfect.  I recently installed Office 2003 under Vista.  
One of the queries no longer works.  I get the error Error 3420  Object
invalid or no longer set.  If I view the object ...

MS ACCESS 2003 on XP Pro
I have a query that looks at a table and finds the records corresponding to
a value stored in a text box on a form.
Here is the SQL

I have a table (tblTransactions) set up in a one-to-many relationship with
another table (tblHistory).  
tblHistory has the following fields:
LinkField (text field that is the link to tblTransactions)