I have a sql view joined (join option 2) to access table.  Key is
project/subproject (found on both tables).  Not all view entries have
matching notes record.  How can Users can edit where there is a note, but if
there is not a note, it won't allow them to add.  Previous to using ...

An existing table to which I must append records has a field named "S&H"
really.  I am not allowed to change field names in this table.  
I've tried enclosing the name in [square brackets] and "quotes" with no
success.

I use an existing database that allows multiple selections of names from a
list box.  The field in the record is a text field and is built using the
selection of names.
The field will have information such as:

Sorry folks, I should know the answer to this.  I have a table that stores
the days employees take off.  The table has the following fields:
"Employee Time-Off Table"
Type of Leave (Vacation, sick,jury duty)

I'm trying to write an append query for an existing table and don't have
rights to change the table design.  The field name is "S&H"  (Really!) (My
quotes).
Have tried enclosing the field name in [square brackets] and "quotes", but

I have a list of itmes and sales quantities.  Each item will appear multiple
times becuase the quantity will be different.  I want to be able to delete
the max quantity associated with each item, how do I do that?
If I run a query and select Max quantity, it does not allow me to ...

Back to my database of records imported from Outlook.  
This time I want to update the Department field with some descriptions such
as Real Estate.  I enter the Department field into the grid.  In the Criteria
row under Department, I enter Is Null, in the Update To row, I want to ...

I have a query called UserSearch.  It queries on a table called users to try
to find users with various criteria.  The fields being used for criteria are
UserName
LastName

Hello!  I tried searching for an answer to this question but didn't come up
with anything, so forgive me if this is a repeat.  A while ago I asked a
question about combo boxes limiting a query with one of the options being not
to pick something out of the box, the answer being a ...

Access 2003 on Windows XP machine:
I've imported some data from a text file. The EEName field is 30 characters
long, and the data that was brought in is padded with spaces.
To trim the extra spaces off, I added a new field, and ran an Update Query,

What I need to do is create a query that first finds all records that meet
certain criteria from two different fields then count those records.
We have multiple facilities and programs, so I need to know how many people
are in a certain facility [field1] and a certain program ...

Use the following syntax in a query: Between #StartDate# And #EndDDate#  
User input the StartDate and EndDate on a form.
Problem:  For example if the user enters the StartDate as 12/01/06 then
sometimes the query does retrieve the all records dated 12/01/06.   I do not

Hello,  
I'm looking for a function in Access 2003 VBA that would act like RAT()
fuction in .net.  However, it must be called within a query statment.
Thanks A Lot.

I am in the process of designing an Access application that helps
predict the promotion prospects and likely date(s) of successful
promotions of Army personnel.  The application is supposed to carry out
predictive processing by extracting people meeting promotion criteria

Dear friends:
I have an MDB application with a SQL Express back end.  I have written some
extensive query work there that cannot be written for Jet (indeed, if I try
to extend this query work, SQL Server fails, "Internal Error").