Recent content by Rbutts25

Thank you for your help, I will let you know if I figure it out.

Pat, I do not follow what you are saying about not saving it as well as ding it in the query. I thought I had done it in the query. Ryan

I am not sure how thatwould work. I am not familiar with an update query.

Is there a way to take a yes/no field and have it be changed from yes to no, and visaversa based on the date? I have developed an sql for this, but it is not working properly, does anyone have any suggestions? Here is the sql: SELECT tblMBUSAResourceList.Active FROM tblMBUSAResourceList...

Thank you very much for your help, the solution you gave me worked extremely well. Ryan

Ok, I have gotten pretty far, just a few more bigs and I should be out of everyone's hair. I am trying to count the number of yes's from a Yes/No Format. I have gotten an sql, but it is bringng back the count of the total Yes/No not just the yes's. Does anyone have any advice, the sql is...

When I created relationships between the table and query I ran into another proble. Now, I am not getting any results. This is the SQL: SELECT tblMBUSAResourceList.[I/O Number], tblMBUSAResourceList.[I/O Name], tblMBUSAResourceList.Consultant, tblMBUSAResourceList.Vendor...

I would like to be able to create a report that will count the number of number of contractors in the beginning of the month and at the end of month. I am trying to use this as a tracking tool. I figured the best way to do this is to count the number of contractors in the beginning of the...

Please Help Me.... I am trying to count the number of active contractors at the beginning of the month, and then do the same thing for the number of active contractors at the end of the month. I have their end dates and start dates enterred into a table. I would like for the count to update...

I still have not been able to get this to work. I am going to continue playing with it to try to figure out, thank you for your help.

Here is the SQL, thank you for your help. SELECT [MBUSA Resource List].[I/O Number], [MBUSA Resource List].[I/O Name], [MBUSA Resource List].Consultant, [MBUSA Resource List].Vendor, [MBUSA Resource List].[IT Department], [MBUSA Resource List].[Current Rate], [MBUSA Resource List].[Planned...

There are no lines

How do I do that? I'm sorry, I am a newbie to Access.

For some reason, in the query I created, the number of records is 12321. It should only be 111. The number of records seems as though it was squared. Does anyone know anything as to why this is happening?:eek:

I have tried this and it has not worked, I think I am puting the function in the wrong place, where does it go in the query?