Can I easily transfer dates from one bound column to another?

I have a query (qry_CourseEvalutaionByTeam) that shows ratings (1-10) that
training courses have been given by different teams. I have a form
frm_CourseList that has a combo box that lets me choose the course that i
want to see the rating for by team, this combo box is the ...

I have two tables:  Table1 & Table2
Table 1 contains a personal data for clients (name, address, phone number)
Table 2 contains the same exact fields as Table 1, but includes only updates
to the personal data for clients (I receive periodic files with new

I have a drop down selection box in my master table. However when I perform
a query on this table I want to show that field without the drop down
selector being visible. Is this possible???
Thank you

Here’s my problem:
I have a date/time field recording the date/time when pt arrives at our
hospital.
My final output needs to include 2 new fields:

I would like to hide any duplicate records in a query. I have already
used the "Unique Values"parameter, but I would like to hide any
records where the first field is duplicated.
Did that make any sense?? ...

I have a simple data base for icecream that contains several products (5)
and several flavours (7). These are in seperate colums in the QBE grid along
with other criteria that does not need sorting. There are many different
conbinations of products and flavours in stock.

I have a simple crosstab query that has a Parameter which asks for the
month that it will display. How do I create a parameter where I can
enter multiple months or all?

I have data from a large spreadsheet and inherently, sections of the data are
duplicated to fulfill requirements in the spreadsheet (like names, projects,
etc.) which I am not using in this query.
I have already created a query to narrow the data into only week number,

The background is I have a table on a sql2000 server that allows an
Active Directory group select, update, insert, and delete rights on
the index column. However, select rights are denied on all other
columns for security reasons. Users can only update, insert, or delete

I have several rows in my query (report) that will have data if the value =
True based off a check box. However if the value is False I would like it to
put a "dash -" in all the text boxes assiciated with that otion box value.
How do I do this or can you steer me in the right ...

I have bad student who was assigned In School Suspension.  Start and End
dates are added to the table.
Name  StartDate     EndDate
Jane  7/11/2007     7/15/2007

I have the following query based on 2 queries:
SELECT qryAdjustedAUSGrandTotals.[Course Name],
qryAdjustedAUSGrandTotals.[SumOfAUS Course Count] AS [AUS Course Cnt],
Sum(Nz([SumOfTotal Participants],0)) AS [Total Participants],

I have two tables, table I contain addresses complete with five (5) digit zip
codes.
Table II contain three fields of data,  zip code beginning range and
zip code ending range and a state code for the corresponding zip beginning

I have a very large database with many Weekly Date entries. The problem is
that I would like to change every date in my DB to the previous day. For
instance I have a entry for the Week of 07-08-2007 and would like to change
that to 07-07-2007. I need to to this for all dates. ...