Taking our 0.00 rows

[madvalpreston]

Hi

I have a form that uses 10 fileds for entry.

The fields are

Building descritption and building price.

Not all 10 will be filled in, so in mt report I only want to show the fields that have prices in and I want them all together.

Could someone advise how I acheive this, the building needs to be matched against its price.

The I need to total all prices (which from a previous post I think I have the answer using NZ).

I also have another field which is called report price which must always go at the bottom of the list just before total.

Any ideas please

Thanks

 

[MajP]

Normalize your table to something like

tblPrices
buildingID (foreign key to the building table)
priceName (Name of the price)
currPrice (currency field for the price)

 

[madvalpreston]

Hi Majp

I have done as below which I think is similar to what you suggest, I now need help adding the fields up on the form and in a report, could oyu advise......

I have a quote form and a sub form for quote lines within the quote form.

On the sub form I have 4 main fields

ID
Building description
Price
Report price

The quote may have many lines of bulding prices, so I have used an Add button for this.

On the final line I also put in the report price.

I now need a Total price field adding in somehow, but cant figure out how to add it in.

The prices to add have the quote id next to them, so I need a total of all prices and report price where it is equal to the quotenumber it is attached to (hope that makes sense)


Could someone point me in the right direction

Thanks