Search results

Hi, I’ve a Form with several Subforms linked by Master/Child and a series of filters in the main form to select certain groups of records. My preferred way to filter is by using Recordsource with different Where clauses. I want to display all kinds of stats (like Count, Sum, etc) for the...

I'm developing an application where I built an stand-alone aggregate query (+ a subquery) that groups and totals certain information by years and use it as the record source for a Dialog continuos form. It works like a charm showing all the relevant years as designed, i.e., as a list in the...

In an application (related to the Covid-19 pandemic in the north of Brazil) I've to generate a series of crosstabs queries, a few based on current week's collected data (Sunday being the first day of the week). To limit the query to the current week is simple with a WHERE...

I'm Mario, writing from the north of Brazil (yes, from the middle of the Amazon forest ... :) ). I haven't been programming for many years but I believe to be decently proficient in Access, SQL, etc. I'm making a comeback now in order to help communities to improve all kind of processes done...