I was able to create a report that opens a form for parameters and get the
desired results.
So what I'm having trouble doing is using the same form to open a form to
edit the data.

I tried using an update query, but I didn't get the results I wanted.
Actually, I don't know if an update query is the right way to approach this.
These are my tables:
tblDepartment

I've got a table like this
ProductID Ordere
132 TRU
45 TRU

There's something about a query that I wonder how it could be done.
How would you count how many people there is within a column (from a
Query) and that this information it would appear in another column
(same query) all in each cel of the column? Well, I need to get this

I am sending out quarterly statements for my customers and after the
statements go out I need to update the Send Statement date for the next
quarter.  I need the Day to always be the Issue Date day and the month to add
3 everytime a statement is sent out.  I also need to make ...

I would like to find the minimum date by comparing the StartDate field in 9
separate department tables. The 9 department tables are linked to a main
table WBS by WBS#.  I would like the WBSStartDate to be the minimum
StartDate.  I am unsure if I can use DLookup or just a nested ...

I've built an append query to add linked data to a table in Access. The link
data has a numeric field and had been predetermined by Access 2003 to be
integer.  I'm encountering numeric overflow when I try to append the data.  
It's very likely that I have numbers over the integer ...

I would like to find someone who has 2 qualifications eg Care2 AND care3. The
table is progresstbl and has fields including the following
candidateID, award (eg care1, care2,care3), status (eg completed, working
towards, withdrawn)

Is there a tool to visualize the cross-links between queries in an
Access database?
At work we use some databases with lots of queries and subqueries. E.g.
a report is based on a query A that gets its input from table B and

This is a follow up post which I need clarifying.
I am looking at a training database and I need to filter a query to find
qualified people. Whether a person is qualified or not depends on their job
title.

I'm trying to use the split function to seperate my date field into  day,
month, and year fields.  Every time I try to run the Split([Date], "/"])(0)
to get the day  I get an error reading "The expression you entered contains
invalid syntax."  what am I doing wrong.

I'm using a Make table qry to "localize" data that I'm extracting from on
ODBC connection.  The field in the linked database is a text field, but it is
now storing dates.  Without changing the systems defaults is there a way to
have that stored as a date field in my database.  I ...

This is a little strange.  I have the following query:
SELECT Worker.WorkerName, TaskAll.*
FROM Worker RIGHT JOIN TaskAll ON Worker.WorkerID = TaskAll.WorkerID
WHERE (((TaskAll.DateOrdered)<=#9/3/2005#) AND

I'm trying to figure out how to make a second combo box only show information
based on what is chosen in the first combo box on a form.  For example, if in
the first combo box is a listing of all 50 states, and someone chooses Texas,
then in the second combo box, only Texas ...