I have a form for inputting part numbers.  The form has 25 fields for listing
up to 25 parts.  It also has a quantity field associated with each part
number.  If on one record I enterend part number 1234 and a quatity of 2
along with part number 1235 and a quantity of 7, and on ...

I have a query that I have 2 columns each with a number in it ( in some of
the entries there is only 1 number in the first column) and a third column
with the total of the 2 columns (if there is a number in the 2nd column), and
in one of my enteries, the sum is correct but in the ...

I am trying to join 6 tables together; but do not want all of the
information.  However, the common fields between them do not produce the
information I need.  is there an SQL code that I am missing?

I've created a query from a date field that selects records between two dates.
It works just fine.  I now need to get a record count of this information.
When I use the count function it tells me I can't use an aggregate function
with this type of data.

I have an insert statement I want to run when a button on a form is clicked.
If 4/5 of the fields are completed on the form the statement will run fine
but if all 5 are completed, I get the above error message. I have checked and
checked the statement and cannot find why this is ...

I'm trying to port the following to access (run through OLEDB) and I
keep getting an error stating "Syntax error (missing operator) in query
expression"
update sometable set aux = x.id

I am trying to do a search for all numbers that are higher than 160. This is
the easy part. The hard part is that the field I am trying to do the search
in, is a memo field. I need to find the word “Sodium” and see what is the
value of Sodium to eliminate the records where the ...

I would like to combine a customer phone list (FirstName, LastName, Phone)
from the Customers Table with a Supplier phone list (FirstName, LastName,
Phone) so that one continous list is create.
I can't seem to create the query although I'm quite good at queries.

Access 2000  I have an employee db where I enter employee timesheet info.  I
have a tbl of "IDRa" where employee time info is entered and another tbl of
"CommCode" which stores codes for our office use.  Two codes I use in
"CommCode" are 50  which is for [First Day] worked and 60 ...

Hi to all...
I have a report connected to a form the prompt user to input two dates to
search all the dates ( in the DATE field) ... between them(using a query the
uses BETWEEN...AND.. statement)... I want to add another query to filter the

Is there a way to find quotes in a field and replace them with single quote?
Please advise.

I have a query in which there is a date field.  I need to write a SQL
statement that says if there is a date, then populate the field with a "Y"
for Yes, otherwise "N" for no.  Not sure how to do this.  Can anyone help?  
Thanks in advance.

here goes:
building a patient reminder system with MS access 2000 on backend.  need
correct syntax for following problems.
Basically, 1 patient can have many

I would like t o pass two dates as a date range from my VBA code using DAO
3.6 to an existing parameter query that is expecting two dates parameter in
Access.  I have in my vba code routines to obtain the two dates and here's
where I am stuck: I am not sure how to call the query ...

I am trying to create a query that will pull up the exp dates with this code
<=DateAdd("d",+30,Date()) this shows that their license will expire within 30
days of the current date.  My problem is I have 5 categories and I am using
the or function and skipping each line but it ...