I have two  SQL statements, one is giving me the total Quantity
available(from Stock table) and the other one is giving me the total number
of Quantity sold out.(from Sales Table). All these are GROUPED BY Item Name
e.g Handbags 3

Lynn Trapp asked me to post the actual SQL code so that it can be checked for
error. The error is "Syntax error in FROM clause."
SELECT Stock.Item, Sum(Stock.Quantity),
Sum(Sales.[Item Bought])

I decided to repost this question because the response  i got didnt work, it
was giving me this error" Syntax error in the FROM clause".
Lynn Trap, thanks(atleast I have i have an idea), please give me another
syntax or check the syntax you gave me.

I Have the following SQL ststements the first one is giving me the total
stock available and the next one is giving me the total stock sold out.
How can  i subtract the results of the second SQL statement from the first
one, so that I know the Stock remaining.What SQL statement ...

When I first started working in Access, I would set
relationships for all the tables.
THen when I got "clever" and began writing lots of
queries, I noticed that I would usually need to tweak the

I have a table that is used to relate managers to their organization.
An organization has changed names and I am trying to update the table.  The
new name is "NWO".  When I change the field, it is "correcting" itself to
read "NOW".  I haven't seen this before, and I can't find any ...

i am making a database, and i need to know how to put a field size of FOUR
characters on a NUMBER field and an AUTONUMBER field.
therefore i want all the records to have to have a field size of 4, (no
shorter than 4, no longer than 4)

Microsoft has an "Access 97 Relationship Print Wizard" here.
http://www.microsoft.com/downloads/details.aspx?FamilyID=ed4c2dfc-0ce6-489c-b004
-1a980bffbc2d&displaylang=en
Do I dare use this with Access 2002?  If not, is there a "Print Wizard" that
will work?

I created a form from VB code and when it is finished I want to rename it
(to change the default name Access gave it).
I only could do it by selecting the new object in the database window
       DoCmd.SelectObject acForm, <Access generated name>, True

i want to hide the ms access window in my desktop while the user are only
working in data entering only. what should i do?

I want to specify elapsed time format that one can find in MS Excel.
Specifically, I want to use [mm]:ss. The Access format did not allow me. Is
there an alternative?

I recently installed the latest MS Office 2000 sp3 on a clients network.  
These 10 workstations were running fine with the original install of
Office2000 until the upgrade was performed.   Since sp3, some users are
complaining of slow response and performance problems.  One user ...

I am trying to maintain different state for filenames, so i have a table
with the list of filenames, then in the main table i would link the filename
field to it.  However this looks like it is duplicating the actual filename
for each record (i have 100,000's of them so this is ...

I have an assignment for updating (maintenance, version control
documents)database analysis documents (dfd's, lds etc). One table is stock
which is used most within the database. Presently  stock is kept for for
records for 6 months and has been requested to be held for 5 years ...

I have a residential database for a Homeowner’s Association and I’m rather
new at this Access thing.  I have created a table with lists of unit numbers,
owner info, and tenant info if the owner doesn’t reside in their unit.  I
need to make a query that lists garage numbers with ...