want to sort by ticket only if ticket# kind of matches

B

babs

Iif[ticket]=[ticket] & *, ticket, comment

I am trying to put code into the groupby of a report I am creating. right
now it is grouping by comment. However when the ticket it number is similiar
meaning if for example 1234 and 1234*. The * is the only situation I am
working with- I would like it to group by ticket # only if they are similar
and otherwise group it by comment.

Any ideas,
Barb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group by using IF then?? 3
Using Microsoft Access as a Service Ticket Write-up program 0
Using an ActiveX control instead of multiple Access controls 0
Sorting by Ticket # 0
Sorted and Unique Date Period 2
Refreshing main form from the subform 1
Printing x copies of report based on x available seats 2
Option Boxes showing data 3

Top