Creating math equations

[Mr. Hero]

Is there a way to create certain math equations from Excel into Acces VBA??? If so, is there any links with examples...

Any assitance with this is greatly appreciate.

 

[Mr. Hero]

Here is an example:

=IF(COUNTIF(Holis,BB27)=1,"H",IF((DSUM(AllData,Data!$F$1,Matrix!B711:D712))=0," ",DSUM(AllData,Data!$F$1,Matrix!B711:D712)))

 

[gemma-the-husky]

you need to try and forget excel usage.

get to love access queries.

eg in the above example you are summing B711712 - therefore 3 columns of data. So thinking about this operation in terms of access, why would you want to sum data from different fields. What dataa is stored in columns D,E and F. And why rows 711 and 712. What is significant about these.

This most likely indicates a normalisation problem in the access model.

What you SHOULD have is a query criterion that selects certain rows from your database, which correspond to the data in the excel rows 711 and 712 - and then some appropriate function that generates the total.

Easy when you get used to the Access paradigm, instead of Excel.

 

[Mr. Hero]

Thanks, I guess I need to play around more with queries.

 

[The_Doc_Man]

Not only queries, but breaking apart spreadsheets where one sheet holds combined data for several different things. Normalization is something like that, only more involved.

 

[Mr. Hero]

Thanks Doc.