count query and negative numbers question
- From: "David" <david@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Sep 2007 20:57:44 GMT
Hi All,
Pretty new to database queries so apologise if I sound dumb!
I have a database for stock control of energy efficient light bulbs for a
charity that gives the bulbs out free to folks in need.
The database has various fields including type of bulb, location, quantity
and whether the stock has been added to stock or removed.
I want to know how many of the different types of bulbs are in stock at any
time.
I have tried to run a query which makes the 'quantity' amount of bulbs
removed to be negative (puts a '-' in front of number). I then want to run a
second query to count the bulbs so the count subtracts any quantities that
are negative.
Can't get the queries to work and make the quantities negative and the
second query treats negative numbers as positives. What can I be doing
wrong.
Cheers, david
.
- Follow-Ups:
- Re: count query and negative numbers question
- From: John Spencer
- Re: count query and negative numbers question
- Prev by Date: RE: join on two firelds
- Next by Date: Re: Date() in XP/Access 2003
- Previous by thread: Re: count decimal place
- Next by thread: Re: count query and negative numbers question
- Index(es):
Relevant Pages
|
