I have a table that I want to query for a report but need to do some calculations in the query.
My table has:
Date (date)
Location (text)
Breakfast (numeric)
Details (text)
Essentially, if the field [Details] has something in it, that means this is a "special meal" and I need to count it separately for each date. I can't figure out how to do this in the query. Any help would be very appreciated!
Thanks
My table has:
Date (date)
Location (text)
Breakfast (numeric)
Details (text)
Essentially, if the field [Details] has something in it, that means this is a "special meal" and I need to count it separately for each date. I can't figure out how to do this in the query. Any help would be very appreciated!
Thanks