Display query conditions in a form

[ianbrown76]

How do I display the conditions I used for a query in a form?

I have a form that displays values and counts that are calculated from various financial weeks and I'd like to display the weeks [that where used in the query] in the form too.

 

[MakeItSo]

If the weeks were used in the query, they should be directly available:

Open the form in design view.
Open the field list from the tools bar (next to the Tools icon) and simply drag and drop your weeks field onto the form.

MakeITSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[ianbrown76]

The query calculates total counts and sums based on various criteria, it's not grouped by weeks or anything else.

I was hoping to display the values I used in the 'Where' statement in the form too.

The query looks for number of items sold, value of items sold where the orders sold where in certain weeks.

 

[MakeItSo]

Not directly. You have to also include them in the SELECT statement or assign your weeks - textbox an extra SQL statement (select [weeks] from...)

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos