good morning all,
I hope I can explain my problem "understandably"
On my main form (Customer) I have a sub form where concert tickets are selected (Category 1 or 2) for the selected customer.
Now I would like to add a new record to a "summary" sub form.
I have made a recordset clone of the selected tickets in the 1st subform (i have 10 records, 3 Category 1 and 7 category 2)
I have a recordset of the summary table then I
summary.addnew
Total nr. of tickets - recordcount of clone
category 1 - ?
category 2- ?
String value of tickets numbers: 001;002;056;078 etc...
summary.update
Can anyone help me a bit here? How do I count the records in the recordset.clone with certain criteria?
And how can I create a string of the ticket numbers in the recordset.clone
Thanks so much
I hope I can explain my problem "understandably"
On my main form (Customer) I have a sub form where concert tickets are selected (Category 1 or 2) for the selected customer.
Now I would like to add a new record to a "summary" sub form.
I have made a recordset clone of the selected tickets in the 1st subform (i have 10 records, 3 Category 1 and 7 category 2)
I have a recordset of the summary table then I
summary.addnew
Total nr. of tickets - recordcount of clone
category 1 - ?
category 2- ?
String value of tickets numbers: 001;002;056;078 etc...
summary.update
Can anyone help me a bit here? How do I count the records in the recordset.clone with certain criteria?
And how can I create a string of the ticket numbers in the recordset.clone
Thanks so much