Re: Sorting for DataReport?
Re: Sorting for DataReport?
Are you using MS access as your backend?
:) :) :)
Re: Sorting for DataReport?
Quote:
Originally Posted by KGComputers
Are you using MS access as your backend?
:) :) :)
Yes. :)
Re: Sorting for DataReport?
Hi,
Try creating a queries in your database and apply the criteria for sorting for index and age...Then in your data report, use the queries as your record source...
:) :) :)
Re: Sorting for DataReport?
Mind if you can show examples? Thanks alot!
:)
Re: Sorting for DataReport?
Hi....
I assume that you will be producing two reports. First is sorted by index and second is sorted by age..Just simply apply the appropriate sorting criteria in the query design view.The first query (qryindex) refer to the field index then choose the appropriate sorting criteria. Same with the query for the sorting the age..In your data environment simply add the queries/stored procedures...
:) :) :)
Re: Sorting for DataReport?
So I write the queries in my report form? Please show any code on queries if you don't mind.
:)
Re: Sorting for DataReport?
HI,
In my case the queries should be created in MS Access database window...I would normally do this to avoid too much coding..Have you tried creating queries in the MS Access database window?
:) :) :)
Re: Sorting for DataReport?
How do I do that? Please advice!
Re: Sorting for DataReport?
Quote:
Originally Posted by KGComputers
HI,
In my case the queries should be created in MS Access database window...I would normally do this to avoid too much coding..Have you tried creating queries in the MS Access database window?
:) :) :)
Please advice... :)
Re: Sorting for DataReport?
Hi,,,
Quote:
So I write the queries in my report form? Please show any code on queries if you don't mind
Queries are normally done in query design view of MS Access.Just simply drag the fields of a particular table to the query design view... I assume you have some background on MS Access...Am I correct on this?
What version of access are you currently working on?
You may try searching on MS access help on how to create queries in ms access....
:) :) :)
Re: Sorting for DataReport?
My database is in access 97.
Re: Sorting for DataReport?
Hi,,,
Have you tried making simple data reports in your projects using the data environment designer?
:) :) :)
Re: Sorting for DataReport?
Hi....
I did a couple of report already. But its all standard report whereby I fix the field in the report. eg. index, age and height.