How to show rows above an input record number

[Colin Hayes]

Hi

In my query , I want a popup to ask for a record number , and then
display all the rows above that number looking down the autonumber
column. I'm a little stuck for syntax - I'm hoping someone can help.

I'm using this presently in the autonumber column :

Like [Show Records Above : ] & "*"

This gives the popup but then doesn't show all the records equal to or
above the number entered. I've tried several variations on the formula ,
with no success.

Grateful for any assistance.



Best Wishes

 

[Jeff Boyce]

Colin

Define "above"...

Access uses tables to store "buckets o' data", without any particular
sequencing/order.

You have to tell Access to use a particular field to sort by ... and "record
number" means different things to different folks. Some folks imagine that
the count in the bottom left is actually a record number ... NOPE!

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ron2006]

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

 

[Colin Hayes]

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

 

[Colin Hayes]

Hi Jeff

Thanks for getting back.

It's looking down the autonumber column , so it's all records with an
autonumber greater than the input number. That's what I had in mind.



Best Wishes


Colin

Colin

Define "above"...

Access uses tables to store "buckets o' data", without any particular
sequencing/order.

You have to tell Access to use a particular field to sort by ... and "record
number" means different things to different folks. Some folks imagine that
the count in the bottom left is actually a record number ... NOPE!

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi

In my query , I want a popup to ask for a record number , and then display
all the rows above that number looking down the autonumber column. I'm a
little stuck for syntax - I'm hoping someone can help.

I'm using this presently in the autonumber column :

Like [Show Records Above : ] & "*"

This gives the popup but then doesn't show all the records equal to or
above the number entered. I've tried several variations on the formula ,
with no success.

Grateful for any assistance.



Best Wishes

 

[Colin Hayes]

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

BTW Can this be modified to ask for records between two input
autonumbers , do you know?



Best Wishes

 

[Jeff Boyce]

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

BTW Can this be modified to ask for records between two input autonumbers
, do you know?



Best Wishes

Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

 

[Colin Hayes]

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

HI Jeff

OK thanks for that.

I was hoping to do this via a popup input on the autonumber column.

Is this possible?



Best Wishes

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.

Hi

BTW Can this be modified to ask for records between two input autonumbers
, do you know?



Best Wishes

Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

 

[Colin Hayes]

Create a pop-up form named PFrmHIghLowNumber. Put two textboxes on
PFrmHIghLowNumber and name one HighNumber and the other LowNumber. Add
some
code to check that a number is added in both textboxes when you use the
form. Put the following expression in the criteria of your autonumber field:
Between Forms!PFrmHIghLowNumber!LowNumber And
Forms!PFrmHIghLowNumber!HighNumber.

Steve

Hi Steve

Thanks for getting back , but that's way beyond my small abilities , I'm
afraid.

Best wishes

Colin

Between [lower number] And [higher number]


Regards

Jeff Boyce
Microsoft Office/Access MVP

HI Jeff

OK thanks for that.

I was hoping to do this via a popup input on the autonumber column.

Is this possible?



Best Wishes

if the field is indeed an autonumber field then the test/condition
should be:

< [[Show Records Above : ]

This is because an autonumber field is a number not text.



Hi

BTW Can this be modified to ask for records between two input
autonumbers
, do you know?



Best Wishes








Hi

OK , that's got it. Thanks for your expertise - it works perfectly.



Best Wishes

Are you aware that we also buy CDs, Vinyl and DVDs? Send your lists of
unwanted items to (e-mail address removed) and we’ll quote you a price…


You can browse and buy direct from my full list of items at these addresses :

http://s1.amazon.co.uk/exec/varzea/ts/my-zshop/SPJK3X6KOJZR6/026-3393902-9
050050

or:

http://www.CDandVinyl.co.uk

or :

http://www.netsoundsmusic.com/chayes

or:

http://chayes.musicstack.com



To DOWNLOAD the full catalogue click here :


http://www.chayes.demon.co.uk/CDandVinyl_full_catalogue.exe



Best Wishes ,

Colin Hayes.



TEL / FAX : (UK) (0)208 804 9181