B
babygrand
I'm strong in Excel & Word, but a newbie in Access. I think Access might be
able to do this easily, but need advice. I \Our company currently prepares
letters of quotation for machinery we build. We cnfigure these machines in
a variety of ways, different horsepower nototr, different size gear
reducers, rotor blades, floats, etc. All of this I can build into a
fdatabase, and then do a form to pick the different elements of
condfiguration that will structure the quotatio. My question is this:
Can I format a report that will present this information pretty much in a
"letter" type format, with textual information interspersed with fields of
descriptive data? I would want it to look a lot like our existing letter of
quotation, but to be able to pick and choose all the elements that affect
the price of the quote?
For example, will Access take "20 HP" and "3 phase"and "307" and 'AGMA Type
III' from a form, and output it to look like:
20 HP, 3 phase Electric Motor couplesd with a Falk 307 gear reducer, rated
at AGMA III... (and so on)
Don't need someone to explain to me HOW to do it, just can it be done with
Access ??? Is there a particular book that goes in depth on reports, and
how to structure them to look like a Word document (or import the data into
a Word doc??
TIA
babygrand
able to do this easily, but need advice. I \Our company currently prepares
letters of quotation for machinery we build. We cnfigure these machines in
a variety of ways, different horsepower nototr, different size gear
reducers, rotor blades, floats, etc. All of this I can build into a
fdatabase, and then do a form to pick the different elements of
condfiguration that will structure the quotatio. My question is this:
Can I format a report that will present this information pretty much in a
"letter" type format, with textual information interspersed with fields of
descriptive data? I would want it to look a lot like our existing letter of
quotation, but to be able to pick and choose all the elements that affect
the price of the quote?
For example, will Access take "20 HP" and "3 phase"and "307" and 'AGMA Type
III' from a form, and output it to look like:
20 HP, 3 phase Electric Motor couplesd with a Falk 307 gear reducer, rated
at AGMA III... (and so on)
Don't need someone to explain to me HOW to do it, just can it be done with
Access ??? Is there a particular book that goes in depth on reports, and
how to structure them to look like a Word document (or import the data into
a Word doc??
TIA
babygrand