Show DBGrid without some records

[Fatality]

Hi, im kinda new with delphi and have a problem:

I have a table (acces) with 3 columns:
- nr
- begin date
- end date

I have 3 DBGgrid's:
- 1st: i show all the records of the table
- 2nd: i WANT to show all records with empty "values" in the column 'end date'
- 3th: i WANT to show all the records exept for the records witch are showned in the 2nd DBGrid

Can anyone help/explain to me how i can do that??

Thanks in advance
(sorry for my english)

 

[svanels]

You have to use a Query and link the dbgrid via a datasource to the query.

Check out also the Faq area in this forum

Regards

Steven van Els
SAvanEls@cq-link.sr

 

[Fatality]

Hey thanks for the advise, it works with a ADOQuery now