May I create quatation form for customer in Access 2003? How?

K

kripa

Dear Sir/Mam
I want to create a templete in Access as a quotation. How can I create it

Thanx in advance
 
J

John W. Vinson

Dear Sir/Mam
I want to create a templete in Access as a quotation. How can I create it

Thanx in advance

Since we have no way to know anything about your data, what you mean by a
"quotation", what you want to do with this template, or much of anything else,
it's a bit hard to answer!

More details please.

John W. Vinson [MVP]
 
K

kripa

Sir,
thanx for reply
I want to create 1 letter format in that a space to write customer name
which is from customer table (name, address); to quote price which he
enquired (i.e. in product table-> id, name, price). Letter should have sr.
number
&
insert a data in quotation detail as quotation no, date, cust nm etc
that is my query.

Thanx in advance again
 
J

John W. Vinson

Sir,
thanx for reply
I want to create 1 letter format in that a space to write customer name
which is from customer table (name, address); to quote price which he
enquired (i.e. in product table-> id, name, price). Letter should have sr.
number
&
insert a data in quotation detail as quotation no, date, cust nm etc
that is my query.

You would create an Access Report with controls pulling fields from your
tables. I have no way to know what tables you have set up, if any; what their
fieldnames are; where the quotation detail would come from, and so on; and it
would be very unreasonable for you to expect an unpaid volunteer like me to
completely construct this report for you!

You may want to review some of the pointers on how to use Access:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top