Hide Record from Report (1 Viewer)
- Thread starter ra2020sh
- Start date
Gasman
Enthusiastic Amateur
- Local time
- Today, 14:47
- Joined
- Sep 21, 2011
- Messages
- 14,238
So please explian what method was used.
It might help someone else when they have the incorrect structure also.
June7
AWF VIP
- Local time
- Today, 05:47
- Joined
- Mar 9, 2014
- Messages
- 5,466
Good point.
UNION query can rearrange memo fields to normalized structure. Use that as source for subform and apply filter to remove "Not Normal" records.
SELECT ID, Memo1 AS Memo, "M1" AS Src FROM Tasks WHERE Memo1 = "Normal"
UNION SELECT ID, Memo2, "M2" FROM Tasks WHERE Memo2 = "Normal"
UNION SELECT ID, Memo3, "M3" FROM Tasks WHERE Memo3 = "Normal"
UNION SELECT ID, Memo4, "M4" FROM Tasks WHERE Memo4 = "Normal"
UNION SELECT ID, Memo5, "M5" FROM Tasks WHERE Memo5 = "Normal";
Why are Memo fields set as memo type with such short data strings?
UNION query can rearrange memo fields to normalized structure. Use that as source for subform and apply filter to remove "Not Normal" records.
SELECT ID, Memo1 AS Memo, "M1" AS Src FROM Tasks WHERE Memo1 = "Normal"
UNION SELECT ID, Memo2, "M2" FROM Tasks WHERE Memo2 = "Normal"
UNION SELECT ID, Memo3, "M3" FROM Tasks WHERE Memo3 = "Normal"
UNION SELECT ID, Memo4, "M4" FROM Tasks WHERE Memo4 = "Normal"
UNION SELECT ID, Memo5, "M5" FROM Tasks WHERE Memo5 = "Normal";
Why are Memo fields set as memo type with such short data strings?
