Recent content by djsmith2005

Thank you for the explanation as well. You have helped me in getting my reports completed this morning. Have a terrific day.

Thank you that worked perfect. Do I understand that the Session ID = Session Id AND Speaker (Concatenation) Is less than Speaker , add 1 to the SpeakerCount? the trick as you stated before is that text, dates and numbers are handled differently. Thank you again for your assistance.

I tried to add the ' around speaker but that did not change anything. SpeakerCount: DCount("*","Web/PrintReport_qry","[Session ID]='" & [Session ID] & "' And '[speaker]'<" & '[Speaker]')+1 I do have an option to add in the speaker's contact number, but when I tried using the Contact number it...

session id is a number Speaker is a string Yes, that is what I was shown in the previous instance of needing to count the number of records associated with one criteria. What it did was add a number to the DCount field for each record associated with an organization, I was then able to...

Lame excuse, but this is what I have learned so far.

I am trying to use DCount to count the number of records (speakers) for each session. Not being very savvy with DCount, I copied code that I had working for another instance of needing to count the number of records. My query has three fields Query used: Web/PrintReport_qry Session Id - number...

OMG I thought when I had tried that before, I had gotten a circular reference message. Thank you, Thank you Thank you.

I have a query with a Start Time where the need to return a set integer in another field in my query. I am attempting to get this to work in my StripSecondsQry. I am not getting any error messages and I am not getting any output, When I view this in the Locals window I can see that it should...

That worked perfectly, It is amazing how you could solve my issue in a matter of minutes, when it has taken me days to re-enforce how little I know and understand about ACCESS. ;)

Thank you very much billmeye! I have stripped a lot of the data out, but left a good sample of records. Please let me know if you need anything else.

Ultimately I need to put each board member's name on the same line as the ORG_NAME so that I do create a mail merge that will include all of the board members' names for each organization. My thought is that if I can assign a number to each board member, I can then set up a query that will put...

I created a query that counts the number of board members for each organization, the coungofOrg_NAME comes from that query. I think that this would be the counter for each Org_NAME. Org_NAME1 count = 4 the board members (PERS_LAST_NAME) would be numbered 1-4 Org_NAME2 count = 6 the board...

Thank you for getting back to me:) If I am understanding this correctly, I am trying to reference a function to show a value that is not in the underlying table. This is what I had in my query for the new field, BdMbrCount: BdMbrCount([ORG_NAME],[PERS_NAME_LAST]) but that was before I was able...

Using Access 2010: I have a query with four fields: ORG_NAME, PERS_NAME_LAST, CountOfORG_NAME, and BdMbrCount. There are a couple hundred companies in the database with 1-7 people associated with each company. I need to number each person so that they have a number, 1-7 in the MemberCount...

I have been working with Access since 2.0. I have learned enough to get me into trouble and I spend a lot of time trying to find the answer to VBA programming Access to make my co-worker's lives easier. Not to mention the rush when I finally get something to work.:)