ah...that got me started now
I just tried to create a new report
without using the wizard....just in design view. I copied the record
source from my form into my report record source and now I have a working
field list. below is my record source....huge huh?
SELECT channel.Channel1, channel.Channel2, channel.Channel3,
channel.Channel4, channel.Channel5, channel.Channel6, channel.Channel7,
channel.ChannelWidthMethod, channel.ChannelWidth1, channel.ChannelWidth2,
channel.ChannelWidth3, channel.ChannelWidth4, channel.ChannelWidth5,
channel.ChannelWidth6, channel.ChannelWidth7, channel.WettedWidthMethod,
channel.WettedWidth1, channel.WettedWidth2, channel.WettedWidth3,
channel.WettedWidth4, channel.WettedWidth5, channel.WettedWidth6,
channel.WettedWidth7, channel.ResPoolDepthMethod, channel.ResPool1,
channel.ResPool2, channel.ResPool3, channel.ResPoo4, channel.ResPool5,
channel.ResPool6, channel.ResPool7, channel.WbDP1, channel.WbDP2,
channel.WbDP3, channel.WbDpMethod, channel.ChStage,
channel.[Gradient%Method], channel.[Gradient%1], channel.[Gradient%2],
channel.[Gradient%3], channel.[Gradient%4], channel.[Gradient%5],
channel.[Gradient%6], channel.[Gradient%7], channel.[Gradient%8],
channel.NoVisCh, channel.DryInt, channel.DW, channel.Tribs, comments.C,
comments.C1, comments.C2, comments.C3, comments.C4, comments.C5,
comments.C6, comments.C7, comments.C8, comments.C9, comments.C10,
comments.C11, comments.C12, comments.C13, comments.C14, comments.C15,
comments.C16, comments.Comments, comments.Comments1, cover.Cover,
cover.Cover2, cover.Cover3, cover.Cover4, cover.Cover5, cover.Cover6,
cover.CoverTotal, cover.SWDAmount, cover.SWDLoc, cover.LWDAmount,
cover.LWDLoc, cover.BAmount, cover.BLoc, cover.UAmount, cover.ULoc,
cover.DPAmount, cover.DPLoc, cover.OVAmount, cover.OVLoc, cover.IVAmount,
cover.IVLoc, cover.Crown0, cover.Crown1, cover.Crown2, cover.Crown3,
cover.Crown4, cover.Crown5, cover.WdFnc, cover.Dist, cover.InstreamVeg,
cover.LbShp, cover.RbShp, cover.Texture, cover.Texture2, cover.RipVeg,
cover.RipVeg2, cover.Stage, cover.Stage2, features.Features1,
features.Features2, features.Features3, features.Features4,
features.[NidMap#1], features.[Nidmap#2], features.[Nidmap#3],
features.[NidMap#4], features.[NID#1], features.[NID#2], features.[NID#3],
features.[NID#4], features.Type1, features.Type2, features.Type3,
features.Type4, features.HT1, features.HT2, features.HT3, features.HT4,
features.Mthd1, features.Mthd2, features.Mthd3, features.Mthd4,
features.PhotoR1, features.PhotoR2, features.PhotoR3, features.PhotoR4,
features.PhotoF1, features.PhotoF2, features.PhotoF3, features.PhotoF4,
features.FComm1, features.FComm2, features.FComm3, features.FCimm4,
features.UTM1, features.UTM2, features.UTM3, features.UTM4,
features.UTMMeth1, features.UTMMeth2, features.UTMMeth3,
features.UTMMeth4, habitat.HQ, habitat.FSZ, morph.Morph1, morph.Morph2,
morph.Morph3, morph.Morph4, morph.Morph5, morph.Morph6, morph.Morph7,
morph.Morph8, morph.Morph9, morph.Morph10, morph.Morph11, morph.FldSns,
morph.BedmaterialDom, morph.BedmaterialSub, morph.D95, morph.D,
morph.Morph, morph.DistIndic, morph.Pattern, morph.Islands, morph.Bars,
morph.Coupling, morph.Confinement, photoDoc.[Roll#1], photoDoc.[Roll#2],
photoDoc.[Roll#3], photoDoc.[Roll#4], photoDoc.[Roll#5], photoDoc.Num1,
photoDoc.Num2, photoDoc.Num3, photoDoc.Num4, photoDoc.Num5,
photoDoc.FOCLG1, photoDoc.FOCLG2, photoDoc.FOCLG3, photoDoc.FOCLG4,
photoDoc.FOCLG5, photoDoc.Dir1, photoDoc.Dir2, photoDoc.Dir3,
photoDoc.Dir4, photoDoc.Dir5, photoDoc.PhotoComments1,
photoDoc.PhotoComments2, photoDoc.PhotoComments3, photoDoc.PhotoComments4,
photoDoc.PhotoComments5, stream.StreamName, stream.local,
stream.WatershedCode, stream.ILPMapNumber, stream.ILPNumber,
stream.NIDMapNumber, stream.NIDNumber, stream.ReachNumber,
stream.SiteNumber, stream.FieldUTM1, stream.FieldUTM2, stream.FieldUTM3,
stream.FieldUTMMethod, stream.SiteLG, stream.SiteLGMethod, stream.Access,
stream.Access2, stream.Date, stream.Time, stream.Agency, stream.Crew1,
stream.Crew2, stream.Crew3, stream.FishForm, water.Water, water.Water1,
water.Water2, water.EMS, water.EMSMeth, water.Temp, water.TempMeth,
water.pH, water.pHMeth, water.[Reg#], water.[Reg#Meth], water.Cond,
water.CondMeth, water.Turb, water.TurbMeth, wildlife.group1,
wildlife.group2, wildlife.group3, wildlife.group4, wildlife.wildObserv1,
wildlife.wildObserv2, wildlife.wildObserv3, wildlife.wildObserv4,
morph.DistIndic2, morph.DistIndic3, morph.DistIndic4, morph.Bars2,
morph.Bars3, cover.Texture2A, cover.Texture2B, stream.MesoHabitat FROM
((((((((stream INNER JOIN comments ON stream.StreamID=comments.commentsID)
INNER JOIN cover ON stream.StreamID=cover.coverID) INNER JOIN features ON
stream.StreamID=features.featuresID) INNER JOIN habitat ON
stream.StreamID=habitat.habitatQualityID) INNER JOIN morph ON
stream.StreamID=morph.morphID) INNER JOIN photoDoc ON
stream.StreamID=photoDoc.photoDocID) INNER JOIN water ON
stream.StreamID=water.waterID) INNER JOIN wildlife ON
stream.StreamID=wildlife.wildlifeID) INNER JOIN channel ON
stream.StreamID=channel.ChannelID;
Brendan Reynolds said:
What's in the Row Source property of the report?
--
Brendan Reynolds
Access MVP
shawnews said:
I actually tried that...but when i did, the "field list" was greyed out
??unavailable...but in forms..still available...
There is a limit on the number of fields the wizard can handle. I'm not
sure what the exact number is, but it is a lot lower than 255. If you
have more fields than the wizard can handle, you can still create the
report, you just can't use the wizard. You'll have to create the report
manually.
--
Brendan Reynolds
Access MVP
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
