|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
 Posted: 03/26/03 - 20:29 Post subject: Re: One Day Asylum: Microsoft Office Questions
| sidewinder wrote: | How do I create a subform in Acces to enter a quantity then multiplty that times the list price and the customer's discount level in creating a quoting routine? Description & list data to come from products table.
Thanks |
You want a subform and not a separate price quote form?
|
|
|
|
|
Sandy Cheeks
Member
|
|
|
Joined: 14 May 2002
Posts: 4605
Location: in the city that never sleeps
|
| Back to top
|
|
Posted: 03/26/03 - 21:48 Post subject:
What is wrong with Cappy's spreadsheets? 
Every time he makes one I break it. But all I am doing is typing a number in! All of a sudden it says True or False or some other gobbledygook.
|
|
|
|
|
flarunner
Member
|
|
|
Joined: 30 May 2002
Posts: 2230
Location: FLA
|
| Back to top
|
|
Posted: 03/26/03 - 22:06 Post subject:
I have a bunch of questions regarding running macro's in Excel. And there are only 3 more hours of today left. Maybe you could extend your deadline?
If so, I'll ask here. If not, would it be OK to PM you and badger you?
|
|
|
|
|
sidewinder
Member
|
|
|
Joined: 28 Aug 2002
Posts: 309
Location: Peoria, AZ
|
| Back to top
|
|
Posted: 03/27/03 - 09:44 Post subject: Re: One Day Asylum: Microsoft Office Questions
| elkid wrote: | | sidewinder wrote: | How do I create a subform in Acces to enter a quantity then multiplty that times the list price and the customer's discount level in creating a quoting routine? Description & list data to come from products table.
Thanks |
You want a subform and not a separate price quote form? |
At this point anything I can get to work. I wrote an Excel ss to do th quotes but Access is sooo muck better, cleaner, more powerful.
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 03/27/03 - 10:22 Post subject:
| flarunner wrote: | I have a bunch of questions regarding running macro's in Excel. And there are only 3 more hours of today left. Maybe you could extend your deadline?
If so, I'll ask here. If not, would it be OK to PM you and badger you? |
PM me and I'll try to answer them. If they're basic, I can. If they rely on fixing/analyzing existing macros, I may not because this relies heavily on knowledge of Visual Basic I have long forgotten.
|
|
|
|
|
Sahara
Member
|
|
|
Joined: 17 May 2002
Posts: 3345
|
| Back to top
|
|
Posted: 03/27/03 - 10:29 Post subject:
Is there a way to have numbers in a Word document be added together?
I have a Word document set up to serve as a form (not sure of terminology here) to which fields from an Excel file get fed into it via a merge. Essentially I use it for proposals, quotes, etc. Sometimes there are mulitple fields from the spreadsheet that need to remain separate on the spreadsheet but combine for totals on the proposal Word file. Right now I manually calculate and type them in.
Hey... one day = 24 hours right?? Am I too late?
|
|
|
|
|
Cappy
Excelent
|
|
|
Joined: 16 May 2002
Posts: 27368
Location: Spreadsheetylvania
|
| Back to top
|
|
Posted: 03/27/03 - 10:31 Post subject:
| Sandy Cheeks wrote: | What is wrong with Cappy's spreadsheets?
Every time he makes one I break it. But all I am doing is typing a number in! All of a sudden it says True or False or some other gobbledygook. |
Obviously a problem with the end user. The other Captains were able to complete there's with no problemos
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 03/27/03 - 10:46 Post subject:
| Sahara wrote: | Is there a way to have numbers in a Word document be added together?
I have a Word document set up to serve as a form (not sure of terminology here) to which fields from an Excel file get fed into it via a merge. Essentially I use it for proposals, quotes, etc. Sometimes there are mulitple fields from the spreadsheet that need to remain separate on the spreadsheet but combine for totals on the proposal Word file. Right now I manually calculate and type them in.
Hey... one day = 24 hours right?? Am I too late? |
Why yes, there are several ways. The best way would be to put all the data in tables (which I assume is the format anyway, since you're importing it from Excel). Click in the table cell where you want the formula to appear (right below the numbers to sum), then select Table, Formula from the menu bar. Use the Paste Function box to find the formula you want, or type it in freehand in the top box and click OK. The formula you want will read =SUM(ABOVE), which will calculate all the adjacent numbers above it.
Feel free to add spaces in between each of the separate areas to create subtotals by category.
Now, to add nonadjacent items or total the subtotals created with the formula above, you need to make the items/subtotals bookmarks. Simply highlight the item/subtotal and select Insert, Bookmark from the menu bar. Give it a name (no spaces, please) and click OK. Repeat as necessary. Now click in the cell where you want the (grand) total to appear and select Table, Formula again. Use the Paste Bookmark section to get them in there, and use your normal mathematical signs.
Example: =total_1+total_2+total_3 would total 3 separate subtotals into one grand total.
Note that you can format the numbers any way you want (number, currency, etc.) and use other functions than SUM, like AVERAGE, COUNT, IF, etc.
And yes, one day = 24 hours. If you have more, keep 'em comin'. I have a light workload today. 
|
|
|
|
