What I have is a query on Charges. Now I want to change a sign from + to -
based on the ChgID # in that field.
--
Joe Cilinceon

I have a query with 35 fields. on the form I'd like to create 35 checkboxes.
user may check or uncheck them depending on he fields thay want to see. is it
possible? how to pass checkboxes true/fals to query? or how to hide
unnecessary columnes on the form (datasheet)? textboxes ...

I have this code I got to lookupfrom the MSDS field the highest number
already used for a left 2 letter prefix, then its suppose to add 1 to the
prefix only it doesn't work.  The MSDS field prefix is based on the users
selection from another field. Can someone explain why??

I have problems using dates as parameters in select queries.  I changed the
date format from mmddyyyy to ddmmyyyy.  Initially my parameter query where I
select data for a particular month (format mmddyyyy) was:
SELECT Qtech_hours_2.Wo_no, Qtech_hours_2.Notes, Qtech_hours_2.Cname,

I have an Access application in which upon button click, a query is
run.  I can run the query based on the value of a text box, but I am
having problems accessing the rest of the values returned.  Can anyone
tell me how to do this?  I was trying it thusly

When I run a sort by alphabetically including three feilds it sorts the fist
couple of hundred or so correctly then all of a sudden in the middle of the
sort it is grouping several sections alphabetically whithin the same primary
group.  I do not know why it is doing this, it ...

I am trying to fix up a poorly designed Access database.
One of the tables has a Next of Kin field in which the typical entry looks
like this:
Mary Smith

Hey guys
Im trying to create a delete query using square brackets. The idea is
that it will delete records older than the number of years that the user
 inputs when the query is run.

this is probably obvious but i cant see the wood for the trees.
anyway, i have a query with three tables. table1 has unqiue primary key
(id) that is joined to table2 (the many side).
table1s unique primary key is also joined to table3 (again the many

I have a table with a number of fields on it, however I want to use one field
named 'MSDS' as my primary key. No problem there however the 'MSDS' field
contents is an alphanumeric number I have generated with code, which looks
something like this 'DC001'.. What I want to do is make ...

I tried linking date data types in a simple query and it does not seem to
work. The date data types are the same format (short - mm/dd/yyyy).  It seems
like the data type may include the hh:mm:ss that you can't see and unless you
have the exact value, down to the second, the ...

I have 2 related tables;
[Tbl_BaseItems]
   BaseItemID PK
   ItemID        FK

My query has stop acepting new data.  The icon that allows me to enter new
data is grayed out, so I can not enter new data to the query.

I need to compare two tables for similarites.  I have my supplier list that I
need to compare to the Government excluded parties list.  If one of my
suppliers is on the Gov't list, I can't do business with them.  I'm running
into a few problems....

Please help with a query that will provide a list of delinquent entries.  I
am using Access 2000.
I have an “INDICATOR” table with a field named “Indicator#” and a “DETAIL
RECORDS” table that also has a field with the “Indicator#” and a field named