Recent content by rockell333

+Gasman - no worries. It is just an export from Salesforce that I am using for a mailing and I want to check something.. As for what you gave me... I store everything.... I am sure it will come in handy at some point.. Thanks

Perfect +arnelgp Thank you

ok.. yea I think I get it.. I have to get ready to go in.. I will test this again when I get there

ok.. one sec here.. i think it is backwards year in review is the table everything is in account vis is what i am trying to count count vis is the field I am trying to update

Gasman trying that now so that is saying Count all in the year in review where the account vis field = account vis field.. right

So I just tried his version and that doesnt work at all. Account VIS is a field in the year in review table. It is easier for me to just do this in excel and re-import or just repull from Salesforce through the server and add it to the pull. What parameter could it have asked for, any ideas

"I post the formula" in the previous post... is what I meant to say

for what i am doing its exactly what i need.. but back to Dcount.. I posted in my previous post however it is asking for a parameter DCount("[Account VIS]","[YEAR_IN_REVIEW]")

we use a crm this data will not be changing. I actually need the one time update. If there isnt a simple way, I could just update in excel and re-import. But I was hoping there was a way.

DCount([YEAR_IN_REVIEW]![Account VIS],[YEAR_IN_REVIEW]) ???? is that correct. It is asking for a parameter value I want to update a Count field that counts the account vis in the year in review table.

I have a table that may contain 2 or more records for certain account numbers. I added a field called Account Count that I want to do an update query for populating it similarly to excel's countif. I simply want to count how many times that account number is in the table. So if for instance...