Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I have a table. Some field values are saved to memory variables for the current record. I then run SQL to get all records from the same table that match the field values. These are not duplicate records, just matching according the values of those specific variables from the current record. This works well, but I then need to exclude the original record from the resulting cursor. So, I want the ones that match, but not the one that I used to create the criteria.
>
>UPDATE: I think I may be able to use RecNo() for this. Testing now, but if anyone knows of something better or an issue with using RecNo(), let me know.
RecNo() is what I would use, too.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only