Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Access Code Help
I created a simple database that will be used to track company purchases. I
created three tables (main, list of departments, list of vendors). I created a query that is based on the main table. From there, I created a form, which is based on my query, that uses info from the dept and vendor table and records everything in the main table. Now, The first field in my Form is PO#. This is a "text" field and the default value is INDS. I have another field called ID, which is not visible on the form. This is an Auto number field. I want to combine the PO field with the ID field so the PO# field reads INDS1, next record will be INDS2 and so forth. Below is the code. What is the modified code that I can use to make this work? Thank you. SELECT [Purchase Order].[PO#], [Purchase Order].ID, [Purchase Order].Department, [Purchase Order].Vendor, [Purchase Order].Description, [Purchase Order].Quantity, [Purchase Order].Cost, [Purchase Order].Shipping, [Purchase Order].Tax, [Purchase Order].Cost*[Quantity]+[Tax]+[Shipping] AS [Total Cost] FROM [Purchase Order]; |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Access Code Help
Hi Russ
Russ wrote: I created a simple database that will be used to track company purchases. [..] SELECT [Purchase Order].[PO#], [Purchase Order].ID, [Purchase Order].Department, [Purchase Order].Vendor, [Purchase Order].Description, [Purchase Order].Quantity, [Purchase Order].Cost, [Purchase Order].Shipping, [Purchase Order].Tax, [Purchase Order].Cost*[Quantity]+[Tax]+[Shipping] AS [Total Cost] FROM [Purchase Order]; A query in one of the access-related newsgroups might result in better results ... Greetinx Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Access Code Help
Hi Russ,
I think you selected the wrong group to which to post this... You're asking in WORD.DocManagement - so your chances of getting a "useful" response aren't too high :-) An Access group would be better. Right off-hand, I'd say you'd need something like: SELECT [Purchase Order].[PO#]&[Purchase Order].ID AS PO_FullName, [Purchase Order].ID, [Purchase Order].Department, [Purchase Order].Vendor, [Purchase Order].Description, [Purchase Order].Quantity, [Purchase Order].Cost, [Purchase Order].Shipping, [Purchase Order].Tax, [Purchase Order].Cost*[Quantity]+[Tax]+[Shipping] AS [Total Cost] FROM [Purchase Order]; I created a simple database that will be used to track company purchases. I created three tables (main, list of departments, list of vendors). I created a query that is based on the main table. From there, I created a form, which is based on my query, that uses info from the dept and vendor table and records everything in the main table. Now, The first field in my Form is PO#. This is a "text" field and the default value is INDS. I have another field called ID, which is not visible on the form. This is an Auto number field. I want to combine the PO field with the ID field so the PO# field reads INDS1, next record will be INDS2 and so forth. Below is the code. What is the modified code that I can use to make this work? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Access Code Help
Thank you. I will post in proper group. Thanks again.
"Cindy M -WordMVP-" wrote in message news:VA.0000c14f.00c0f5f3@speedy... Hi Russ, I think you selected the wrong group to which to post this... You're asking in WORD.DocManagement - so your chances of getting a "useful" response aren't too high :-) An Access group would be better. Right off-hand, I'd say you'd need something like: SELECT [Purchase Order].[PO#]&[Purchase Order].ID AS PO_FullName, [Purchase Order].ID, [Purchase Order].Department, [Purchase Order].Vendor, [Purchase Order].Description, [Purchase Order].Quantity, [Purchase Order].Cost, [Purchase Order].Shipping, [Purchase Order].Tax, [Purchase Order].Cost*[Quantity]+[Tax]+[Shipping] AS [Total Cost] FROM [Purchase Order]; I created a simple database that will be used to track company purchases. I created three tables (main, list of departments, list of vendors). I created a query that is based on the main table. From there, I created a form, which is based on my query, that uses info from the dept and vendor table and records everything in the main table. Now, The first field in my Form is PO#. This is a "text" field and the default value is INDS. I have another field called ID, which is not visible on the form. This is an Auto number field. I want to combine the PO field with the ID field so the PO# field reads INDS1, next record will be INDS2 and so forth. Below is the code. What is the modified code that I can use to make this work? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a word merged document from Access code doesn't update | Mailmerge | |||
Why do I need a product code to access Microsoft Word? | Microsoft Word Help | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
How do I reinstall Word when I don't have a access code on the cd | Microsoft Word Help | |||
i lost the access code for my word and need to know how to get a . | Microsoft Word Help |