Here is my query :
SELECT PartQOH.PARTID, PartQOH.SumOfQTY, PartsOnOpenSO.Allocated,
(PartQOH.SumOfQTY-PartsOnOpenSO.Allocated) AS Available
FROM PartQOH LEFT JOIN PartsOnOpenSO ON PartQOH.PARTID =

I have a database that I've built for a mission trip for numerous churches.  
i have all the travelers in one table.  What I need to do is update the table
quickly when we assign each traveler their hotel, bus number and leader's
name.  I'm thinking of doing a select query first ...

I have 2 fields: FROM and To as dates in form.
Another text field LDATE, is for string that filters by dates beg. FROM and
end. TO .
What should be this string (it's exact syntax) in order to be able to pass

I have a query -- massively large, several layers deep, but still
straightforward. It works fine by gathering 5 different types of spending
summed up by project and equipment. As I said, it works fine.
My client says "I forgot the sixth" type of spending. No big deal, it's in

Is there any way to disguise data in a report so that text in a field only
shows *'s or any other symbol. This is so I can see text is there without
seeing the actual text (like for passwords)
Cheers

I have a couple of reports that work fine in a form and they pretty much all
gather information the same way. But one query fails every time and gives me
the error "Invalid Argument." I'm kind of baffled on why this might be.
The SQL for the report is as follows:

How do I use the Expression clause in the Totals row in the QBE?

I am new to access and having an issue with writing a query.  I have an
existing table and an existing query that I am trying to build a new query
off of.  The 2 should have matching record counts, but don't.  I am trying to
find out what is on the table that is missing from the ...

my subform is populated by a cbo box on main form.  (i am aware naming isn't
w/conventions - but I am still new).
here is the query as it stands:
SELECT [Scheduled Classes].Class, [Scheduled Classes].[Class Start Date],

Hypothetically, let's say I have a table with 26 fields, A-Z.  I want to
create a query that will select fields "A", "B", and "C", and filter records
based on a fourth field.  However, I want this fourth field to be dynamic,
such that it can be any one of the fields D-Z, to be ...

I would like to create an update query that will change the values to
negative numbers. The values are in currency format. For Example I have
records with $5.00 but I would like to run an update query that will change
the $5.00 to a negative number (5.00).

I don't know if this is supported.
We have some very large CSV files that the Executive staff open and build
statistics from. When Access opens the CSV, it creates a lock of the file so
that only one user can access and manipulate it.

I'm trying to figure out how to make a running balance for customers.
I'm trying to get it to be something like this:
CustID    Date    InvoiceAmt    PaymentAmt    Balance
1            1/2/8     $12.00            $0.00            $12.00

How do I make a prompt to ask for two or more items in a query for a report
or form?
Such as first name and last name.
Thanks

I'm trying to format  calculated fields Charges/Units and Payments/Units to
display 2 decimal places.  The Charges/Units allows me to select the
DecimalPlaces in the Properties Box.  The Payments/Units field does not show
me the option to select DecimalPlaces.  It goes from ...