cpb's profiel - activiteit

@Roadkill1954, i obviously cannot test the code but you can retrieve the record count from the result set like so: Sub

it seems that the OP will not respond which helps no one and means that the thread cannot develop. my solution was base

@rstp looking at the error message i can only suggest: from the 'Base' window 'menu:Edit>Database>Advanced Set

@mathteacher asked Is there an easy way to write a query that will flatten the rows into columns? none of the open sour

@mathteacher asked Is there an easy way to write a query that will flatten the rows into columns? none of the open sour

i am making this post as an answer because i cannot see how to include an attachment in a comment. @gkick i saw your pr

@Ratslinger said do not understand why you have not posted before? initially i did not know what to make of this commen

have replaced attachment.

i am making this post as an answer because i cannot see how to include an attachment in a comment. @gkick i saw your pr

i am making this post as an answer because i cannot see how to include an attachment in a comment. @gkick i saw your p

hello @JohnnyG, you can return a decimal value like this: select avg(1.00 * "MyFieldName") from... precision is deter

@LeoP, Ratslinger has solved your issue. the Base Relations Design window is buggy and unreliable so it's worth double c

what an effort to post a comment!!! struggling to format this. ( case when (select "ID_assunto1" from "tFilt

what an effort to post a comment!!! struggling to format this. ( case when (select "ID_assunto1" from "tFilter") i

what an effort to post a comment!!! do not seem to able to format this. ( case when (select "ID_assunto1" fr

what an effort to post a comment!!! do not seem to able to format this. ( case when (select "ID_assunto1" from "tF

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end

what an effort to post a comment!!! case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case

case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case when (select "ID_assunto2" fr

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case when (select "I

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case whe

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case whe

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case when (select

@pmfs1987. it's gratifying to see that you have achieved your own solution. query execution depends largely upon the s

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

hello pmfs1987, Edit: 2020-06-05 i have replaced my original answer in response to the comment "ID_assunto" field

continuation of previous comment. the only field within the group 'Style' which is guaranteed to be UNIQUE is 'Name'.

@Ratslinger yes my comment is misplaced, it should have been targeted at the original poster. sorry but unable to fix as

with reference to my answer: your report is actually displaying the data exactly as instructed. you declared 1 group '

hello ptoye, the field causing the issue is "Name". use the 'Sorting and Grouping' dialogue to fix like so: would a