record selection with more than 1 criteria

[tyedyejenn]

I am writing a program in VB6 and my reports are designed in Crystal Report 8.&nbsp;&nbsp;I am having difficulty selecting records when my selection criteria has more than 1 comparison. (Example--I want all the records that match a specific batch number and have an Amount of Adjustment &gt; 0.)&nbsp;&nbsp;Could someone please help me with an example of the syntax for selection formulas with more than 1 comparison?<br>Thanks alot<br>Jenn

 

[MalcolmW]

This sort of thing?<br>{BatchNum} = 666 AND<br>{AdjAmt} &gt; 0<br> <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[tyedyejenn]

Malcolm, That is exactly what I am looking for but can't get the syntax correct<br><br>Thanks--Jenn