Page 1 of 1

query

Posted: 17 Jun 2023 18:20
by Ossey55
I have 2 questions about queries.

I have started making some custom queries, that are working great. I was just wondering if there is a way to add a column for a Record ID. I am looking for an expression to use.
example: If Jim was the home person in my tree, and his Record ID is 1, how do I get the 1 to show as a column in the results of my query?

The second question is:
Is there a way to have the columns in my results either have a word wrap effect or be shown vertically like you can do in Excel? I am just trying to get the long Columb name to take up less space because the results only answer yes or no.

Re: query

Posted: 17 Jun 2023 18:33
by LornaCraig
The expression for the Record ID is =RecordId().

I don't know of a way to get the text in the column heading to wrap, but you can adjust the width of the columns. (That will of course obscure some of the text in the heading.)

Re: query

Posted: 17 Jun 2023 19:52
by tatewise
Hint: A way of discovering how to display a value such as Record Id is to find a Query that already displays Record Id and inspect its Column tab expression.

You can make the Query Window Results font small so the text takes up less space.
See Tools > Preferences> Query Window > Fonts... > Query Window Results > Edit
You could also use some form of abbreviated Column Heading with a key in the General tab.