Monaco Editor - Good Stuff! (1 Viewer)

[NauticalGent]

I opened up a query in SQL view and here is what I saw:

SELECT
    tbl_Participants.RiderID,
    [FirstName] & " " & (" """ + [NickName] + """") AS Member,
    tbl_Participants.LastName,
    tbl_Participants.Email,
    tbl_Participants.ContactNumber,
    tbl_Participants.MotorcycleOwner
FROM
    tbl_Participants
    INNER JOIN tbl_Events ON tbl_Participants.RiderID = tbl_Events.RiderID
WHERE
    (
        ((tbl_Participants.Email) IS NOT NULL)
        AND ((tbl_Events.EventDate) = #7 / 27 / 2024 #)
    )
ORDER BY
    tbl_Participants.RiderID;

Love this format, every once in awhile the Access team gets it right...

 

[GPGeorge]

I opened up a query in SQL view and here is what I saw:

SELECT
    tbl_Participants.RiderID,
    [FirstName] & " " & (" """ + [NickName] + """") AS Member,
    tbl_Participants.LastName,
    tbl_Participants.Email,
    tbl_Participants.ContactNumber,
    tbl_Participants.MotorcycleOwner
FROM
    tbl_Participants
    INNER JOIN tbl_Events ON tbl_Participants.RiderID = tbl_Events.RiderID
WHERE
    (
        ((tbl_Participants.Email) IS NOT NULL)
        AND ((tbl_Events.EventDate) = #7 / 27 / 2024 #)
    )
ORDER BY
    tbl_Participants.RiderID;

Love this format, every once in awhile the Access team gets it right...

Join Colin's upcoming AUG meeting for a full one-hour tour de force on new Access features. I'm too lazy to find the link, but it's here somewhere.

 

[CJ_London]

There are issues, hopefully they will be resolved soon. Main bugbear for me is sql using an aliased query created in Monaco is not always recognised as valid in the QBE

 

[Gasman]

Join Colin's upcoming AUG meeting for a full one-hour tour de force on new Access features. I'm too lazy to find the link, but it's here somewhere.

Here

 

[isladogs]

The new expanded SQL format is just one of the three major improvements added to Monaco recently.
The other two are:
a) partial query execution
b) speedy (pre-) loading (version 2507)
See my article on these features:

Monaco SQL Editor Improvements

This short article outlines three significant improvements to the Monaco SQL Editor recently announced by the Access team and which will roll out to all channels in the coming months.

www.isladogs.co.uk

I will indeed be demonstrating all of these together with several other New and Forthcoming Access Features in my presentation to the Access Europe User Group on Wed 6 Aug @18:00 UK time.
For more info, see the link @Gasman provided in post #4 or see the full details at:

New and Forthcoming Features in Access

In this session, Colin Riddington will be discussing several recent changes including VBA support for modern charts, command line project signing and several improvements to the Monaco SQL editor. He will also discuss two significant new Access features recently announced that will be rolling...

www.isladogs.co.uk