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]