Hello SQL Geniuses!
I am trying to pull a query on a table that shows me the following fields at once.
Show Record ID Priority (Yes/No) Prayer Count(this is a value) Request Title (text) Request Memo (text)
Basically I want to design this query to ultimately pull all the records 1 record at a time in a certain order and then cycle back through the all the records in a certain order.
How can I accomplish this? Tell me what you need to know to answer my question and I will come back to answer.
