Recent content by SimonD

I'm reading up and learning about grouping by clause, it seems exactly what I need, thank you for pointing me in the right direction.

I do not know which formula to use to have the query just sum up the intCourtdays for those that have the same CaseID, and not the others intCourtdays of other CaseID. example of data: Case ID (from [tblCase]) / intCourtDays (from [tblHearing]) 1 / 0.5 2 / 0 3 / 0 4 / 1 5 / 4 5 / 2 6 / 4 I...

I'm going to try that! thank you

Hi guys, I'm building a report based on a query, so far I have everything I need except for one field. (here is a summary of current state) Here is the query so far (information from 2 tables) SELECT [strLastName] & "." & Right([ServiceNumberID],3) AS [Name of case], tblmember.strRank...

Your idea works brilliantly!!! either with records already there or to associate new charges to member(s)! Thank you so much! Now that I understand this, I'm trying to make this more user friendly. in most cases (pun intended) there is only one member per case (joint trial are fairly rare, 1...

I found an article that shows how to do this, I'm trying to duplicate the results!

OMG if I had created a button through the wizard, it shows there! I usually create button from scratch

I know this is a basic question but: How do you get the button to open on the active record? (I'm searching on how to do this, now) the Junction subform will show (if any) the records of the active charge to a member and have the option to add more association with other members. Now I have...

Now I will try to do this! thanks for the guidance so far!!!

"all records in the tblJunction related to that charge" is empty when the user is filling this for the first time, and all that tbljunction has is a bunch a number that the user will not understand (I do since they represent the chargeID and the memberID, but the user never sees those.

I cannot picture how to do this. Would you create a query based on the tblmembers and also have tblJunction ChargeID and MemberID? then create a form based on that query?

i think i'll put the sentence in the tblMember it makes more sense to me. Since there is one sentence per member (regardless of how many charges that member is accused of) by putting it under charge, I will have a record for a sentence attached to each charge, and I don't want that.

what do you think of post #13?

I put ysnChargesWithdrawn (meaning it is a yes/no field if all charges were withdrawn for this case) in the tblCase because I also wanted the datWithdrawn (date all the charges were withdrawn) besides datTerminated (which is the date the case is terminated when finding/sentence are given by the...

Now, how to relate the tblSentence to this. A member gets one sentence per case (may have multiple sentences over time if he/she has multiple case) A case can have multiple sentences if multiple members on trial. (only one sentence per member) A case may have no sentence if findings = not...