Search results

When filtering on multiple fields, be sure to order the table on the specified fields. If a table is ordered by day, time then filter string should also specify date first then time

You can use query inside query(Subquery) for calculating the number of distinct values like the following select count(select distinct <fieldname> from <tablename>) from <tablename> For the next task write a stored procedure goto first record copy the fieldvalue to a variable move to next...

split the string if the number appears in between. The example is "update <tablename> set <fieldname> = " & <number> & " where <condition>"

Dear rainman89, the string should be like this stLinkCriteria = "[employeeID]=" & Me![employeeID] And "[dateAdded]=" & "'#" & Me![dateAdded] & "#'" DoCmd.OpenForm stDocName, , , stLinkCriteria Observe that the date field value should be enclosed in single quotes

You have to declare a variable of type access application for example dim accapp as new access.application then issue the following commands accapp.OpenCurrentDatabase "yourdatabase.mdb", False accobj.DoCmd.OpenForm "your form in access", acNormal

Make two separate make-table queries.

May I know if the following solution helps you Include more columns in your cross-tab query for %yes and %no for each of the names

Thanks RoyVidar. Yes the NOT IN operator doesn't work with ADODB.filter method. We have to do some round about.

I want to use the NOT IN operator for the filter method of ADODB.recordset in VBA. Do anybody in the forum know the syntax.