Using Maximum in Design View of query

1 reply [Last post]
greenfrog42
Offline
Last seen: 4 weeks 3 days ago
Title:
Joined: 28 Apr 2016
Posts: 1
I can not get the correct query in design view BASE 5.0.0.1

I set Group and Maximum but Maximum does not return the Maximum dates in the query

Any one have an idea of how to do this in design view, I am not interested in doing it in SQL, I had no problem doing this in MS Access.

I am trying to switch my database to Libre Office because I do not agree with MS new billing for software.

Thanks

Ratskinger
Offline
Last seen: 4 days 18 hours ago
Title: ★★★★
Joined: 23 Feb 2016
Posts: 91
Query
Simple query in design mode.
AttachmentSize
QueryMaxDesignMode.png 65.04 KB

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.