Recent content by Garuban

Yes it needs to remain editable, As of now the formula is working, but taking multiple minutes to run the query, and that's my only concern now Thanks for helping

With reduced data it seems to work...

Both seem to be true, the EmployeeName field on the query is pulled directly from the gp data table

When I ran this it showed me some values: DCount("*","GP Data") And this is how it looks with the first criterion: DCount("*","GP Data","[EmployeeName] = '" & [EmployeeName] & "'")

So removing tbl from the equation starts giving me values but if I add the first criteria the Query gets stuck loading for some reason and access crashes

Yeah the table is 'GP Data', the tbl is because I saw some solution in this forum and it was like that. Regarding your solution, it works almost perfectly lol, because it shows me 1 line with the occurrences and how many occurrences are in the table, but for my query I need it to show me for...

That gives me an error

On a calculated field on a query

Hi All, I've been trying to create a formula that can count based on 3 criteria, until now this is the formula that I got but is showing me blank cells DCount("*","TblGP Data","EmployeeName = '" & [EmployeeName] & "' and Recruiter = '" & [GP Data].[Recruiter] & "' and [Week End Date] =# " &...