Recent content by vpboy_22

Thanks I will try I will try that but what will it do to fix my problem. Oh and by the way thanks for all the help so far!

I only use one feild I only use one feild for Nurses name I want there name sorted acending by first name that is just our procedure for the company. But it still does not work even though you said the sort clause works. there is nothing wrong with my data because it works just fine in all the...

Here is the SQL Code if that is what you were referring to SELECT [Time Sheet].[Nurses Name], [Time Sheet].Title, [Time Sheet].Facility, [Time Sheet].[SP/NON], [Time Sheet].[Week Beginning], [Time Sheet].[Week Ending], [Time Sheet].[Date and time in], [Time Sheet].[Date and time out], [Date and...

Re Post Query How do you do that?

RE Sorting No other colum in my query or my report is sorted exept for nurses name and its sorted in acending order. But it does not sort. Everyother query I have sorts in acending order by Nurses name which is tied into the table new nurses. When I run a report from the querys that are sorted...

Hello I'm at a loss with sorting some data. I have a database program in 2000 file format but I'm using 2003 access. We use this program for staffing. I have a table named time sheet and I created a query to calculate some time diffrences and I also use the query to enter parameters for pull up...