I am creating a database and I want when someone clicks on a check box for it
to enter the date in another field and I don't want that date to change
unless the check box is un-selected

I am trying to remoove characters from a text field such as "-".  The
characters are in multiple spots in the field example  30GTN080---5--KA  I
want to left justify the numbers and letters without any "-".  How can I use
the trim function to do this?

I have a form with 5 combo boxes, the results of which are passed to a query
to display a list of orders. One of the combo boxes is called OrderComplete
with a value or either Yes or No obviously determining whether the query
shows incomplete orders or not.

I have a table with a date field in it, and I want to be able to pull out
all the records from the previous month, irrespective of when I run the
Query. So any time I run the query in May, I'll get all April records etc. It
seems simple!

I have a calculated field in a query which produces a null value for some
records and a number for other records. Now I want to filter the query to
only show me the certain records based on what the calculation produces, so I
added the criteria under the calculated field in the ...

I have tables that looks like this:
ID      Column 1    Column  2      Column 3
1          A                  B                   C
And I would like the result to look like:

Is it possible to get difference between the timestamps on the same table to
get an indication of time between entries into the same table?
Thanks
Frank

I have one table that has sales results for 2 quarters.  The results for one
quarter are stored in one row and the results for the second quarter are in
another.  How can I combine the quarters to create a "variance query".  My
data looks like

I have a short range of numbers that gets recycled. I am trying to create a
query that returns a result based on the last instance of that number to see
if it is available:
Name     Number     Term

I have a table that has 7 fields all of which may contain a given value. I
need to add criteria that selects records where *any* of these fields equal a
given vale. It's complicated by the fact that this value could actually be
one be of a list of 5

Developed a program in Access 2000. Turned off confirm messages for queries
in tools options. Works fine when installed on Win 98 or Win 2000. Confirm
messages return when installed on Win XP. How can I prevent this, other than
redeveloping in Access 2003.

What I'm trying to do is very confusing. I don't even know if I can explain
what I'm trying to do even, but here goes nothing:
I have a database that's for an insurance company, and this database serves
as a tool to use to annualize insured's reported quarterly payroll. I have

Hi,  I have a memo field to update with a description that is approximately
3,00 characters in length. I created a select query to return the records
that need to be updated  and I manually pasted the dexcription directly into
the query results.  However, when I review what I ...

This sounds like a very simple thing to do, but I can not make it work.
Basically, I would like the database to return entries regardless o
wich field the search term is in.  Because many of my fields are memo
I can not use the find key.  Fundamentally, I would like it to searc

I have a table with customer invoice information on it. I have another table
with customer payment information on it. With a query I want to make an AR
balance sheet to show what is outstanding for a spacific client. When I try
to do a query with each table linked on the customer ...