using parameters

[c8tz]

I have a form which the user selects the BlockNo.

The other information that is entered in the form is :

1) NoOfRecordedTrees - RT
2)NoOfSurroundingTrees - ST

When the BlockNo is entered, a query runs which picks up fertiliser
rates for this Block for all sectors within that block.
With RT and ST - it should do a calculation such that it uses Rate/
sector * (RT+ST) to find how much fertiliser is needed for each sector
in each block.

I would like to add a column to the existing query showing
FertiliserAmt using these parameters. How do I specify them within the
query.

Thanks for your great assistance.

 

[Klatuu]

Create a calculated field in your query. If you are using the query builder,
you would enter this where you would put a field name.

FertiliserAmt: [Rate]/[ sector] *
([Forms]![MyFormName]![RT]+[Forms]![MyFormName]![ST])

If you are hand writing the SQL:
[Rate]/[ sector] * ([Forms]![MyFormName]![RT]+[Forms]![MyFormName]![ST]) As
FertiliserAmt

 

[c8tz]

Create a calculated field in your query. If you are using the query builder,
you would enter this where you would put a field name.

FertiliserAmt: [Rate]/[ sector] *
([Forms]![MyFormName]![RT]+[Forms]![MyFormName]![ST])

If you are hand writing the SQL:
[Rate]/[ sector] * ([Forms]![MyFormName]![RT]+[Forms]![MyFormName]![ST]) As
FertiliserAmt

--
Dave Hargis, Microsoft Access MVP

I have a form which the user selects the BlockNo.

The other information that is entered in the form is :

1) NoOfRecordedTrees - RT
2)NoOfSurroundingTrees - ST

When the BlockNo is entered, a query runs which picks up fertiliser
rates for this Block for all sectors within that block.
With RT and ST - it should do a calculation such that it uses Rate/
sector * (RT+ST) to find how much fertiliser is needed for each sector
in each block.

I would like to add a column to the existing query showing
FertiliserAmt using these parameters. How do I specify them within the
query.

Thanks for your great assistance.- Hide quoted text -

- Show quoted text -

Thanks heaps for your assistance . It actually was concatenating the
two numbers RT+ST . After changing the text field to number - it
worked fine.

Thanks again.