Query that lets the user select the field to be queried

[jhulbert]

I have a DB that contains name, dept and 20 date fields. These fields are test certifications. The user wants to query the DB by selecting the certification field and a date range.

In SQL sort of like this

SELECT [forms]![cert]![type]
FROM [Training Table]

How on earth can I pass the value of a combo or list box that selects the field to be queried?

Thanks in advance

 

[tlbroadbent]

Dynamically create the SQL statement in a string variable.

dim sql string

sql="select " & [forms]![cert]![type] & " As CertVal From TrainingTable"

The use the variable "sql" to query the database and populate the text box. Terry

http://members.home.net/tlbroadbent/index.htm

 

[jhulbert]

WOW! Thanks for the quick reply.

I'm not much of a programmer. What do I do with this?

I'm pretty good at reverse engineering though. Any examples I could follow?

Thanks in advance

Jeff