Dcount

[Waldin]

please advise me how to go about using Dcount, the web is very confusing ive spent 1full day trying to make it work but to no success, and time is against me

Combo553 is the column that should display the Dcount Values.
RegistrationNumber would display the main quotation.
the form name is Quotation
i would like the dcount to display how many additional quotes there is for each quotation

if this is confusing i can always elaborate to bring more clarity.

 

[pr2-eugin]

Okay Dcount is a Domain Function, that can be used to lookup on tables/queries.. So I hope that you have a table called quoteTbl and the you want count of total quotations for that number.. DCount works as follows..

DCount ( anyField , tableName , [Optional_conditionalCountCriteria] )

So based on that.. Try this

DCount("*","[COLOR=Blue][B]quoteTbl[/B][COLOR=Black]", "[COLOR=Blue][B]regNo_filedName[/B][/COLOR]=" & Forms![/COLOR][/COLOR]Quotation!RegistrationNumbe)

Remeber blue bits needs to change, according to your need.

 

[Waldin]

hi thanks for your reply

now im 10 steps ahead, however i dont have a table named quoteTbl, must i create 1?

 

[Waldin]

...okay no need to reply i see blue bits need to change to my need thanks a million.

 

[Waldin]

where do i apply the code?

 

[pr2-eugin]

I would think it should go in an Unbound Text box on the Form.. But what is your requirement?

 

[Waldin]

my requirements is that Additional Quotes return the amount of records with the same Quotation ID number from the table Quotation

 

[pr2-eugin]

Create an Unbound Text box on the Form and let its Default Value be the DCount expression..

 

[Waldin]

thanks, hopefully you saved me again.

 

[Waldin]

what would my control source be, at the moment the field displays this #NAME?