I’vedeveloped a Microsoft Access Database that includes injury information for severalwork locations and multiple years. I amusing a query to pull DOI/injury data for the current calendar year using a daterange [>=#1/1/2017# And <#1/1/2018#]. Everything is working beautifully!!!
I now wantto expand the query to show DOI/injuries occurring within the date range plus older injuries from previous years with an “open”claim. The tablehas a “Status” field to identify open and closed claims, but I’m not sure howto achieve both. Any suggestions? Thanks.