Prev: Sub Forms
Next: How to make staff sales report and stock report
From: Rui Maciel on 19 May 2010 12:32
I have an Excel spreadsheet which consists of two tables, one with a
list of tensions measured in specific nodes and another with the list
of nodes and their coordinates. Is it possible to import that
spreadsheet into Access and, with that data, perform some simple
number crunching such as adding both tensions and distances?


Thanks in advance,
Rui Maciel
From: Douglas J. Steele on 19 May 2010 13:26
Yes, it should be possible. You can do simple arithmetic in queries.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Rui Maciel" <rui.maciel(a)gmail.com> wrote in message
news:e01315e2-7864-48db-847e-b5889f6a75be(a)y12g2000vbg.googlegroups.com...
>I have an Excel spreadsheet which consists of two tables, one with a
> list of tensions measured in specific nodes and another with the list
> of nodes and their coordinates. Is it possible to import that
> spreadsheet into Access and, with that data, perform some simple
> number crunching such as adding both tensions and distances?
>
>
> Thanks in advance,
> Rui Maciel


From: Rui Maciel on 19 May 2010 14:40
On May 19, 6:26 pm, "Douglas J. Steele"
<NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote:
> Yes, it should be possible. You can do simple arithmetic in queries.

Nice. I've just found out about queries and it appears that at the
very least it can do some preprocessing work. The learning curve
appears to be a bit steep, though, as you can only do so much with a
mouse.


Thanks for the help,
Rui Maciel
 | 
Pages: 1
Prev: Sub Forms
Next: How to make staff sales report and stock report