Search results

After more research and some changes i have made, it is not the SharePoint that is the issue but rather my tables will no longer filter when using Today or Yesterday if there is and empty field. I have worked through my data but i can't see any problems with the data, granted i know i that...

I recently moved some of my be tables to SharePoint to test is see if it is viable option for my be tables. So far everything is good except for one minor issue, I am getting the error "Data Type mismatch in criteria expression" when i try and filter the table or run a query. this only seems to...

Thanks, yes I realized my issue a minute after I posted. I had tryed to set the focus to something else. I just needed to set the focus to the control that is visible.

Hello, I have a Main Form with a Sub-Form, the sub-form is base off a query. on the sub-form i have 8 controls, one of them is "Status' and "Process" and "Review" My Main Form have a Refresh command that refreshes the data in the sub-form. What i am trying to do is make the "Process" Control...

Hello everyone who reads this, I work for a bank and have built a workflow tool using access, i have a section where i have a start date/time and I need to add a certain amount of hours to that start date/time to give my users the due time for a loan. So our operation hours are 8 am to 5 pm...

Perfect, thank you that is exactly what i needed. I am always forgetting about the simple functions that i can use.

I have a query based form i use to gather data to generate a report. I have 2 forms Form A is where users open all reports from. On form A i have 2 unbound fields "Report Start Date" and "Report End Date" my queries us these from Form A as the criteria for the queries. I have like 30 reports...

I guess this were i am getting stuck, I found one issue that i was having that's what was causing the report to fail, so that i have now is -13022.33333333 as a returned Sum value. So the next step is to turn that into a usable representation

Pefect,a direction i can work with. I am going to post a few things here for you to see, the first is the coding i use to get me times and the second is my module that way you can what i am currently doing and what works in order to move forward. I use the above on an after update on one of...

Did you even read what I posted, or did you just want to continue to sound condescending? I know i do not have use to the stored data, but again like i said before i can NOT use DateDiff since it will not calculate work hours. I can use use my work hours module up to a certain point. I can get...

I know that i shoudn't store some data but it was requested and that is what i have to work with, so i need a way to add up my [Total_Time field]. I get what you are saying about running a query and i am building a report so i am running a query for the report. DateDiff will not work correctly...

In my database i am building a totals report on each employee for a certain job they do, in the work for i have a start date and time and stop date and time, then i have a 3rd field that stores the calculated total time it took to do the work, it is a Short Time formated field. That all works...

In my DB that we use and a workflow tool, some of our work has and due date and time.If we get the complete_package our work time starts and we have X amount of time to complete our work. This is something i worked on but set it aside, now i am coming back to try and fine tune this so it returns...

I am trying to run a query that looks at data/time. The expression i have so far isn't working and i need some suggestions please. Use Date2: IIf(([Use Date]<"#03:00:00 PM#"),[Use Date]+1,[Use Date]) So what i need is for this to look at [Use Date] and if [Use Date] is before 03:00:00 PM then...

Thanks for the idea's, it doesn't work for this need but it did resolve another issue i was having within a report. I think the issue is that [Date Sent] and [Unpended Date] are fields and values generated in this query so i do have to test for Null values in order to reach the desired results...

So something like; Date Use: =(Nz([Unpended Date]),[Date Sent])

The reason is we track the incoming date and the completed date and is usefor different reasons thought out our reporting. Each record can be pended if we don't have what we need to complete. Once the record is Unpended and completed we calculate the work time. So our start time can either be...

I figured it out, what i was do was right but i needed to do is a different way thanks for responding to my post. Use Date: IIf([Date Unpended]=" ",[Date Sent],[Date Unpended]) That was the way i need to do the expression

Ok so what i am working with in the query i have 31 records, based on the expression i get 5 dates in [Use Date] and those are the fields in [Date Unpended] that are not null, if i change is around i get all 31 dates from [Date Sent] What i am trying to so is figure out work time, The [Date...

I am working on some report query's, i have 2 fields that i need to make one if 1 one of them is not null. Field 1 is: Date Sent Field 2 is: Date Unpended In my query i have this expression Use Date: IIf(IsNull([Date Unpended]),[Date Sent],[Date Unpended]) So what i mean by all this is the 3rd...