Query Previous Line,

[dwichmann]

I have a query that brings in data from a website, it compiles enquirys about barrier fencing. The first row of the enquiry might say the customer wants a row of barrier fencing 5 metres long, the same line will also specify via a tickbox whether this line is joined to the next.

From this information i want to specify whether a start post is required, in most cases the answer would be one but if the previous line was joined then this would be null.

 

[KenReay]

Hi

You do not say how you are reading through the query result, but if using a recordset, there are command to move back and forth eg Rs.MoveNext, Rs.MovePrevious

would that help?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dwichmann]

Sorry this doesnt really help, i am reading the query as a data table in a report not searching through each individual. what i want to do is say if a field on the previous line is ticked then make a different field on the current line equal a particular value.

 

[dhookom]

If you use terms like "previous" and "next", you must be able to identify a sorting order. Most of this would be cleared up if you would take the time to post a few records and identify the order as well as the expected results.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]