the data in my report and forms seem to be to large.

[eskelies]

Is there a workaround I can use to keep all the data, but enlarge the form and/or report?

I am running Access 2003

[Rabbit]

What do you mean by enlaring the form?
What do you mean by keeping the data? Are you saying the data is disappearing?

[eskelies]

When I try to build a form or a report from a query the data is to large. Can you have too many data fields, which can cause the database to become unresponsive?

[Rabbit]

When I try to build a form or a report from a query the data is to large. Can you have too many data fields, which can cause the database to become unresponsive?

Yes, that could be one reason, although the database can become unresponsive for a number of reasons such as a complex expression or a non-cartesian join. How many fields and records are we talking about?

[eskelies]

Yes, that could be one reason, although the database can become unresponsive for a number of reasons such as a complex expression or a non-cartesian join. How many fields and records are we talking about?

18 Fields. These 18 fields are summaries of about 30 other queries.

[Rabbit]

18 fields are well within the abilities of access. Your problem is most likely the 30 other queries. Each of those queries have to run everytime you run your one query. And a problem with any one of those queries can cause a hang up not to mention it takes a while to run 30 queries in the first place.

A few reasons could be:
1) A non-cartesian join
2) A complex expression
3) A loop in the queries

I don't know why you need so many queries because I don't know what you're trying to query but you're most likely not using the most efficient queries.

[eskelies]

18 fields are well within the abilities of access. Your problem is most likely the 30 other queries. Each of those queries have to run everytime you run your one query. And a problem with any one of those queries can cause a hang up not to mention it takes a while to run 30 queries in the first place.

A few reasons could be:
1) A non-cartesian join
2) A complex expression
3) A loop in the queries

I don't know why you need so many queries because I don't know what you're trying to query but you're most likely not using the most efficient queries.

I'm using basic queries. Would a make-table or some other form of queries work better?

[Rabbit]

A make-table query would take longer. It would have to create 30 tables from your queries before running your query.

As for a different type of query, I can't say because I don't know what you're trying to query.

[eskelies]

A make-table query would take longer. It would have to create 30 tables from your queries before running your query.

As for a different type of query, I can't say because I don't know what you're trying to query.

Market Valuations

Transactions...

[Rabbit]

Market Valuations

Transactions...

I would need to know more than that.
I would need to know your tables, the fields in those tables, the relationships between the tables, and what it is that you're trying to accomplish with the query.

[eskelies]

I would need to know more than that.
I would need to know your tables, the fields in those tables, the relationships between the tables, and what it is that you're trying to accomplish with the query.

Rabbit,

I will figure something out. There are really too many select quueries. PErhaps I can cross reference some of them. Thanks for your help. Sorry if my information was too vague.

My info is sensitive.

[Rabbit]

Rabbit,

I will figure something out. There are really too many select quueries. PErhaps I can cross reference some of them. Thanks for your help. Sorry if my information was too vague.

My info is sensitive.

I'm not asking for the info, just what info you're collecting.