Recent content by joeatact

I noticed that you mentioned make a new table. My main table now holds all the totals for a quote. including the 15 items that were quoted. I saved the total cost for each of the items because the prices would be locked at that price. Shouldn't I use the data from the table instead of pulling it...

Forgot to attach file above..This file contains my main table with the information mentioned above

I am sorry to have to ask more dumb questions. No matter how much one reads there never seems to be enough examples. I have learned much about normalization, and I know I have a few more to work out with my db. I have not be able to figure out how to bring all the itemcosts that I have been...

------------------------------------------------------------------------------ Thank You I understand a bit better now Joe

Re: Question on improving of Adding fields together Sorry, I have a table that stores quotes. All information is derived from other tables that store the inventory. On this form is Field1 Field2 ------- -------- Item 1 $5.00 (field name is ItemCost1) Item 2 $6.00 (field name...

Question on improving of Adding fields together Is there a more effective way to add these fields together...

It is a number field in my table. It is also a field in query. Is there a workaroung? Joe

Have this one error that just started with this code : If Me.NewRecord then On Error Resume Next Me.quoteNo = Nz(DMax("

Thanks for the help. I have tried to create one table with 6 items in it one being mboard_ID, model.manufactor,cost,sell,vendor1,vendor2 I created another table with a keyid no, and a number field to hold the info from the other tables model's field. It works the number is there for the item...

Sorry for not suppling more details I have attached copy of the database. I again cannot seem to figure out how to show the actual data not the stored index number. And I am a beginner. For example Instead of motherboard type it should print ak79 not 1. Joe

I have a query based on a combobox on a form. Of course only the number is stored. I cannot for the life of me figure out how to get the data not the number to show either in the query or a report. The data is stored in a table by itself.