Search results

To run a dynamic query under dcount, the sql filter query should be written as smig stated qrycounter = DCount("[Logid]", "tbllog", "[tbllog].[sitesid] = " & [forms]![frmsites]![sitesid] & " ") or (if sitesid is a textfield) qrycounter = DCount("[Logid]", "tbllog", "[tbllog].[sitesid] = '"...

Could you post a mdb 2000 format database for my testing?

Could you save your db example as mdb 2000 format for testing?

Alternative answer using the Top-n Subquery Approach SELECT InmateID, Name, CaseID, Branch, Hearings FROM table1 WHERE table1.CaseID IN (SELECT TOP 1 CaseID FROM table1 AS dupe WHERE dupe.InmateID = table1.InmateID and...

Try the following:- SELECT InmateID, First(Name) AS FName, First(CaseID) AS FCaseID, Branch, First(Hearings) AS FHearings FROM table1 GROUP BY InmateID, Branch;

I could only figure out the somehow brutal method to use DAO or ADO to loop over the Branch Column and add one column (new-col) to store the key value of 1 or 0 based on the last row value of Branch Column. if last row of Branch Column = current row value, new-col value =0, otherwise new-col...

In the query window, First select those fields you want, ie. field1, field2, .... Then add a column with formula MyTotal:Nz([Field1])+Nz([Field2])+Nz([Field3])+..... This indeed is a calculated field. It would be better for a beginner to read some tutorials on query first. Then you might...