Is it possible to make a textbox (ack) visible if another textbox
(rowcount)
has the value of 15. You once wrote Me.pgBreak.Visible = (Me.rowcount =
15).
But instead for a pagebreak I would like to show a textbox
It still doesn't work. I tried to make a field Rank in my question but
it
sorts it wrong, like this: 1, 10, 11, 100, 2, 3, 4. It should be an
integer
instead for a string
//Britt
"Duane Hookom" skrev:
You misplaced the final quote. Try:
SELECT *,
DCOUNT("*","[CustBGKS_tabell2]","[SummaförSummaförRADNETTO]<= " &
[SummaförSummaförRADNETTO]) as Rank
FROM CustBGKS_tabell2;
Your table structure isn't clear and most of the time, I would expect
to
see
"CustBGKS_tabell2" in the DCount().
--
Duane Hookom
MS Access MVP
--
I haven't had so much time to try this out, but I'm still trying. Now
I
have
got syntax error, my sql looks like this:
SELECT *,
DCOUNT("*","[CustBGKS_tabell2]","[SummaförSummaförRADNETTO]<=
&
[SummaförSummaförRADNETTO]")
as
Rank
FROM CustBGKS_tabell2;
Thank you so far and I will try again tomorrow
"Duane Hookom" skrev:
You have to use a subquery or DCount() for instance:
SELECT *, DCount("*", "[tblGolfScores]","[GolfScore]<=" &
[GolfScore])
as
Rank
FROM tblGolfScores;
--
Duane Hookom
MS Access MVP
--
How do I do that numbered field in the query?
"Duane Hookom" skrev:
Considering the latest revelations, I would add a numbering
field
to
the
query so that each record is numbered in the appropriate order
and
numbered
1,2,3,4,... You can then set the sorting and grouping expression
to
something like:
=Switch([SeqField]<16,"A", [SeqField]<36, "B", True,"C")
--
Duane Hookom
MS Access MVP
--
It's not exactly what I wanted. I would like a subtotal of the
first
15
customers, and then a subtotal of the next 35 customers, and
than
a
subtotal
of the rest of the customers, and then at total with this
three
subtotals.
So
I don't want a Running sum over all. And I don't want a sum on
every
page
because ther's a lot of customers
"Duane Hookom" skrev:
I would:
- Add another text box to the detail section and
bind it to the field you want to total.
- Set the Running Sum property to Over All
- Give the text box a name like "txtRunSum"
- Add a text box to the Page Footer section with
a control source of
=txtRunSum
--
Duane Hookom
MS Access MVP
Sorry, I have tried again and now it works with pagebreak
after
15
and
then
50 records. Thank you very much. Can you please help me
with
subtotals
before
the pagebreaks.
"Duane Hookom" skrev:
Can you first suggest what didn't work with the previous
solution
since
you
didn't ever reply to my suggestion? Any additional
solution I
would
provide
would most likely be based on my response in the other
thread.
--
Duane Hookom
MS Access MVP
--
message
Duane
You told me how to make a pagebreak (but I could't make
it
work),
but I
realy need help with subtotals. I'll be very happy if
you
help
me
"Duane Hookom" skrev:
Didn't I answer this question a while back or were you
just
grouping
them
without totals?
--
Duane Hookom
MS Access MVP
message
It's about our costumers turnover. I have a report
that
shows
the
records
descending. (in the file I have a record for each
customer
and
a
field
with
their turnover)
The problem is that I would like a subtotal after the
first
15
customers
turnover, and then a subtotal after the next 35
customers,
and
then
a
subtotal after the rest of the customers, and a
total.
