This is just a guess, but try using date time format...6/9/2009 11:39:14
AM
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Diane Lee
Sent: Friday, September 07, 2012 3:27 PM
To: [log in to unmask]
Subject: Re: Advanced Query help!
Tried that. It definitely weeded out a lot, but I'm still getting
objects that were made Public Access back in like 2007, and then taken
off at some point. I need a way to say that only objects that fit
between those entered dates should be considered for the 'true' part.
More parenthesis maybe? But where?
==================================================================
Diane Lee | Collections Manager
[log in to unmask] | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT
06105 | www.chs.org <http://www.chs.org/>
Upcoming Events <http://www.chs.org/calendar> | Membership
<http://www.chs.org/membership> | Donate <http://store.chs.org/donate/>
| Volunteer <http://www.chs.org/volunteer>
Visit us on Facebook <http://www.facebook.com/CTHistoricalSociety> and
Twitter <http://twitter.com/connhistsoc> @ConnHistSoc
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Christine Droll
Sent: Friday, September 07, 2012 4:21 PM
To: [log in to unmask]
Subject: Re: Advanced Query help!
Hi Diane,
Try putting the left (opening) parentheses in the first Entered Date
row, and the right (closing) parentheses in the second Entered Date row.
Christine
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Diane Lee
Sent: Friday, September 07, 2012 3:17 PM
To: [log in to unmask]
Subject: Advanced Query help!
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
[log in to unmask] | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT
06105 | www.chs.org <http://www.chs.org/>
Upcoming Events <http://www.chs.org/calendar> | Membership
<http://www.chs.org/membership> | Donate <http://store.chs.org/donate/>
| Volunteer <http://www.chs.org/volunteer>
Visit us on Facebook <http://www.facebook.com/CTHistoricalSociety> and
Twitter <http://twitter.com/connhistsoc> @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.
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.
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.
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.
|
