Recent content by swmidkiff

Thanks for the info. Is it possible to combine into 1 query that would give me the same results or do I have to split the query? I'm trying to make this as simple as possible for the users. Thanks again.

Good Afternoon, I have a database for asset tracking. We are required to do a 10% random inventory each month so that by the end of the 10th month we have inventoried 100% of all assets. After the 10% inventory is completed the date is entered into the table. I've built a query that will...

plog, Thanks for the input. Unfortunately this is the way that we received the database AND the way they want it kept which means that I have to find a way to move the data and make it work If I had my druthers I would rebuild it as you stated but it's above my pay grade.

Good Morning, We have a database that tracks personnel with security clearances. There are 3 tables. One for individuals with ACTIVE clearances, one for individuals who are IN PROCESS and one for individuals that have been DEBRIEFED and are no longer cleared. What I want to do is set it up...