Selecting a range between 2 filters

  • Thread starter ic_fish via AccessMonster.com
  • Start date
I

ic_fish via AccessMonster.com

Hi,
Am not an access guru, so please bear with me.....

I have a report, which runs on the value from a filter, ([PSGC]=Forms!
[FormFrontEnd].Combo18)

In this instance, the PSGC code is selected from the value found in Combo Box
18. (it works fine)

However......

As the PSGC codes can cover a range, say AA0000 to CA0000, I want to amend
the above to pcik up the ranges => and <= to the TWO selected filters. Where
AA0000 (is Combo18) and CA0000 (is Combo93). My current solution will only
find the absolute value selected, based on 1 filter.

Any help would be really appreciated, thanks.

Ian
 
R

RonaldoOneNil

([PSGC] >= Forms![FormFrontEnd].Combo18 And [PSGC] <= Forms!
[FormFrontEnd].Combo93)
 
I

ic_fish via AccessMonster.com

Doh....that was easy then.....had had a go at something similar pre-thread,
so wasn't far off the mark. Your fix has been fine, mnay thanks
([PSGC] >= Forms![FormFrontEnd].Combo18 And [PSGC] <= Forms!
[FormFrontEnd].Combo93)
Hi,
Am not an access guru, so please bear with me.....
Click to expand...
[quoted text clipped - 15 lines]
Ian
Click to expand...
Click to expand...
 
Top