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
