Search results

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...

Edit: I wrote this post below at the same time you replied this post above^ If I understand this: each unique member entry (from tblMember) is related to a docket through the charge(s) assigned to him/her. strFinding (under tblJunction) is still under the proper table, since a finding...

I took the screen shot, from the computer I work from, then transferred the screen shot on the computer that has internet to post to you, then realized I forgot to remove the extra relationship. This laptop does not have the updated MS Access, and other computer I work on access with, does not...

tblCharge Charge Desig/NDAref/otherlaw/otherlawRef/StatementOfTheOffence/Alt? First Charge / 129 / - / - / Neglect to the prejudice of good order and discipline / - Second Charge / 129 / - / - / Conduct to the prejudice of good order and discipline / - Third Charge / 130 / 86(1) / Criminal...

1. I decided to combine (again) the tblmember and tblmemberinfo, and in the end, there will be more than one record when a member is charge again, I will have very few duplicate, since it does not happen that often. One way to eliminate a problem, plus, this also resolve my issue if I had a...

tblmember contains information about a member that does not change over time. tblmemberinfo contains other info (i.e. rank and unit) of the member at the time of a specific trial. If the same member gets charged again in 10 years, that member will most likely have a different rank and be at a...