Software

Ask something
Question Locked

ms Access

0 helpful
2 replies

by sezua2000

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

in excel, when you want to sum of more than one cell, you just take names of those cell with = sign at the begin you add them e.g A1= B1 + C1 + D1 ... then you get you sum. this can be done for columns or rows.

How are we doing those calculation on ms access, all kind of calculation?
and where are we plug then (expression)?

I have an excell file which was doing those calculations when you insert few figure where they were required.
I want to turn them into database but the calculations have to be as they were.

How can i do that?
what change is only file i.e excel to access but everything else remain the same including calculations!

Thanks.

2 replies

by tony hopkinson

or with SQL

Select A1 = B1 + C1 + D1 From Rows

given there is a rows table and it has these columns in it.

But in short if you have designed it for a spreadsheet application it is unlikely to fit in a database . Eeven if you mnaged to somehow crm it in there, it would be awful.

Spreadsheets and databases are two completely different animals.

The only way I can see you proceding is to keep the data in access and then link to it in a worksheet and do the calcs there. You may have to rearrange everything to get that working anyway.

This discussion is closed to new replies.