How to show n records based on criterion of text features & n + 1, n + 2, n + 3, n + 4 rows in SQL MS Access 2013
I need help with SQL MS Access 2013
. I need the query / report to include: search for combined text functions like? and "as" in the table with the message and comments, then if in comment n display this line n and the next 4 lines up, therefore n, n-1, n-2, n-3, n-4 (due to time sequence such as Facebook posts and comments) as well as another or combined query / report, if column n shows n, find the first comment down by post id and also display first comment n + 1, then n + 2, n + 3 and n + 4 from the timeline for posts and comments on the social network
eg.
P1
C4
C3
C2
C1
So if I am looking for combined text functions like? and "how" in C2 and it exists then show C2 and C3 and C4
So if I am looking for combined text functions like? and the "how" in P1 and it exists then showP1 and C1,C2,C3 and C4
source to share
No one has answered this question yet
Check out similar questions: