Recent content by MarioUY

Because, as I understand it won't give the answer I want, the count of ALL remaining records in the linked table (the subform table BOOKS)

Right, that is the normal way but the actual implementation needs many queries and I was wondering whether somebody has a better idea to build a solution. Thanks!

Thanks plog. The total for the main form is what I actually do however once filtered I cannot use DCOUNT because in my example the DOMAIN is in Books (I want to count the number of books) but the criteria uses info in the main table (AUTHORS - british) thus the need to use a query. Ranman256...

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...

Thank you my friends, but this is not what I'm asking: I fixed it already w/o any problems. What I'd like to know is why, without any apparent reason, this is happening. Should I change something in the properties when I unbound the form, am I missing something here? Thanks again!

No, is in continuos form but somehow the height of the detail section changed and shows only one record at a time.

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...

I followed namliam's suggestions and it works beautifully well, and it's quite easy to implement. Recommended! So thank you namliam and all of you my friends for the useful suggestions.

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...