Search results for query: *

Ali29J, Exactly what message do you get? Is it the "network connection lost" or something different.

Thanks...I missed that. It is working great. For anyone in the future viewing this....here is the working code Switch([Inc Time] >= TimeValue("00:00") And [Inc Time] <= TimeValue("07:00"),1,([Inc Time] >= TimeValue("07:00:01") And [Inc Time] <= TimeValue("16:00:00"),2,([Inc Time] >=...

Hello, I have been working on the following query to determine what shift different incidents occur on. What I am getting is a 1 on some incidents and nothing on the others. The one is appearing on the wrong incidents. The field Inc Time is a military time field (24 hour clock) is is currently...

Remou, It is what I needed. When it didnt work, I remember the other posts I had read and tried adding the 0. Thanks alot....Now I understand how/where to use it.

Thanks.... It was Sum(IIf([Type]='Report Sale',Nz([Amount]),0))

Hello, I have reviewed the posts on this topic and believe it applies to my situation, but am lost on how to implement this. I have a report that displays and then totals (in the footer) the number of transactions by type. It counts them and sums them in two different boxes. The problem I am...

Thanks....I will do that. I just met with my users again and beat some correct terms out of them. What they have labeled as "Supervisor" is actually a JobSite Administrator. Each job site will only have one of them. The real "Supervisors" are not tracked as I thought they were and there is not...

I need the ability to capture any combination of possible work days for Participants, JobSites, and Supervisors. Even though M-F will most likely by the most common, M & TH, or any other match up is possible. I have never setup something of this type (workdays), thus this obvious misdirected...

dhookum, I am more than willing to change them, but didnt know of any other way to permit all of the possible combinations of workdays. I am open to suggestions.

I am working on a query that will be used for a report that displays the following: A user selected Job Site (tblJobSites) A Supervisor (sometimes more than one)(tblJobSiteSupervisors) and then all personnel assigned to that job site on the same days as the supervisor (tblParticipants)...

That would be great. I will take whatever help I can get.

Mikey69, I got the link working and that is a good fall back option, however, I would still like to move this entire form into Access. My VBA expert has dropped the ball on this part of the project and hasnt even started on it. I have the report all laid out and ready for data, but I am very new...

Remou, It works...AWESOME!!! Thanks a ton. [Forms]![frm PaymentsEntry].[BookingNumber].Requery

Remou, You are correct. Sorry I didnt make that clear. The code works now, in that the main form {frm PaymentsEntry) stays as the current record. The embeded (display only past payment history subform (sfrm PaymentEntry)) is not requeried to show the latest entry done via the popup form. If the...

RSFromCO, On the bound box on the form, click properties, then format. There are several already defined, but if you want commas then use #,###. If you need a $, put that in the front of the 1st #.

Hello, I have a form [frm paymentsentry] that has a subform launched from a button to enter in payments or fees. When the users closes that subform, I have the mainform requery using [Forms]![frm PaymentsEntry].Requery on the On Click event. The problem is that then the mainform is reset back to...

PHV, That did it!!! Thanks a ton. I would prefer it up higher on the form, but can live with this as long as it works. Can you refer me to something so I can learn why this is? Thanks again.

wtmckown, I tried that also...now I get an #error. Does it matter where this box is on the form or what type box it is? I am about ready to give up and start over by using a subform. I dont know if that will help or not, but this way isnt working. Thanks...

Mark, This is what I have in the control source for this unbound box on the form. DSum("[AmountPaid]", "[qry DailyRevenue]", "[PaymentType] = 'Money Order'") I have checked the names on all of these fields and they match the tables or query. The only thing I havent done is rename my query to...

Thanks....I now am getting #Name.