SELECT [Motors in Operation].WONUMBER, Outline.[XP#], Models.Model, [Stator
Assy].[Sta Winding Spec], Winding.W_NO, [Low hp winding test
data].Winding.W_NO, [Low voltage winding data].Winding.W_NO, [High voltage
winding data].W_NO, [High hp winding test data].Winding.W_NO
FROM ((((((Models RIGHT JOIN ([Motors in Operation] LEFT JOIN Outline ON
[Motors in Operation].OUTLINE = Outline.[Outline Number]) ON Models.Model =
Outline.Model) LEFT JOIN [Stator Assy] ON Models.[Stator Assembly] = [Stator
Assy].[Stator Wound Assy]) LEFT JOIN [Low hp winding test data] ON
Models.[Stator Assembly] = [Low hp winding test data].Winding.W_NO) LEFT JOIN
[Low voltage winding data] ON Models.[Stator Assembly] = [Low voltage winding
data].Winding.W_NO) LEFT JOIN [High hp winding test data] ON Models.[Stator
Assembly] = [High hp winding test data].Winding.W_NO) LEFT JOIN [High voltage
winding data] ON Models.[Stator Assembly] = [High voltage winding data].W_NO)
LEFT JOIN Winding ON [High voltage winding data].W_NO = Winding.W_NO
WHERE ((([Motors in Operation].WONUMBER)=[serial no]) AND (([Low hp winding
test data].Winding.W_NO) Like [motors in operation to stator assymbly]![sta
winding spec] & "*") AND (([Low voltage winding data].Winding.W_NO) Like
[motors in operation to stator assymbly]![sta winding spec] & "*") AND
(([High voltage winding data].W_NO) Like [motors in operation to stator
assymbly]![sta winding spec] & "*") AND (([High hp winding test
data].Winding.W_NO) Like [motors in operation to stator assymbly]![sta
winding spec] & "*"));
i want w_no for all 5 winding tables(winding, low voltage, high voltage, low
hp, and high hp)to be displayed. sta winding spec will match winding exactly
but in the other 4 the number will be followed by a h,l,a, or b --depending
if its high or low V or high or low hp. the problem i'm having is if there
are no mathching records in one of the tables, then no records are displayed.
i might be going about this all wrong.
also, the high/low voltages/hp are queries obtained from the original
winding table.this all came about because i want to store all windings in the
same table but i'm having a hard time retrieving different sets of test data
(ex. xxx-a and xxx-b) that would be shown on a single report.
--
John Vinson said:
hi guys. . .
i have a query that asks for a parameter. one of the fields has criteria
like
![field]&"*". it is entered in the "or". does anyone have ideas
why this doesn't work? the field that asks for a parameter also has [serial
no] in the "or" as well.
The syntax
! is invalid; you cannot refer to a table in that
way.
What's
mean in this context? Is it the name of a separate
table, not part of the query? Could you post the SQL view of the query
and indicate just what you expect it to accomplish?
John W. Vinson[MVP]
