The final query isn't too bad. Unfortunately Base doesn't like
pretty-printing so a raw view is hard to read. Here's what I finally
used. I just need to copy the raw spreadsheet into a Base table then
print against the query. It still means the code is split across two
documents (the
A (more difficult) method to use the age ranges from their own table
(separate from the other data) would be to use a correlated subquery. Then
you could have "cleaner" SQL. You can find examples of this on the web.
OR I think there may be limited support for saving query formatting like
Le 07/05/2016 16:15, John Meyer a écrit :
Hi John,
> I'm trying to find a way to insert a user's first and last name as defined
> in the user date into a cell in a spreadsheet. Is there a function that
> will let me do that?
Probably with a macro that fetches that information :
