Report split between number range and number range (1 Viewer)

GaryPanic · Jan 7, 2019

Vague heading ..
Hi Guys
OK I might be having a moment here

What i want to do..
i have a query which sorts set of records ( just plain text) into order

so
number 1 - test
number 2 balloon
number 3 - carrot
number 4 earwig
etc - the list is quite long

what I want is for the ability to have listed all of the numbers below say 10
then have some other info from another table - this would just be
name , address and some other stuff and then more list say 11-25 then more infor from the other table
accessv2010

I have dumbed it down the text would be paragraphs

isladogs · Jan 7, 2019

Sorry but you've 'dumbed it down' so much I can't understand it
How many fields are included? What are the field names & datatypes.
Could you show a few real records (or realistic anyway)

MajP · Jan 7, 2019

Return First Ten Records
Select Top 10 SomeID, OtherFields From SomeTable Order By SomeField

Return Next Ten Records
Select Top 10 SomeID, OtherFIelds From SomeTable Where SomeID Not IN (Select Top 10 SomeID from SomeTable Order by SomeField)

Return Next Ten Records
Select Top 10 SomeID, OtherFIelds From SomeTable Where SomeID Not IN (Select Top 20 SomeID from SomeTable Order by SomeField)
....
I think this is what you meant.

GaryPanic · Jan 7, 2019

here goes
It is for insurance
on one policy you will have
Type weather Insurance
then insured
say Fred Smith

Then address
then dates
Then location
then interest

OK so the d/b has Fred smith , location and dates

another table will have Type and interest

i wanted to have Type (weather) with a number say between 1 and 10
and interests between 11- and 20

so every text below 10 will go above Fred Smith
and everything between 11-20 to go below

(I will have more database fields go after 20)

GaryPanic · Jan 7, 2019

I could have lots of sub reports but there must be some way of grouping these

Another policy could be
type Prize indemnity and re-insured
both of these would go above Fred Smith
and different text beneath

GaryPanic · Jan 7, 2019

MajP said:
Return First Ten Records
Select Top 10 SomeID, OtherFields From SomeTable Order By SomeField

Return Next Ten Records
Select Top 10 SomeID, OtherFIelds From SomeTable Where SomeID Not IN (Select Top 10 SomeID from SomeTable Order by SomeField)

Return Next Ten Records
Select Top 10 SomeID, OtherFIelds From SomeTable Where SomeID Not IN (Select Top 20 SomeID from SomeTable Order by SomeField)
....
I think this is what you meant.

Yes.

kinda
select records between x and y
- insured
-Address

select records between A and B

jdraw · Jan 7, 2019

Gary,

Why not show us a list of records, then some subset of what it is you need from the list
--and repeat subsets as necessary. I think MajP is psychic to understand your post. He gets my "Best guess of the year prize". Of course, I'm with Colin ---confused.

What is it that relates the info in these other tables?

GaryPanic · Jan 7, 2019

i'll put something together ..

MajP · Jan 7, 2019

I think MajP is psychic to understand your post. He gets my "Best guess of the year prize". Of course, I'm with Colin ---confused.

After post 4 I am just confused and do not think my guess is in the ballpark.

Report split between number range and number range (1 Viewer)

GaryPanic

Smoke me a Kipper,Skipper

isladogs

MVP / VIP

MajP

You've got your good things, and you've got mine.

GaryPanic

Smoke me a Kipper,Skipper

GaryPanic

Smoke me a Kipper,Skipper

GaryPanic

Smoke me a Kipper,Skipper

jdraw

Super Moderator

GaryPanic

Smoke me a Kipper,Skipper

MajP

You've got your good things, and you've got mine.

Similar threads

Users who are viewing this thread