I have two queries, each based on a simple single table (a different
table for each query).  One allows me to add a record and the other
does not (either programmatically or via the Access UI).
Can anybody point me to how I can tell why?  Thanks!

Can anyone pls help with calculating the previous Sundays date in
visual basic, I need this as a default value in text box. Thanks.

I have a table with two fields. .... DATE and ROOM.
  I would like to total the number of hospital rooms completed on each
floor on a specified date.     I need to generate one query which gives the
total number of rooms completed on EACH floor on a specified date.  For

I have a query that accumulate the sum of material.  The query has Material,
Qty(sum), Assemble (Check Box) which is set to 'NO' and Material Type.
If the Material Type is '5' then the Qty(sum) needs to be divided by 2.  If
the Material Type is any other value it would be Qty(sum) ...

Using MSCAL.calendar.7 as calendar control in form.  Need to use date
selection output as criteria in query...  need to reformat date in critieria
to yyyy/mm/dd format to match date format in table field.  Need help with
writing criteria expression to accomplish.

I have two tables:- table(A) contains a date and a numerical value which can
change at varying intervals (weeks, month etc.) Table(B) contains "date"
(daily information) and several numeriacl values.
I need to build an expression that will look at the date in table (A) and

How is possible to type for example "à uinetas" and find a record stored in
the database as "á uiñetas"?
I'm looking to remove all the accents (or at least the most used ones) from
each side of the WHERE clause.

I have a table with field physical damage (number) and this can be
either 0,1 or 2.
I need to calculate the percentage of occurrance for when is 1 and 2.
How should I do that? Can someone help me?

Both queries perform the same function (at least it appears that way).  Which
query is better from a performance stand point.
#1
SELECT BatchLocationTable.BatchLocation

I am making a new table from a query O.K.
Upon running can I input the number of records I wish to be copied (say
first 500).
At the same time can I increment a URN say 1,3,5  or 2,4,6 etc

I'm creating a database for someone that contains a list of employees. Every
6 months they need to randomly select employees to partake in testing. I've
read www.mvps.org/access/queries/qry0011.htm but I'm not quite sure how to
implement and get this to work. Someone to step me ...

I need to take a field that has a full name "First M Last"  and split it
into three different fields.  All names use a space to seperate the first,
last, and middle initial. Access 2002.  Any help will be appreciated.

I would like to make a query that would assign a value to yes or no.  I am
working on a database for church.  I basically have to keep up with the
points for awana.  So I would like to either check yes or no to a field and
have access assign a point value.  Then I could add up ...

I am trying to build a report from a query, and here is what I want to do:
We have a table on our main database that lists production, by date, for our
agents.  Each day a policy gets paid, the agent's production is posted as a
separate record in the table.  We conduct seminars ...

I have about 20 fields of Yes/No data type. I would like to do a parameter
query where I type in the name of a field, and it will display all the "Yes"
of the field that I typed.
Example:-