I have two reports I need to run, one for docking and one for departing.  
Each report uses the same dates.  Now how can I create one report that
requires the date only entered once but will display both query information?
Thanks Jen

Can someone please explain to me if the following are possible or not.
1) A query can be run to insert records into a table on a certain date
2) Insert records for all employees whose anniversity falls within that month.
3) Prevent from doing these things more than once within a ...

I am trying to create a query with 4 tables to report sales out quantities
and I am getting incorrect quantities whenever I add the 4th table to the
query.  Without the 4th table, the quantities come out correctly, but when I
try to add the 4th table, whether or not there is a join ...

I have a query with a date range hard coded for report proceedures. Well part
of the problem when having users manually selecting dates, it has to be done
multiple times. Is there a way that you only have to enter the date once?
Thanks,

I am trying to do an update query with the following..
In Field: Attachments: IIf([dbo_tblProductversion].[Attachments]=True,"Y","N")
Because I want to convert the -1 and 0 to Y or N in a text datatype
I want to update to: [Dev_dbo_tblProduct].[Attachments]

Can you direct me to how to pull up any records in a query once someone has
added a new record?
Example.
I had 100 records in my table yesterday. This morning I entered 5 more

I have a query with two tables: Table1, Table2
The fields in the query are :
Field    Region    Super    Date
Table    Table1    Table2    Table2

Does anyone have a list of all the useful bits and pieces that used to be in
all access version up to 2000, and have been taken out in later versions.
So far I have found that we can no longer add Common dialogs to forms.
That 65 + null now equals null , where it used to be 65.

Access 2003.  I am using the following SQL code in my query:
SELECT DISTINCT GDate, DTotalLessons([GDate]) AS Lessons
FROM Grades;
I only want the DISTINCT to work on the GDate field and NOT on the "Lessons"

I have several tables and a source table. If any fields are changed in any of
the 4 tables. I want it to update the source table with the new infomation.
Would this be an Update query or and Append query? I would think it would be
an update query? Please let me know the best way ...

i was able to successfullly specify the recordsource for a report at runtime.
However, when I try to specify the same report's recordsource within a
subreport, I have no luck.  Here is my code:
DoCmd.OpenReport "tbl_archive_subreport_daily_with_graph", acViewDesign,

I have a query that projects the next months date "NextMonthDate:
DateAdd("m",1,[Date]).  I need to change the date of the projection for the
month of April on here is what I am proposing
IF [Date] <4/16/06 [Then] NextMonthDate: DateAdd("m",1,[Date]

Hi,
What shall I type in Access query field if I whant to show numerical values
(=hours) by characters S, M and L?
I mean if the source field values are <=7.5 hours how could character S is

i'm currently moving from an mdb to an sql database (using MSDE Sql Server 7)
i have used dts to import data tables.
what is the best approch to replicate access action and union queries in the
server enviroment?

I have a database, bunch of different queries, hitting tables linked to
MYSQL.
Everytime I hit the first such query after opening the DB, I get a
dialog box: