yup...done all that and it still has the same prob...wasted 48 hours on this so have sledghammered it with a fresh win2k install on c partition...after copying c to e as bkp...most data and progs on e....pain in the a...but fed up of messing around...
thanks anyway..perfect advice...should have...
i recently downloaded and installed an upgrade to my alcatel usb adsl modem software...previously v 1.615 was working just fine...the install of v2.01 initially went well with the softwaqre side of the install completing ok...the next stage was to plug in the modem...this starts the plug and...
using isnull()on plhist.part
gives me no records at all
the other rub is I have to
link from plhist to stock
and not the other way because
i get invalid file link
not consecutive index fields
tried to count plhist.part but
this gives a total record count
not a count where stock.part is
equal...
will try your suggestions
key problem is that I want to select
records from file one stock.part
based on items that do not have an
entry under in file two plhist.part
i am trying to report on new purchases
and avoid reporting on repeat items
hope this clarifies
thanks for your input
x-)
i am stuggling with scr 7as follows
have to files (native data) stock
and plhist
i want to select the certain records
from stock ie part.stock
that do not have an entry
in plhist....tried count part.plhist
(hoping to select where count is
zero) but seems to return full record
count of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.