how to display large amount of data

  • Thread starter Thread starter PF
  • Start date Start date
P

PF

Hi all,

i have to display data from a table which
have four field.

Tbl
Prod
Qt
Datetype


I have to display in a form more than
120 fields order by month.
1 field on ten is a data field, the other are calculations for a particular
month

i am afraid to hit the limit of 2k for a sql string in access

is there a way or a technique to use in this case

Also is generating calculated field on a form faster
then have the fields created in a database and then display on a form?
If the field are in a database each time a select is done
the calculation dont have to be perform again. No?

regards,
Pierre
 
Calculate your values in a query, it will be much faster (under usual
circumstances). It's the query text itself that is limited to 2K, so you
should be okay. (Worst case, you'll need to create two queries and join
them.)

HTH

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress
 
Back
Top