[SOLVED] Calculate with Alias / calculated Fields

[hwoehrle]

Hi,

is there a way to use calculated fields in the same query for further calculation?

For example, i need to do some calculation on areas and process them further. My area-calculation looks like:

[Sliderule]

If I am understanding your question and what you are trying to do correctly, if it were me ( famous last words ) . . . what I would do is create a View.

A View, in a database, is 'treated' just like a table, but, it contains no data. Rather, it tells the database what data to retrieve. In this case, you can define the calculation for "Flaeche_Schicht" once, if you include the Primary Key in the View. That is, your view would have two fields ( assuming your Primary Key is made up of one field ):

1. The Primary Key Field(s)
   
2. The calculation for "Flaeche_Schicht"

Now that you have 'one' calculation for "Flaeche_Schicht", whenever you wanted the "Flaeche_Schicht" again, for example in a Query, just include your original table, AND the View, linked by the Primary Key.

Note: To create a View , after opening your database, click on Tables on the left, and, Create View...

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post title ( edit button ) if your issue has been fixed / resolved.

[hwoehrle]

Many thanks to sliderule for saving my day once again!