Recent content by Spruk_77

Hey all, Here is my basic table structure Table 1 SSN Name Access Table 2 IDnumber Name Access Table one is for US citizens and table 2 is for Non US citizens. I would like a query that shows everyone from both tables that has access. The problem I run into is I have multiple results for...

Thanks, It works perfectly.

:confused: Hey all, I need more help, yet again. Here is my table set up Table Name: Personnalinfo SSN Name PCSETS SEADABrief I have the following quieries: Query1 returns the all people who have a NO in PCSETS Query2 returns all people who are NO in PCSETS and have a valid date in...

Thanks for the advice. The reports I am looking to generate are a list of personnel that are no longer current on certain briefings.

Hey all, I would like my database to open a series of reports once a month. I would like to add this to the startup so say on the first of every month when I open the database these reports open. Can anyone point me in the right direction. Thanks

That was it. Thanks and YOU ROCK.

I would want to add this into the footer of a report.

Ken, Sorry I am confusing so much today. As far as the code you posted I am afraid that is above my head. I am not even sure where I would add that.

I have not wrote any SQL. I just go into design mode and write in the critera. Whatever SQL is written is by access. If this request is above my level that is fine. This is something that would have been nice but not required.

Ok here is a basic sample. I only want the percentage to run on the people who have a no in the PCS field. If you have a Yes in the PCS field I pretty much want the query to ignore you. I hope this helps. Thanks

Hey all, I need a bit of help with percentages. I have a table that the basic set up is as such: Name Brief Date (Date format) Brief Date Expires (Date Format) PCS (yes/no format) I have a query that runs all people that are have not passed the experation date. The criteria in the date...

MStef, That was it, I can't belive how simple it was. In my defense this is the first time I am messing around in visual basic. Thanks so much :)

Hey all, I have a button set up to save information, close form 2, and requery a subform on form 1. The requery is set up in visual basic as forms!subformname.requery. I keep getting the error can't find subformname . Any ideas as to why? Thanks

Ok stop making things so dang easy. Thanks for the help

Ok, I think I may end up doing that. Can anyone think of a way to say hit a button and it will print out a list off all the people that have left in the past 2 years and then delete them. I am requiried to destroy the records after two years.