G
Guest
I am trying to edit the following query. When I open it, Access really
mangles it so that it doesn't even work. This goes to a form in the database
and there are drop down menus for choices. I'm trying to add the parameters
in those lists to run the query. The first time I ran it it asked for the
first parameter I think was curUser. Now it doesn't ask for that anymore but
it does ask for the form drop down fields.
I will try inputing a value in the select query.
The problem is I want the inner join taken out so Access won't keep
destroying the query. It puts paren's around the wrong place and seems like
it takes out a line.
I think the following line could be deleted as well as the inner join to the
qCurrentUser table:
ExportData.eehCurUser=qCurrentUser.curUser
There is a separate query called qCurrentUser.curUser with only the one
field in it.
SELECT ExportData.eehCommServed, ExportData.eehNodeNumber,
ExportData.eehSysPrin, ExportData.eehGL, ExportData.eehVirtualNode,
ExportData.eehOldNodeNum, ExportData.eehbusHPDesign,
ExportData.eehbusOpticalTX, ExportData.eehbusOpticalRx,
ExportData.eehServDeliveryType, ExportData.eehCMTS, ExportData.eehUnitID_IP,
ExportData.eehprtSlotNumber, ExportData.eehprtDSPortNum,
ExportData.eehDSFreq, ExportData.eehDownStreamMod,
ExportData.eehprtUSPortNum, IIf([eehPhysicalUSPort]<0,99,[eehPhysicalUSPort])
AS Expr1, ExportData.eehUSFreq, ExportData.eehUSCnnlW,
ExportData.eehprtUSModulation, ExportData.eehServingGroup,
ExportData.eehNCPChanges, ExportData.eehbusHPCSG, " " AS [Node Group],
ExportData.eehDownstreamPlant, ExportData.eehOM, ExportData.eehN,
ExportData.eehEMM, ExportData.eehSlMulticast, ExportData.eehprtModemCount,
ExportData.eehprteMTACount, ExportData.eehExcelExportID
FROM ExportData INNER JOIN qCurrentUser ON
ExportData.eehCurUser=qCurrentUser.CurUser
ORDER BY ExportData.eehCMTS, ExportData.eehprtSlotNumber,
ExportData.eehprtDSPortNum, ExportData.eehprtUSPortNum, Left([eehCMTS],5),
Mid([eehCMTS],9,3), Mid([eehCMTS],6,3), ExportData.eehprtSlotNumber,
ExportData.eehprtDSPortNum, ExportData.eehprtUSPortNum,
ExportData.eehNodeNumber;
Thanks,
mangles it so that it doesn't even work. This goes to a form in the database
and there are drop down menus for choices. I'm trying to add the parameters
in those lists to run the query. The first time I ran it it asked for the
first parameter I think was curUser. Now it doesn't ask for that anymore but
it does ask for the form drop down fields.
I will try inputing a value in the select query.
The problem is I want the inner join taken out so Access won't keep
destroying the query. It puts paren's around the wrong place and seems like
it takes out a line.
I think the following line could be deleted as well as the inner join to the
qCurrentUser table:
ExportData.eehCurUser=qCurrentUser.curUser
There is a separate query called qCurrentUser.curUser with only the one
field in it.
SELECT ExportData.eehCommServed, ExportData.eehNodeNumber,
ExportData.eehSysPrin, ExportData.eehGL, ExportData.eehVirtualNode,
ExportData.eehOldNodeNum, ExportData.eehbusHPDesign,
ExportData.eehbusOpticalTX, ExportData.eehbusOpticalRx,
ExportData.eehServDeliveryType, ExportData.eehCMTS, ExportData.eehUnitID_IP,
ExportData.eehprtSlotNumber, ExportData.eehprtDSPortNum,
ExportData.eehDSFreq, ExportData.eehDownStreamMod,
ExportData.eehprtUSPortNum, IIf([eehPhysicalUSPort]<0,99,[eehPhysicalUSPort])
AS Expr1, ExportData.eehUSFreq, ExportData.eehUSCnnlW,
ExportData.eehprtUSModulation, ExportData.eehServingGroup,
ExportData.eehNCPChanges, ExportData.eehbusHPCSG, " " AS [Node Group],
ExportData.eehDownstreamPlant, ExportData.eehOM, ExportData.eehN,
ExportData.eehEMM, ExportData.eehSlMulticast, ExportData.eehprtModemCount,
ExportData.eehprteMTACount, ExportData.eehExcelExportID
FROM ExportData INNER JOIN qCurrentUser ON
ExportData.eehCurUser=qCurrentUser.CurUser
ORDER BY ExportData.eehCMTS, ExportData.eehprtSlotNumber,
ExportData.eehprtDSPortNum, ExportData.eehprtUSPortNum, Left([eehCMTS],5),
Mid([eehCMTS],9,3), Mid([eehCMTS],6,3), ExportData.eehprtSlotNumber,
ExportData.eehprtDSPortNum, ExportData.eehprtUSPortNum,
ExportData.eehNodeNumber;
Thanks,