Recent content by Accessunknown

In your table is EastWest text or a yes/no field? It is a yes/no checkbox You previously referred to a control on your form as EastCoast - is it now EastWest? It is called EastCoast both on the form and the costs table. (sorry i made a mistake on previous post) You previously called the combo...

Thanks so much for your response. I decided to change the design of my table to what you suggested. So now, it looks like COSTS ID CostsType EastWest NewRenewExtMod CostValue 1 500 YES NEW 4100 2 500 YES Renewal 1000 3 500 NO NEW 4400 4 500 NO Renewal 900 5 600 YES NEW 3400 I left the...

Hi, I'm new to the forums. I would like your help regarding dlookup or if you could guide me in the right direction. I have a table that consist of pricing for different types of products: Table name: Costs ID TYPE EastNew EastRenew WestNew WestRenew 1 500 4100 1000 4400 900 2 501 4100...