query question

[angelinarose via AccessMonster.com]

Hi all,
I need some help with this one not sure if it even possible. I have a table
that has identifier number, transaction number, status, and comments field.
In the 1st query I look in the comments field to find a specific date (using
Like). That query shows me all that is Postperiod. What I need is for the
preperiod records to show up in a query by themselves. I have tried to use
NOT Like but this doesn't provide me with correct results.
Anyone have any idea how I can do this?
thanks in advance!

 

[Jerry Whittle]

The schoolbook solution to this problem is to put the date from the comments
field into a proper date/time field.

What is the date in the comments field? Are you getting it this way from
another system or something like an Excel file.

 

[John Spencer]

You might try posting the query that does work.

You should be able to use the query wizard and the unmatched query to get
the results you want using Your table and the query.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..