Recent content by DawnDesM

I used- Not In ("Code 1","Code 2","Code 3") Good luck!

Hello, Here is the table info I'm working with: class status changeby changedate statustracking INCIDENT- RESOLVED- Person A- 2/20/2014 9:05 - INCIDENT- RESOLVED- Person b- 2/20/2014 11:57 - INCIDENT- QUEUED- Person b- 2/19/2014 13:57 - 01:24:08 INCIDENT- QUEUED-...

Thank you both! using the Format property on the table worked like a charm. I was creating a new table with each run, but changed it to append instead. Thanks again.

Unable to use Between query without pulling dates out of range If I set the Criteria to Between [Enter the start date:] And [Enter the end date:] and input the dates 1/2/2014 & 1/15/2014 i'm pulling data for those dates but for year 2011, 2012, 2013 and 2014 as well if I enter in Between...

Hi, Recently Put in charge of using access to pull data and make reports for a growing help desk. Sadly I have not Access background so questions might be basic, sorry bout that. Thanks Dawn :D