Search results

I see this post is 4 years old; however, its exactly what i am looking for, I just need to clarify. Do i add the above line into my existing row source command. The row source is currently occupied with: SELECT Tenants.Name FROM Tenants INNER JOIN [Main Data] ON Tenants.Tenant_ID=[Main...

Eureka, after massive searching, I think i've found it. TotalTime: Round((([End Date/Time]-[Start Date/Time])*24)*4,0)/4 Thanks for the help, its greatly appreciated.

I just spoke with the person who i'm doing this db for and came up with the necessary rounding times. In reading my origional post, I realized I didnt note that my intention was to go both ways depending on the time the individual started/stopped a job. In looking at the overall picture...

I have two cells called Start Date/Time and End Date/Time and TotalTime, qry_StoreReportStart Date/TimeEnd Date/TimeTotalTime4/11/2012 10:00:00 AM4/11/2012 1:46:00 PM3.77 I am in need of help to make the "Total Time" round to the next quarter hour and not round on the hour. Example: The 3.77...

So i've got a portion of this process down, however; being a newbie to creating a database, i'm still learning and for the most part have a lot of issues with understanding coding. As instructed, i've got the form created with a text box and a button as indicated in the directions. The...

It appears as though I am not explaining my intention all too great. Once the query is built, i want to be able to only enter one date to see if that specific single date falls anywhere between the existing 2 job dates.

Please forgive me if I make no sence as I am learning this program small bits at a time. In your response, you indicated to place BETWEEN #01/01/2012# AND #01/30/2012# in the search criteria. * Where do I put this criteria at when i have two different date fields. * Once i figure out where...

I am having some difficulty creating a query I was hoping someone might be able to help me with. I have two separate "Date/Time" fields in a single table, the first titled "Start Date/Time" and the second "End Date/Time". What i am trying to do is create a query to search for any dates...

Rain, I just tested it at home on 2007 and it also works as designed. 2003, 2007, 2010 confirmed. Thanks again for the help.

It was a typo. I used the entire syntax and changed the appropriate reference points and it did exactly what i was looking for. Thanks again for the help, I appreciate it.

I copied your syntax and made the appropriate changes and it does exactly what i want it to do. Thank you very much everyone for your help. I greatly appreciate it.

2010 throws an error indicating the expression entered contains the wrong number of arguments.

I think thats what id like to do to make it -1 prior to anniversary date. Being new to this process can you tell me how i should start this process, im assuming i add onto what ive currently got but the commands are somewhat intimidating.

So I assume there is no way to make it count up on the annivery date rather than the first day of the new year. This being the case for all employees who have been employed for <1 year. For example, im showing an employee who was hired on 12/27/87 as being employed for 25 years where infact...

It seems as though the code works, however; its still calculating up before the actual anniversary hire date. Thanks in advance for the help. I greatly appreciate it.

Its coming back with a syntax error?

I am having some difficulty with a date calculation that i built in a query. The cell is supposed to calculate the difference between two dates and tell me how long an employee has worked for the company in years. The formula I am currently using is Years in Service...

I just downloaded the sample to my desktop and clicked on the button and unfortunately its not doing anything. This may be my fault as i have yet to indicate what version of access i am using, which is access 2007. In looking around and searching for an answer, i keep coming across reference...

Good news and bad news. Good news is thank goodness for Google Translate, the bad news is i'm very new to any of this and have no clue what to do with what or what lines of code to change to corelate with my database. Is this something you might be able to help me with.

Please forgive me for the new thread as I know this subject matter has been touched on. I have built a db for employees and want to add pictures to their profile by way of file path reference. I would like to create a form with a button on it that will allow a user to click on and search for the...