Search results

Well I have tried to using MAX inside and outside and it still does not give me the Top 10 by Category (GROUP ID).

Where would I incorporate MAX into this? I will also update the table name as that is a reserved word. Thanks

Bob I removed the table and used the code SELECT New.[GRP NAME], New.[GRP ID], New.[AMMS], New.[CountOfAMMS] FROM New Where New.[GRP NAME] IN (SELECT TOP 10 [GRP NAME] FROM New AS Dupe WHERE Dupe.[GRP NAME] = New.[GRP NAME] ORDER BY Dupe.[CountOfAMMS] DESC) ORDER BY...

Ok I have created a duplicate of the table and named it Dupe and added the following SQL SELECT New.[GRP NAME], New.[GRP ID], New.[AMMS], New.[CountOfAMMS] FROM New Where New.[GRP NAME] IN (SELECT TOP 10 [GRP NAME] FROM New AS Dupe WHERE Dupe.[GRP NAME[ = New.[GRP NAME]...

I am trying to get the top 10 from a query and can not seem to get what I need. Table Name: New Field Names: GRP NAME (text) GRP ID (text) AMMS (text) COUNT OF AMMS (Number) I am trying to trying to display the Top 10 for each GRP NAME, GRP ID, AMMS based on the top 10 with the highest...

Thanks both of you. That always gets me cause you use Or when you are looking at Equal to....and I forget to use And when looking for Not Equal to.

I am trying to get a count of Claim and Sum of Paid Amt where the Rend field is not equal to A6, A7, A8, DF, 26, 62, 77, 91, 93, 94, or 96. The issue I am having is when I run the query it is giving me count and sum from all the records. I am not sure what I have done incorrectly. Here is...

Well I just found out this morning that since users started getting this error they are randomly getting another error. The error is Write Conflict "This record has been changed by another user since you started editing it......" This error is happening in the same place as the other error...

I was thinking something had to change either the database or other changes. The problem is the company I work for has a huge IT department and trying to get a solid answer out of them is not going to happen. No offense against anyone in the IT field as you have some great IT folks and then you...

ghudson I have looked over your sample and I am trying to avoid adding a save button, but will look at the information and see if I can modify it to work for my situation. It is really good code and I may use it in the future. Currently, I do not have the Before Update Event to save or check if...

On my main form I have the Form On Current event set to Me.AllowAdditions = False to prevent new records from being added when users use the scroll button on the mouse. In order to add a new record users have to click on a command button. The database has been running smoothly for about a...

SOS I was able to find a solution by trying the following. =IIF([SumOfTotal Possible Points] = 0,0,[SumOfTotal Points]/Nz([SumOfTotal Possible Points],1)) It appears to be working properly. Thank you for your help.

Thank you! That did remove the error, but when the result of the formula is 0 it is returning a blank value. How would I get the formula to display a 0 instead of a blank?

I have created a report and used the following formula and the report is returning a #Num! error. I have read it is returning the error since it is tring to divide by 0. How would I change the formula to get it to return a 0 instead of a #Num! error? =([SumOfTotal Points]/[SumOfTotal...

dfenton...you are correct. I have been back and forth with them on this and I have dealt with plenty to know what they are doing. DCrake...thank you for the syntax. I will try this out.

I have replaced the DLookup with ELookup and will see what happens come Monday when users began using this. I will post back to let everyone know if I see an improvement in performance. I just wanted to say "Thank You" to everyone for taking the time to help on this. :D

pbaldy, That is the ELookup I was reading about and spending some time looking over the example I was not sure where to began editing the example to make it work for my situation. I guess I am having a off week or it is way over my head.

The problem I have is that the IT department where I work will not allow Terminal Server or Remote Desktop due to security. So I am back to either doing a DAO recordset or using a saved query to return the value of a form field. Can anyone direct me on doing one of the above.

Is this the process for using DAO recordset to search through the table?

I would need it to search the table Audits1 and return the Workload when EmployeeID of the current record is > 0 based on the EmployeeID and DateofWork being the same as the current record. Otherwise not return anything.