query question

[Rich]

I have the following query that returns instances where a mfg job has
had a $0 subcontract event posted to it's Bills screen (usually a
subcontractor rework, but sometimes a mistake) :

SELECT tblBuyout.[BU_Job Num], tblBuyout.Type, tblBuyout.Cost
tblBuyout.[Line Num], tblBuyout.Desc
FROM tblBuyout
WHERE tblBuyout.Type="S" AND tblBuyout.Cost=0
Or tblBuyout.Cost Is Null;

I could validate most of these returns as legitimate, if I could also
see the same data for the [Line Num] immediately after the $0 event
line , but am unsure how to query this. Thanks in advance for any
help you can give me

 

[karl dewey]

I would need to see what your data looks like to make any suggestions.
Post sample data.

 

[MGFoster]

I have the following query that returns instances where a mfg job has
had a $0 subcontract event posted to it's Bills screen (usually a
subcontractor rework, but sometimes a mistake) :

SELECT tblBuyout.[BU_Job Num], tblBuyout.Type, tblBuyout.Cost
tblBuyout.[Line Num], tblBuyout.Desc
FROM tblBuyout
WHERE tblBuyout.Type="S" AND tblBuyout.Cost=0
Or tblBuyout.Cost Is Null;

I could validate most of these returns as legitimate, if I could also
see the same data for the [Line Num] immediately after the $0 event
line , but am unsure how to query this. Thanks in advance for any
help you can give me

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Read this article:

http://support.microsoft.com/support/kb/articles/q101/0/81.asp

It tells how to read the previous or next row (record).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSamvsYechKqOuFEgEQLdnACgsSVdjkoS8/vjmJu7qMAXYAqPEEIAoLt6
SwTpR12e2wavjVIaZBgvNYjo
=szvx
-----END PGP SIGNATURE-----