If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Multiple Tables
On Mon, 16 Oct 2006 13:55:01 -0700, DBrown
wrote: The table Structure is as follows: JOBNO (Job #) JOBDESCRIPTION (Job description) 214 (part size - answer is #) there are 50 items for cable parts 50 for wire parts 50 for signal equipment 50 for misc 50 for conduit parts 50 for hardware parts the fields are numeric mostly but some are alph numeric or dates And it's IMPOSSIBLE to use a very simple continuous subform with two tables? Jobs JobNo Primary Key JobDescription PartSize JobParts PartID Autonumber Primary Key JobNo link to Jobs PartType wire, signal, misc, hardware whatever fields are necessary to describe ONE SINGLE part The problem started because I added about 20 fields to each category. Before it worked fine. Exactly. You ran into the inflexible 255 field limit. You CANNOT get around this limit with one table, or with one query based on multiple tables. This is the actual syntax that I copied from and existing querrie that works fine ... Between ([Forms]![frmReportsMenu]![txtRptBeginDate]) And ([Forms]![frmReportsMenu]![txtRptEndDate]) but get the error message above. Try removing the parentheses, though I don't see that as being a real problem. Perhaps the error is elsewhere in the query - could you open the query in SQL view and post it here? John W. Vinson[MVP] |
|
Thread Tools | |
Display Modes | |
|
|