Forum Discussion
MarkShnier__You
3 years agoQrew Legend
Do you have any relationships? What are your tables and how're they related?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JeromeMitchell3 years agoQrew MemberAll of these are in a single surveydata table tied together by facility name. So we can have many survey types by survey date per facility.
------------------------------
Jerome Mitchell
------------------------------- MarkShnier__You3 years agoQrew LegendI would like to try to help but I don't understand your question. Can you illustrate it with an example?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JeromeMitchell3 years agoQrew MemberBelow is a sample report that shows specific survey records for a site. These different surveys have a original survey date and survey type. What i want to pull are only the complaint survey type records where the 1st revisit date is equal to original survey date for the next Standard survey type record.
Now I know the records below don't show one, but for example, the 1-10-20 complaint survey has a revisit date of 3/5/20. If the next standard had a original survey date of 3/5/20 (instead of 1-10-20 now) I would want to return the 1-10-20 complaint record because it met the criteria I was looking for: "any complaint surveys that had their Annual as their 1st revisit".
I hope this explains what I am trying to do. The trick is I'm trying to compare 2 different records, and I know that is not easy in QB.
Thanks for your help in advance.
------------------------------
Jerome Mitchell
------------------------------