Search results for query: *

Okay :) Reading the 3nf paper now Iendyar

Yes, I can see the values in the table. I am going to restructure the tables as you have recommended. I have tried recreating the mail merge process, but not using a query. It will not show me the properties of the field in Word. Iendyar

Oh, and those are fields in the table. Iendyar

Okay. Thank you so much for your help and your valuable time. Iendyar

Okay, sorry the server was down. The structure is as follows: ID which is autonum ContractNum number which is a number assigned by the company. Date but you told me I don't need that Bank Text FirstName Text LastName Text StreetAdd Text City Text State Text Zip Number HomePhone Number...

These fields are also currency. I don't see anyway to set the field type to calculated. Iendyar

Nope, that calculation is in the properties (control source)in the form. Yes, those are the same field. Iendyar

The calculations are in the control source on the Text box in the form. Is that the wrong way to do it? Iendyar

I just created a query with the data that I want to use. Here is the SQL: SELECT [ContractNum], [Date], [ReferalName], [Bank], [FirstName], [LastName], [StreetAdd], [City], [State], [Zip], [HomePhone], [Fax], [Other Phone], [LotNum], [BlockNum], [SecNum], [SubDivision], [HomePrice], [LotPrice]...

No, the document isn't called out from access yet. I was designing the template first, then I was going to try to call the template and fill in the fields using the current record. I just looked and there is not a query for the mail merge listed in my queries. Thanks, Iendyar

Not really sure how to use SQL. There is VB on these machines, but really haven't used too much of that either. I am an Access newbie :)

Here are the calculations for those fields in the control source block TotalPrice=[HomePrice]+[LotPrice]+[SitePrep]+[Contractextras]+[Contractextras1]+[Contractextras2]+[Contractextras3] CashReq=[TotalPrice]-[ProposedMtg] FivePer=[TotalPrice]*0.05...

I used the mail merge in word to populate the fields, I didn't write any code to do it. HTH, Iendyar

Thank you all so much. Your help has been invaluable! Iendyar

I have created an access database that computes all the values for a contract to purchase a new home. There are 3 fields which add or subtract currency amounts to compute total price, 5% of total price for downpayment and one that computes the difference between purchase amount and mortgage...

Thank you all for your help.

Hi all. I have been trying to figure out how to put a command button that will open an excel file on a form in access. I have had no luck. Any help would be greatly appreciated. Thanks in advance