beginner question

[diarratech]

Here is the pb! I have an Access table with diffent records
The fields are numfile and statut of action and action number
For instance on one line I would have
numfile Statut numaction
1 started 1
1 over 2
1 not started 3
2 started 4
2 over 5
3 ... ....
etc

I'd like to print the record of each file that has a statut of started. For instance, starting from the bottom I would only print the line of numaction 4 and 1 because those are the only actions that started. I don't want to print the other records.

Thanks

 

[Ovatvvon]

numfile Statut numaction
1 started 1
1 over 2
1 not started 3
2 started 4
2 over 5

design your sql statement as such:

sql = "SELECT * FROM [myTable] WHERE ((myTable.Statut)='started');"

Then execute it in your open-recordset line.

Hope this helps... -Ovatvvon :-Q