Concatenate in a query

[BBBryan]

Hi,
Can Someone Please help.

I am using Duane Hookom's Concatenate Module.
I am using this right now in my query

I have this
Ticket(s): Concatenate("SELECT [TicketType] FROM [PipingQualificationTickets tbl] WHERE WelderID =" & [Welders tbl].[WelderID])

this work but it only Concatenates All the TicketTypes this way.

I want it to Concatenates but filter to only the TicketTypes That do not have a check mark in the checkBoxes - [SeeSupercededTicket] or [TicketOnFileCanNotUse] (Both of these are checkBoxes)

I tried this
Ticket(s): Concatenate("SELECT [TicketType] FROM [PipingQualificationTickets tbl] WHERE WelderID =" & [Welders tbl].[WelderID] " & OR [SeeSupercededTicket]=False OR [TicketOnFileCanNotUse]=False)

It gives a run time error
Invald SQL Staement; expected 'Delete', 'INSERT', 'PROCEDURE', 'SELECT', or UPDATE

I tried a few more combinations
I am not sure how to add this extra statement into this code.

There is some way to write this and I am not sure how to.


Thanks BBryan

 

[Galaxiom]

It would be better if you explained what you are trying to achieve in terms of handling the data. Provide some examples.

A custom function might not be the best solution.

 

[BBBryan]

Thanks for your responce.
What I want to do is.
I have a table [Welder tbl] with a field called [QualificationView] and then I have a sub Table [PipingQualificationTickets tbl] which could have multiple qualifications. I have a field Called [TicketType], [SeeSupercededTicket] and [TicketOnFileCanNotUse]
I Only want All of the TicketTypes Concatenate to show in the [QualificationView] in the main table field.
I don't want the checkBoxes - [SeeSupercededTicket] or [TicketOnFileCanNotUse] (Both of these are checkBoxes) that are false to show in that field.


Thanks BBryan

 

[Galaxiom]

POnly looked for a minute but I think this is what you want.

Ticket(s): Concatenate("SELECT [TicketType] FROM [PipingQualificationTickets tbl] WHERE WelderID =" & [Welders tbl].[WelderID] & " AND [SeeSupercededTicket]=False AND [TicketOnFileCanNotUse]=False")

Don't use it to update field in the table though. Use it to calculate as required for display only.

 

[BBBryan]

Thanks very much for your help.
That is what I was looking to do.
I see I had to put And instead of Or


Thanks BBryan