Query results of a form

[tangoman66]

Is it possible to query the results of a form? I personally don't think it is but I need to do it. Ive tried entering the formula from a calculation I want to query but it just makes access crash (Its one big formula!!)

Cheers

 

[dcx693]

Not sure exactly what you mean by "query the results of a form". Can you give a more concrete example?

 

[tangoman66]

I have a form which has calculations on it. I want to query these calculations and summarise them as the answers are either 1, 2, or 3. The calculation is rather long and wont transfer into a query.

 

[dcx693]

If you want a query to reference fields in your form, you can use them as query criteria. I'm not sure it's what you're looking for, but aake a look at this article and see if it sounds right: Customizing Access Parameter Queries

 

[a.sinatra]

Something is probably wrong with your sql statement if it crashes, and to display the results; you would want to set up a listbox that is linked to that query.

But post your sql, and we'll take a look at it.
________
BUY VAPIR OXYGEN