Ok, here is my situation. its seems complicated and long, but it isnt, its 

just long...and its a newbie question.



SITUATION:

I am using Access 200. I have 6 linked tables to describe various 

information about websites, which combained has over 255 fields. Each 

table hold speicic information about the website: tblRegion, tblUsers, 

etcetera. 



Using a QueryForm, the user is able to query all the tables to find a 

website which meets the user-specified criteria. The user needs to be able 

to run a report on the web-sites that meet that criteria.



To set the report, I set the recordsource to:

"SELECT Main.*, ContactInfo.*, FocusAC.*, FocusDH.*, FocusIL.*, FocusSZ.* 

FROM ((((Main LEFT JOIN ContactInfo ON [Main].[ID]=[ContactInfo].

[ContactInfoID]) LEFT JOIN FocusDH ON [Main].[ID]=[FocusDH].[FocusDHID]) 

LEFT JOIN FocusIL ON [Main].[ID]=[FocusIL].[FocusILID]) LEFT JOIN FocusAC 

ON [Main].[ID]=[FocusAC].[FocusACID]) LEFT JOIN FocusSZ ON Main.ID = 

FocusSZ.FocusSZID"



And to launch the report from the QueryForm, I use the following:

Dim stDocName As String

stDocName = "QueryReport"

DoCmd.OpenReport stDocName, acPreview, , SQLQuery



The SQLQuery is simply a copy of the query the User ran in the QueryForm.



Unfortunatly, none of this works because the Report cannot handle more 

then 255 fields.



QUESTION:

So, how can I run a Report based on a query of 6 tables with 255 fields, 

when the report cannot handle more than 255 fields!



I am sure there is a simple way to do this, but I am clueless.



Thanks in Advance,



Daniel

Sorry, I figured this out on my own.



It was very, very, very easy to fix.



Sorry

what did u do?