Search results

Hi, I'm a bit stuck and hope someone can help. I have three tables that I am trying to combine the data. I don't need all the data, just some. I'm using three queries. 1st. I have 1 query to sum the total transactions that are over $10,000 based on one Date and the type. 2nd. I have the 2nd...

Thank you for all your help. I really appreciate it very much.

That works! Can you advise me on what changes I would have to make if I added the criteria to my Report Query? I understand that the new queries will not work with the following tied to my Report Source Query. Between [Enter the begin TRAINING DATE to search by?] And [Enter the end TRAINING...

=DSum("AvgDeptScore","qryAvgByDept")/DCount("1", "Training_T") The dcount is correct. It's the dsum. If i run the dsum(first part) i get the total avg from the department which is different from the total of the training records. The avgdeptscore total is 338.5. The total score_percentage is...

The employee count is correct. But the total avg scores is off. I think in your example you are / by the number of employees. I'm trying to divide the total scores by the number of training. One of the field in the summary section is called AccessTotalsDailyID. This is the grand total count...

You are very clever! I didn't think of creating queries, instead I was trying to do the calculations on the report. I fixed the report. No more percentage, just the avg is fine. That was one of my mistake. I created all the calculations that I needed. The average for department, avg for emp. I...

I'm not sure what I did. But here is what I tried to do. I tried to count ([scores]/the grand total]) ) then divide that by the Count([score]/the grand total) * 100 then add the % sign. Once I typed it out, (the above), it doesn't make sense at all. I also notice that I am missing a few...

Hello all. I hope someone can help me with this. I am having problems solving the count employee in the report header and avg of percent calculation. Everything else seems ok. One of my problem is that I can't figure out how to calculate the average of the percent total. I've uploaded my db...

You are correct. I edited my response. I needed Doc's explanation of here's the wrench to fix your problem and this is why and how you should use it.

Thank you. I didn't know how to write the iif statement. Not the iif statement, I meant to say the syntax or where to apply it to.

Doc your formula works very well. I didn't know how to create the syntax. Thank you very much. Thank you everyone.

Right on 3:00am it would fall back to the prior business day. 3:01am would go to the current business day.

My apologies, I might have placed this in the wrong category. I have a form with some transactions. The fields are ID, BusinessDatetime,businessday,amount,type. Right now I don't have anything in the businessday field. It is blank because I don't know how to capture the date based on what the...

Thank you all. I've decided to use unbound fields for the calculation and the conditioning formating. Works now. Thank you all again.

That's a good idea. I will try that.

I uploaded another one. If you look at the totals in red. Those are the totals. Each time a count is done, new customers are entering. The entries is in addition to how ever many customers that are existing in the restaurant. so if the entry is 10 at 8am and 10 at 9am then there should be 20...

I don't know the syntax but I understand the logic. I'm trying to use the below. =IIf(DLookUp("GMAXSET","GUEST_MAX_SET")<=Nz(DSum("GCOUNT","GUEST_T","GDATE=DATE() AND INOUT='IN'"),0)-Nz(DSum("GCOUNT","GUEST_T","GDATE=DATE() AND...

I did something similar to your sample. Your's looks much more organized.

It works great. Now that I look at it, one change. LOW MEDIUM AND HIGH. I've added some calculation fields to the form. I needed to see the actual numbers. Instead of just Maximum and Good, how can I add the MEDIUM where the Count is Less then 5 before the Max Amount?