Creating a very specific Form

[Arlmachado]

I have a very complicated basic data tables from which my final goal is to have the sum of Hectares, but with specific criteria involved.

From a more general table I have to create Queries or Tables, getting the Bindungen and BC_1 through BC_6 related to specific codes or combinations (example presented is 811 Codes in the database attached). That I know I have to achieve through Queries.

However I want to after these, be able to get the sum of the ha_fest_netto (Hectares). However I need to also be able to select if I want just the sum, or if I want the sum that is just from BLN_BBG= BBG or BLN or both; or if I want to get just 811; or 811 with 33; 811 with SDGL; or 811 with both.

Can I achieve this with a form? And can the data I get from the form be then append to a table?

I would really appreciate any advice or help you can give me

 

[MarkK]

Hi, I can't make any sense of your post or your database. One observation I have is that I would expect your fields BC_1 through BC_6 to be stored in a related table so that you can store the values vertically. When you add related data you should add rows, not fields.
hth