Search results

its a chart to be filled by the user complete or uncomplete

not sure what you are referencing

it will be Report

needs several months a whole year i was going to use a drop box to select the month and the year

this is what im looking for but need it for all the months not just one month

i need to be able to create a calendar in a form like the one in the picture i have no idea how i can do this i want to have the user put in a a letter for each result of the area being test on the calendar. https://www.dropbox.com/s/z3m37lfjls1fxue/calandar.png?dl=0

no they dont want to see the count they are only interested in the percentages. in another form i will show the list of the records. Im just about ready to pay someone for help

i also did the following query and it works but the numbers dont match what i need it to do. SELECT Count(MaximoReport.WorkOrder)/ (SELECT Count(MaximoReport.WorkOrder) AS [Total LEWPM Den] FROM MaximoReport WHERE (((MaximoReport.WorkType)="PMINS" Or...

I get an missing opperator error SELECT Sum(IIf(Worktype IN (PMINS,PMOR,PMPDM,PMREG,PMRT)) And MaximoReport.Status) Like *COMP) AND MaximoReport.[Target Start])DateAdd("h",-1,[Enter the start date]) And (MaximoReport.[Target Start])<DateAdd("h",23,[Enter the end date])) AND...

that makes since but since im a novice i dont know how to do that.

want to join two queries so i can take the count of one query and divided by another query to get the percentage of work orders that were completed. the numerator query: SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder FROM MaximoReport WHERE (((MaximoReport.WorkType) In...

i tried it says it too large its over 2.0 GB

i have submitted my database

i'm trying to build a function the counts the records with multiple criteria and divide theat criteria with some count of another criteria to get a percentage. I don't know VBA so i need help.

I have many queries were simply to come up with a number that is a count of records with a specific criteria, to be used later in a calculation. Because those criteria are so lengthy, and change with each variation of the data that is collecting, I’m not sure if an IIF structure would return...

I want count-collecting in VBA using recordsets or the DCOUNT() function. instead of using a query. The queries I already have built are doing pretty much work , but when I try to link them together for your final report, if anything had missing or null values, it causes problems.query 1...

question how would i do that with dcount function instead?

user defined range

its field owner group

here some sample data