Create new filed based on listbox selection

[thart21]

Can I create a new field during a query named for the selections in a listbox?

I have a list of dates and the user will select two, such as 10/30/2010 and 11/04/2010. I need the query to run with two new columns called 10/30/2010 and 11/04/2010 which will be populated with quantities from another part of the query.

I am currently doing this in Excel VBA/SQL but can't seem to translate it to Access.

Thanks,

Toni

[pbaldy]

In VBA you should be able to. What have you got that isn't working?