Spreadsheet Control in a form

[isethjmave]

Hi,

I want to have a spreadsheet type control in a form to be use for data entry and also to perform calculation. Is there a way to do that and save the data afterwards?

Thanks.

 

[Trevor G]

If you have data in your tables then you can use queries and calculate in the queries, the data you modify is saved in the tables and the calculations you create in the queries will be maintained. You can use forms that look like datasheets if that is your preference.

 

[isethjmave]

Hi Trevor G,

The problem is that i dont know what will the calculations the user will be performing. It would be easier (i think) if there would be a spreadhseet control in a form.