Search results

Thanks, I will try that. Sorry about the confusion. Rick

Report Help I know, It makes no sense to me either(??) Take a look at the attached report criteria and the report it produces. I hope this helps. Rick

I tried adding the < 10 to the current criteria. The good news, I was able to tell who fell in the catagory. The bad news, They would show as a -1 as opposed to evryone is did not meet the requirements showed as 0 (??) Tom Jones 0 BoB Smith 0 Steve Smith -1 ETC The same applied when I...

Thanks, Can you take a look at the attached sample report? This shows how I am totaling the number of times each user access the EMR. I know need to show who has accessed the system < = 10 times or >= 1000 times. Thanks

Hi All, I have a report that I created that shows the number of employees who have accessed our Meditech EMR module. An example of what the report looks like is: Tom Jones 125 Mickey Mouse 10034 George Bush 10 Bill Clinton 2 I...

Thanks!! Thanks for the feedback!! I will try the suggestions. BTW, The department name field is fed over from our core hospital system. I agree it is not the best naming convention but is is how the data is stored(??) Again, thanks for the feedback, If you have maybe a sample form to...

Hi, I have a report by department that the user needs to enter in the department name to produce the report(Parm.Query). I have tried to make it somewhat easier via wildcards but if they still don't know exactly how the data is stored, they will have a hard time. Example: Labor and Delivery...

Dumb Question but.......... Do these formulas go in the query criteria?? I tried both ideas and neith worked....Sorry. Any ideas?? Thanks again. Rick

Thanks Rich Thanks Rich, I will try it now!! Thanks

Hi, In my database I have a field called "Department". The data comes from our Meditech system and is imported as: PCU-EXP OR-EXP EMERGENCY-EXP...

Thanks Niam, How would I build the query to only change the LAST subform entry?

I have a form with a subform, on the main form there is a "Termdate" Field. On the subform there is a "EndDate" field. The subform shows when a nurse has worked on a Unit during a specified time. Below is what the form may look like: Employee Date of hire Termdate...

Mailman...Guess who.........Sorry, you can give up on me and i will understand : ) I changed the query to reflect your last post, What it gives me is ALL Employees who have a NULL start date and or NULL end date due to the "Or Date isNull" I only need to see the null values for the user...

Thanks Namliam, I did not see prior post. I will try this and hopfully get this monkey off my back. R

This is correct, the null values are there for a reason and cannot be populated with an inaccurate date. Another Example Bob Jones ESD 02/01/01 05/06/01 Sue Smith ESD 03/10/01 If I run a query to show me who worked in the...

Yes, Clear as Mud :)

Apparently my brain is not working either, What is the modifiedEnd Field? Sorry for the lack of knowledge. Here is a screenshot of the current query that works other than the null issue. Thanks

Thanks Guys! I am almost there. One more thing pertaining to this. How do I handle if I am seraching for people and some of the employees have no ending date because they are still employees? Example Employee Unit Start End Smith ESD...

Sorry DCX, It's still not pulling any records. Any other ideas? I cannot believe this is what is kicking my butt.

Can you please give me an example of what I need to do? I am sort of a novice at this, please ba very basic. Thanks again!!