Unanswered: Can I filter on the same field in a query?
I’m wondering if it is possible to filter on the same field in a query. I have a field called “WO_Type” and there are two items that I would like to filter by in a report. I would like one column (in my report) to list “New Location” and another column to list “Existing Project” I would like both of these items listed in separate columns using the same field “WO_Type” I thought I could add the field in the query twice and rename them then perform my filter. Ex:
Well you can, but what would be the point? The two fields would contain the exact same information, so filtering one would be enough.... and if you specified two different criteria, you'd get no data back.
My guess is that I don't get what you are trying to do.
If all you want to do is to get back all records where WO_Type is either "New Location" or "Existing Project" then all you need to do is set your criteria for the one WO_Type column to "New Location" or "Existing Project".