RE: [MS_AccessPros] Does Access 2010's limits increase with SQL Server on BackEnd

Tim,

In addition to other sage advice, you stated "With 255 field limitation. I can only have 25 row of data for the 10 years period." To me either "25 row" or "10 years" should be 25 or 10 records (or maybe 250 rows).

I create lots of reports of dozens of measures for 36 factories over many months. I store all of this in a table with fields like:

FactoryID
Yr
Mth
MeasureID
MeasureValue

Then depending on how my customers want to view the data, I can use a crosstab query or similar to provide whatever format they want. I also provide the capability to push the data to Excel where they can use a pivot table.

Duane Hookom MVP
MS Access

________________________________
> From: JohnV@msn.com
>
> Tim-
>
> Surely the "cheat sheet" info breaks down into categories. Use
> subforms or subreports for the categories with the main company info on
> the outer form or report. I've built this sort of report before with
> close to 1,000 data items in the final product.
>
> John Viescas, Author
>
> <timdbui@gmail.com<mailto:timdbui@gmail.com>> wrote:
>
>
> Hi Duane,
>
>
> Thanks for your reply! My real intention was to create a form and a
> report that draw about 400 pieces of data from a query (which pulls
> data from many other queries). For now, what I see is an Access 2010
> query can only handle about 255 fields, which means my form or reports
> can only contains 255 fields or less. I am trying to find a way to put
> more data on a report so that the users can have all of the information
> they need in one spot. For example, I wanted to create a "cheat sheet"
> that contains all important financial data of a company (Income
> Statement, Balance Sheet, and Cash Flow Statement) going back 10 years.
> With 255 field limitation. I can only have 25 row of data for the 10
> years period.
>
>
> For now, as work around, created several forms or several reports with
> each has fewer fields. I just thought SQL Server would give me more
> features.
>
>
> From your email, it seems that since I use Access, it is the bottle neck.
>
>
> One last question, do you know if there is anything out there that
> could replace Access as the Front End? I like Access so much because it
> is so easy to use.
>
>
> Thanks again, Duane!
>
>
> Tim

------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/