I have a combo box that displays the numbers 0-3. All of these numbers are
linked to only one query within the rowsouce that displays a specific table.
I am trying to get get a different query to be used so when the #3 is
selected it displays a different table. Can anyone help ...

I would like to build a crosstab query that displays weeks as column
headings and tasks as row headings and value as something like
(iif(startDate and endDate fall within week,1,0).  This would then
produce a pseudo gantt chart.  I could then use a report to use

I have successfully used update queries to change a values to a specific new
value.
But I realized for the 1st time when I tried using it to update fields to
values in another table I linked it to that I couldn't get it to update.

I'm hoping to come up with a form that will allow a user to use a
checkbox to select which guests (from a query-produced list)  to
execute an action query on.  For instance:
I want a query to give me a list of our current guests.  Each day,

Is there a limit to the number of levels of nested sub-queries that a query
can have?  I've built queries with at least 10 levels and they've worked
fine, and am wondering where the limit is if there is one.
Thanks,

Hello!  This is my first post on to Access Monster.  I have a specific
question with general implications.  I've simplified it, since the real code
is pretty gargantuan.
The database... The Access database I set up has a table called Agents,

I seem to be missing something here.
Error Message:
"The SELECT statement includes a reserved word or an argument name that is
misspelled or missing, or the punctuation is incorrect."

I am new to Access, so please forgive my "beginner" question.
I have a 1-column (Client Name) table with ~292,000 records.  The records
are already sorted in alphabetical order, and there are no duplicate records.
I want to add a second column (ID) to the table, but I need to ...

I have a list of students, parents and the school the child attends in a
table.  I need to determine the number of students each parent has in a
school.  I would like to get this from a query.
In excel, i sort by parent, then school.  

I have a query that has 2 tables linked (one to many). Access won’t let me
create a delete query from this – it give me a message that I need to choose
the table to delete from. Can you help me?
I am an intermediate user - I do not know SQL.

I have a table with the following columns: [Date], [1], [2],[3],[4], etc. The
data in the columns [1],[2], [3], [4] and so forth... are either  the value
of "4", or "N/A". I want to calculate the average of of the columns 1,2,3,4
in the table when [Date]=#" BUT if all the data in ...

I have a table called frmReps which has information such as Last Name
and First name.
I then have a command button on my main form that links to a secondary
form called frmPersonal which houses personal info such as ssn spouse

In my query, I've frozen a few columns to the left side. After I've done
whatever I needed to do, I unfroze the column, but the column order did not
reset. I've resorted within the design view and the new sort order doesn't
appear on the datasheet view but it is retained in the ...

I need a query to sum to debits and credits based on a unique PO
Number. ( I also need to make other exclusions as you can see.)
Here is the query I have so far:
SELECT tblCommInfo.Commodity, tblCommInfo.[Commodity Type],

I posted a few days ago regarding this issue, and I am STILL having issues.
Please use as plain of language as possible as I am a complete noob.
I am running Office 2003 on a Vista machine and attempting to update a
database. There are no issues with the database as co-workers are ...