Prev: Rounding Averages on my Report
Next: Report exporting different data from what is on the report
From: Donna on 27 Apr 2010 09:23
Al,

I need to be able to rank order these records each time the query is run as
the order may change throughout the day as users call up the form.
--
Donna N.


"Al Campagna" wrote:

> Donna,
> Why do you need to sequentially number your records?
>
> If it's used to identify a particular record, for purposes of filtering
> a report, that would be better handled by an Autonumber field in your table.
> Since it would be calculated, and change as sorting changed, it would be
> useless as a record identifier.
>
> --
> hth
> Al Campagna
> Microsoft Access MVP 2007-2009
> http://home.comcast.net/~cccsolutions/index.html
>
> "Find a job that you love... and you'll never work a day in your life."
>
> "Donna" <Donna(a)discussions.microsoft.com> wrote in message
> news:36101FEE-CA09-4A91-8322-EBA4E60DC684(a)microsoft.com...
> > Al,
> >
> > That's what I was afraid of as far as functional buttons on a report.
> >
> > I already created a form for that purpose, but I needed to also have the
> > records numbered in sequential order and could not find a way to do that
> > on
> > the form, so I went with a report.
> >
> > Is there a way to show the records sequentially numbered on a form?
> >
> > Thanks for your help.
> > --
> > Donna N.
> >
> >
> > "Al Campagna" wrote:
> >
> >> Donna,
> >> Reports don't support functional buttons, nor their events.
> >> Your best bet is to create a form that lists your records, and
> >> use a button on it , to call a form for a specific value.
> >> You should be able to use the same query used on your current report
> >> to
> >> feed the form.
> >> --
> >> hth
> >> Al Campagna
> >> Microsoft Access MVP 2007-2009
> >> http://home.comcast.net/~cccsolutions/index.html
> >>
> >> "Find a job that you love... and you'll never work a day in your
> >> life."
> >>
> >> "Donna" <Donna(a)discussions.microsoft.com> wrote in message
> >> news:36AF6A8C-A56C-449C-8508-8ECF900362C8(a)microsoft.com...
> >> > Is it possible have a report which is from a query (which is based on
> >> > numerous other queries) that has buttons to open a specific form for
> >> > each
> >> > record on the report?
> >> >
> >> > I would like users be able to open the report and select a button which
> >> > opens a specific form based on the results shown on the report.
> >> >
> >> > Any suggestions would be appreciated. Thanks.
> >> > --
> >> > Donna N.
> >>
> >>
> >> .
> >>
>
>
> .
>
From: Al Campagna on 27 Apr 2010 11:00
Donna,
Tell me about the fields in your records.
Do you have a field that you are sorting on?
Let's say that each record has unique CustID autonumber field, and the
records are sorted by that value...
CustID
23
31
32
33
47
etc...
Then a calculated field ([SeqNo]) with... (use your own field/object
names)
=DCount("CustID","tblYourTable","CustID < " & CustID)
CustID SeqNo
23 1
31 2
32 3
33 4
47 5
etc...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Donna" <Donna(a)discussions.microsoft.com> wrote in message
news:DABEBCD5-A131-4FA6-A2CE-DC45035864A0(a)microsoft.com...
> Al,
>
> I need to be able to rank order these records each time the query is run
> as
> the order may change throughout the day as users call up the form.
> --
> Donna N.
>
>
> "Al Campagna" wrote:
>
>> Donna,
>> Why do you need to sequentially number your records?
>>
>> If it's used to identify a particular record, for purposes of
>> filtering
>> a report, that would be better handled by an Autonumber field in your
>> table.
>> Since it would be calculated, and change as sorting changed, it would
>> be
>> useless as a record identifier.
>>
>> --
>> hth
>> Al Campagna
>> Microsoft Access MVP 2007-2009
>> http://home.comcast.net/~cccsolutions/index.html
>>
>> "Find a job that you love... and you'll never work a day in your
>> life."
>>
>> "Donna" <Donna(a)discussions.microsoft.com> wrote in message
>> news:36101FEE-CA09-4A91-8322-EBA4E60DC684(a)microsoft.com...
>> > Al,
>> >
>> > That's what I was afraid of as far as functional buttons on a report.
>> >
>> > I already created a form for that purpose, but I needed to also have
>> > the
>> > records numbered in sequential order and could not find a way to do
>> > that
>> > on
>> > the form, so I went with a report.
>> >
>> > Is there a way to show the records sequentially numbered on a form?
>> >
>> > Thanks for your help.
>> > --
>> > Donna N.
>> >
>> >
>> > "Al Campagna" wrote:
>> >
>> >> Donna,
>> >> Reports don't support functional buttons, nor their events.
>> >> Your best bet is to create a form that lists your records, and
>> >> use a button on it , to call a form for a specific value.
>> >> You should be able to use the same query used on your current
>> >> report
>> >> to
>> >> feed the form.
>> >> --
>> >> hth
>> >> Al Campagna
>> >> Microsoft Access MVP 2007-2009
>> >> http://home.comcast.net/~cccsolutions/index.html
>> >>
>> >> "Find a job that you love... and you'll never work a day in your
>> >> life."
>> >>
>> >> "Donna" <Donna(a)discussions.microsoft.com> wrote in message
>> >> news:36AF6A8C-A56C-449C-8508-8ECF900362C8(a)microsoft.com...
>> >> > Is it possible have a report which is from a query (which is based
>> >> > on
>> >> > numerous other queries) that has buttons to open a specific form for
>> >> > each
>> >> > record on the report?
>> >> >
>> >> > I would like users be able to open the report and select a button
>> >> > which
>> >> > opens a specific form based on the results shown on the report.
>> >> >
>> >> > Any suggestions would be appreciated. Thanks.
>> >> > --
>> >> > Donna N.
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Rounding Averages on my Report
Next: Report exporting different data from what is on the report