I wanted to be able to create custom reports for the charity I help out and have created custom fields for the customer table and populated the table with sample data. When I run the query SELECT * FROM Customers WHERE Tuesday = “Yes", I get the error:
No property or field ‘Tuesday’ exists in type ‘<>f__AnonymousType219’ (at index 0)`
when using SQL statement to retrieve data from custom fields in Customer table. Should I be referencing the custom field in another way?