still it is a challenge for me particularly and for you as well. coz our
database can be successfully run on those methodes.

"Naveed Pathan" wrote:

i reallly appreciate your help thanks for all of you but still let make it
more clear i am not satisfied what i want ....... let make it more clear i
will have two tables; one for purchases and the second for sales to give you
the idea about the stock .

for example [purchases table]
SNO Item Serial Starts Serial Ends
1 Talk home 87564561 87565060





which are 500 cards in the stock. if i sell the cards randomly such as 50
and 10 so what would be the stock serial in hand then.

SNO Item Serial Starts Serial Ends
1 Talk home 87564581 87564590
2 Talk home 87564640 87564690

however there are two transaction now in the sale table where in the first
transaction i sold 10 cards while in the second transaction i sold 50 cards
so the question is that how i would know in the system that which cards
serial number are in my hand when slowly i sale more cards.
hopefully it is more clear now

thankx in advance



"Steve" wrote:

Naveed,

Please reword your question and I will take another stab at it.

Steve



"Naveed Pathan" wrote in message
...
thanks for the reply i already know what you told me but i am confused
about
the question i have asked it could you please the serial number in my
example
then you will know understand yourself that what i mean and that can't be
done through match or unmatch queries. that's why i am saying a
challenge for everybody to sort it out

thankx

"Steve" wrote:

Using your example, create a table with the numbers 1 to 100. Create an
unmatched query using the unmatched query wizard that includes that table
and your sales table that contains the serials you sold. The unmatched
query
will return the serials in the 1 to 100 table that are not in your sales
table. To create an unmatched query, open to the list of queries and
click
New. One of the options will be to open the unmatched query wizard.

Steve



"Naveed Pathan" wrote in message
...
dear friends i have a problem that i can't sort it out though i have
tried
alot anyhow i am here to get help from you people the problem i have
is

suppose if i have a serial of numbers and if i sell a particular serial
out
of that so i want to know that which serial is in my hand for example

if i have serial from 1 to hundred and i sell number 88 so i want to
know
that number 88 is no more availabe in the whole serial as it is sold
out .

Note : i will be thankful if you people sort it out or give an
ultinative
suggestion or solution for it thankx


.



.