Recent content by Kevin-anderson

I have a query that displays emloyee name and hire date. I need to display these hire dates on a report; however, i want each text box on the report to count how many dates fall in a certain range. So the query has all Employee hire dates and i want textbox 1 to count employees hired between...

Perfect Thank you!

I have data stored in a column as text and its all different lengths. I need to format all enties to 5 digits. I know the answer is obvious, yet it alludes me. Any help would be appreciated. Kevin

I have a form that lets a user input additional records into the database; however, different users are using different formats. Is it possible to prompt the user if the formatting is not correct. For example employee ID numbers are 5 digits with an "E" in the front ("E00000''), and many people...

Perfect...Ill just figure out what a sub query is and ill be set. Thank you for your guidance! Kevin

I am currently trying to compare two tables, one table has current up to date data and the other is a monthly report that i have to reconcile agaist this master list. Normally this is easy as i can simply use an unmatched records query using the employee ID number as a matching field in both...