[Resolved] Problems filtering records to display on Datagrid

[Warren Ang]

I have a datagrid, command button and an ADODC bar.

I need to display filtered records from a database. I used NWIND.mdb (Access) for ease of explanation.

The filter is in sql "SelectTitle ofCourtesy, count (TitleOfCourtesy) as Quantity, Region FROM Employees Group by TitleofCourtesy"

I implement this SQL sentence in design time. I put into the ADODC1 recordsource's CommandText (SQL) ; ADODC1.CommandType = adCmdText and bind the datagrid to this ADODC1.

What I want to do is to put this record filtering during runtime. As in I want to do this in code. Can anyone help?

PS: I also have this error: "Syntax Error in FROM Clause"

Thanks in advance

[Warren Ang]

Sorry this is urgent so I'll be grateful if anyone can help.

Thanks

[Pasvorto]

In the database section there is another query very similar to yours. You will find the answer there.