Ask Your Question

Base: Query, compound REPLACE function [closed]

asked 2017-07-12 00:00:13 +0100

Joe Castor gravatar image

updated 2017-07-12 00:01:43 +0100

My table has a Boolean cell for "Family" . I want to make a query with a column that says "and Family" if TRUE and " " if FALSE. I tried to create a compound REPLACE function but it didn't work. I can only do one or the other. This query is to provide a CSV file for an external emailing function with other data from the table. Any suggestions for overcoming this? Thank you in advance, Joe

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Joe Castor
close date 2017-07-12 02:10:40.803648

1 Answer

Sort by » oldest newest most voted

answered 2017-07-12 00:29:48 +0100

Ratslinger gravatar image

Add to your existing query:

edit flag offensive delete link more


Perfect. Worked Great. Thank you Ratslinger. You continue to help me grow.

Joe Castor gravatar imageJoe Castor ( 2017-07-12 02:00:18 +0100 )edit

If this answers your question please click on the ✔ (upper left area of answer).

Ratslinger gravatar imageRatslinger ( 2017-07-12 02:07:27 +0100 )edit

@Joe Castor First, always glad to help. Questions are always welcome.

While marking a question closed is OK, it can be closed for many different reasons. Marking that a correct answer was provided helps others who are looking for answers to the same or a similar question. This is done in the upper left of the correctly provided answer - see this post.

Ratslinger gravatar imageRatslinger ( 2017-07-12 03:54:35 +0100 )edit

Question Tools

1 follower


Asked: 2017-07-12 00:00:13 +0100

Seen: 66 times

Last updated: Jul 12 '17