S
Steve S
I use 6 variations of the following SQL to select values from 6 different
columns of a reference table.
SELECT nz([Forms]![Tabulate]![Score ID]) AS [Score ID], [Penalty
Names].[Penalty ID], [Penalty Names].[fldA] AS [Sort Key]
FROM [Penalty Names]
WHERE ((([Penalty Names].[fldA])=True));
One version of the query looks in "fldA" another looks in "FldB" etc...
How can I code this so that I only have one version and use the contents of
a field on a form determine if the query looks in fldA or fldB or ...
Say the Form is frm1 and the TextBox is tb2
columns of a reference table.
SELECT nz([Forms]![Tabulate]![Score ID]) AS [Score ID], [Penalty
Names].[Penalty ID], [Penalty Names].[fldA] AS [Sort Key]
FROM [Penalty Names]
WHERE ((([Penalty Names].[fldA])=True));
One version of the query looks in "fldA" another looks in "FldB" etc...
How can I code this so that I only have one version and use the contents of
a field on a form determine if the query looks in fldA or fldB or ...
Say the Form is frm1 and the TextBox is tb2