By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,444 Members | 3,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,444 IT Pros & Developers. It's quick & easy.

too many fields in report

P: n/a
Please help me...a newbie here....

I having been working two days on a project, thought I was almost done until
I tried to create a report using a query I had succesfully made. I get an
error about too many fields.

I initially created one huge table but ran into problems after hitting 255
fields. I did some reading, created 10 tables instead and created
relationships between the tables. I was then able to use these 10 tables
and create a form (255 fields exactly) using the 10 different tables. This
works great for inputting data - I check the underlying tables and data is
going where it should :)

Next I created a query. One of the main field that will be used is named
streamName so in the criteria i entered [streamName] so that when i run the
query i am prompted to enter a streamname. This also seems to be working ok
and I am rewarded with a listing of any records that match what I enter.

I am feeling really good about things until now. I go to create a report
based on the query streamline. I am only using 2 of the 10 tables thus far
and I get the error "The wizard is unable to create your form or report
because you chose to many fields; please try again with fewer fields.

I could understand this error is i was at or above the 255 field limit..but
like I said...I am only using two tables thus far.

I need to be able to query the database by several fields...streamname just
being one of them and I need to be able to display all the info from all the
tables.

Anyone see what I am doing wrong? or maybe have some idea(s)? I hope I
don't have to start over as I do have a deadline on this.

Thanks to all/any who may respond :)

I tried to attach the mdb file here,...but it was too large...9 mb...that
may also be an indicator of something wrong? For those who would like to
see it, I ftp'd it to http://www.coastalconsulting.ca/sitecard7.mdb

Abe
Nov 12 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"shawnews" <sa***@kalendars.cawrote in news:VxN5h.294195
$1T2.46223@pd7urf2no:
http://www.coastalconsulting.ca/sitecard7.mdb
Without even looking at the database I can tell you that you have
not properly normalized your table structure. I'll post some
suggestions about how to do that after I've looked at your file.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Nov 12 '06 #2

P: n/a
"shawnews" <sa***@kalendars.cawrote in
news:VxN5h.294195$1T2.46223@pd7urf2no:
Please help me...a newbie here....

I having been working two days on a project, thought I was
almost done until I tried to create a report using a query I
had succesfully made. I get an error about too many fields.

I initially created one huge table but ran into problems after
hitting 255 fields. I did some reading, created 10 tables
instead and created relationships between the tables. I was
then able to use these 10 tables and create a form (255 fields
exactly) using the 10 different tables. This works great for
inputting data - I check the underlying tables and data is
going where it should :)

Next I created a query. One of the main field that will be
used is named streamName so in the criteria i entered
[streamName] so that when i run the query i am prompted to
enter a streamname. This also seems to be working ok and I am
rewarded with a listing of any records that match what I
enter.

I am feeling really good about things until now. I go to
create a report based on the query streamline. I am only
using 2 of the 10 tables thus far and I get the error "The
wizard is unable to create your form or report because you
chose to many fields; please try again with fewer fields.

I could understand this error is i was at or above the 255
field limit..but like I said...I am only using two tables thus
far.

I need to be able to query the database by several
fields...streamname just being one of them and I need to be
able to display all the info from all the tables.

Anyone see what I am doing wrong? or maybe have some idea(s)?
I hope I don't have to start over as I do have a deadline on
this.

Thanks to all/any who may respond :)

I tried to attach the mdb file here,...but it was too
large...9 mb...that may also be an indicator of something
wrong? For those who would like to see it, I ftp'd it to
http://www.coastalconsulting.ca/sitecard7.mdb

Abe
Just as I thought.

Any time you have a group of fields named morph1, morph2, etc,
your design is f....ed.

Take Morph for example. Your design should first include the
StreamID, and be so labeled.MorphID should be the number that
you have included as the number in each of the 11 morphNN
fields.

or Photo. You want a single column called roll, with a number in
it to represent the roll.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Nov 12 '06 #3

P: n/a
thanks Bob :)
"Bob Quintal" <rq******@sPAmpatico.cawrote in message
news:Xn**********************@66.150.105.47...
"shawnews" <sa***@kalendars.cawrote in
news:VxN5h.294195$1T2.46223@pd7urf2no:
>Please help me...a newbie here....

I having been working two days on a project, thought I was
almost done until I tried to create a report using a query I
had succesfully made. I get an error about too many fields.

I initially created one huge table but ran into problems after
hitting 255 fields. I did some reading, created 10 tables
instead and created relationships between the tables. I was
then able to use these 10 tables and create a form (255 fields
exactly) using the 10 different tables. This works great for
inputting data - I check the underlying tables and data is
going where it should :)

Next I created a query. One of the main field that will be
used is named streamName so in the criteria i entered
[streamName] so that when i run the query i am prompted to
enter a streamname. This also seems to be working ok and I am
rewarded with a listing of any records that match what I
enter.

I am feeling really good about things until now. I go to
create a report based on the query streamline. I am only
using 2 of the 10 tables thus far and I get the error "The
wizard is unable to create your form or report because you
chose to many fields; please try again with fewer fields.

I could understand this error is i was at or above the 255
field limit..but like I said...I am only using two tables thus
far.

I need to be able to query the database by several
fields...streamname just being one of them and I need to be
able to display all the info from all the tables.

Anyone see what I am doing wrong? or maybe have some idea(s)?
I hope I don't have to start over as I do have a deadline on
this.

Thanks to all/any who may respond :)

I tried to attach the mdb file here,...but it was too
large...9 mb...that may also be an indicator of something
wrong? For those who would like to see it, I ftp'd it to
http://www.coastalconsulting.ca/sitecard7.mdb

Abe
Just as I thought.

Any time you have a group of fields named morph1, morph2, etc,
your design is f....ed.

Take Morph for example. Your design should first include the
StreamID, and be so labeled.MorphID should be the number that
you have included as the number in each of the 11 morphNN
fields.

or Photo. You want a single column called roll, with a number in
it to represent the roll.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Nov 12 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.