Hope everyone is having a great Friday afternoon!

 

I'm stumped on an Advance Query I am trying to create for the purpose of
monthly statistics. I would like to know how many records have been made
Public Access over a certain time period. I'm basing the search off of the
Audit Trail, and a New Value of true in the PublicAccess columname, with a
range of dates. I can sort of get it to do from a certain date forward, but
when I try to do the date range, it includes all sorts of records that were
from much earlier. I think my field choices are right, and that I can
probably fix this with proper placement of the parenthesis, but I'm just not
getting it right. I'm sure it's staring me right in the face, but I think
I've been looking at it too long. I'll put a screen shot of the search
below. I'd appreciate any help anyone can give me, including telling me I'm
going about it completely wrong!

(Don't think it matters for this, but I'm on TMS2010)

 

Thanks!

 

Diane 

 

 



 

 

 

==================================================================

Diane Lee | Collections Manager

 <mailto:[log in to unmask]> [log in to unmask] | (860) 236-5621 x(242)

Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 |
<http://www.chs.org/> www.chs.org

 

 <http://www.chs.org/calendar> Upcoming Events |
<http://www.chs.org/membership> Membership |  <http://store.chs.org/donate/>
Donate |  <http://www.chs.org/volunteer> Volunteer

Visit us on  <http://www.facebook.com/CTHistoricalSociety> Facebook and
<http://twitter.com/connhistsoc> Twitter @ConnHistSoc

 


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.