I am importing a table from another db that has fields of "date updated"
"area" "section" "products" "quantity"
For each date all areas are repeated, there are multiple sections in an
area, there are 4 products (A,B,C,D) and quanities for each.

I'd like to timestamp the rows I return from our db (db2) on the AS/400.  I've
done this before, using a pass-thru query, using "Now()" with vba.  I'm trying
to do the same thing with Access (2000), where I'm not using vba.  I'm just
wanting to add another column.  "Now()", "Time()" ...

IM TRYING TO BUILD AN EXPRESSION TO RETRIEVE TOTALS. HERES MY DELEMA I HAVE A
FIELD IN MY TABLE CALLED "CHARGES" THAT  HAS NEGATIVE AND POSITIVE AMOUNTS, I
WANT TO RUN A QUERIE THAT WILL RETRIEVE THE TOTAL OF THE NEGATIVE AMOUNTS
ONLY. WHAT IS THE CORRECT STRING. THANK YOU

I hope this makes sense:
I need to have a query that allows the user to define a criteria from a
list, rather than an input box.  Currently, tbl_Building has entries
stored in it that I want to be able to select from a list for this

Hi All.  I am trying to design a query for a quarterly report.  
This is the syntax I have used.
("datereceived">=#01/01/2005# And "datereceived"<=#04/01/2005#)
I dont get any results at all!  The column name is Date Received and I have

I have a make table query in Access 2000 where one of the tables has an
autonumber field. After running the query I find that the corresponding
field in the new table is also autonumber, even though the Access
documentation states that field attributes are not copied in a make ...

I am generating a query that gives names, addesses, etc.  However, I would
like to remove duplicates based on SSN.  How can I do this?

Any suggestions on writing a query expression that will allow me to produce
values that are parts of other fields?  In other words, I have a field that
stores an identification number that is ten characters followed by a dash
then three more characters (xxxxxxxxxx-xxx).  I need a ...

In excel you can use a countif formula to count the number of say "yes" and
"no" in a row and display that count. How can i do this in access and if i
can do it, is there also a way to import it through a pre-existing excel
spreadsheet?

im looking for the programme that correct grammer mistakes and give us
choices for this mistake, will anyone reply to me as soon as possible?

I was wondering if someone could help me.  I have a linked table to my
database which has a date field, however this is stored as text (e.g.
060401).  I would like to format it to DD/MM/YY (e.g. 06/04/01) I have tried
using the following expression in my query:

My query returns several records based on criteria I specified. I want to
build a Macro that is based on a condition that examines the results of the
query and sees whether a certain value is included in the query results (for
a certain field), so that if that value is included ...

Hello All,
I am trying to create a lookup where the user is prompted to enter in a
person's last name [Enter the Last Name] and then i would also like to search
for similar values.  Such as: If a user searches "Smit" then "Smith" will

How can I create a parameter query in access where the parameter variable
specifies the column name?

I hope this is the correct newsgroup for this question, my appologies if it
isn't.
We are running a competition in which entrants come from various schools.
What I need to do is create a report which lists the top 10 entries from