Recent content by Nip351

In reference to "That's not what your data presents. ID=25 uses the Onhand for subfamilyID=2." Thanks for verifying the sample data. It is possible to have a higher Idnum with a lower subfamilyid for the same familyID. Such as: Idnum FamilyID SubFamilyID 154 10...

I only have limited time to post and/or review. I try to include everything I can in one go, so I apologize if you think its too much. Ive added a second zip of a Start and Finish csv of about 20 or so records before and after their expected update. Basically, the results for each familyID...

There more I think about this, or the conditions, the more complicated it gets. I've attached a partial data set of the fields that are needed. Basically, there are records which may be related (family and subfamily fields). Many are related in sets of three. Some have no (family)...

Works great! As mentioned above, the default Caption for this button is Show Starters and a single click filters all Starters (subfamily = 1) and changes the Button Caption to Show All. A double click sets the filter off and changes the button Caption back to Show Starters. The following code...

I figured this out using a Command Button and some code. I added a command button to the form, edited the On Click property and added the following: Private Sub cmdFilterBySelection_Click() On Error GoTo Err_Handler Screen.PreviousControl.SetFocus Me.Filter = "SubFamilyID = 1" Me.FilterOn =...

If you are familiar with Pokemon (Go) then read on, if not, start from Part II as this may be too much or irrelevant info. Part I - If you are familiar with Pokemon (Go) I have a growing functionality database for Pokemon Go that does quite a bit. Right now, Im trying to figure out how I can...

I just figured it out! Since WHERE is already part of the ConcatRelated, I just needed to append & " AND SUBFAMILYID <>1" to the end of the ConcatRelated field. It now omits the SubfamilyID of 1 from the Spawns field as requested. Complete Updated Query: SELECT tblmain.Idnum, tblmain.PName...

Ok, this is deep... I have a working query using ConcatRelated, which is working great with one small piece I want corrected. This is a database I made for my nephews that play Pokemon. It allows them to enter all aspects to track, see what they need, candies, CP, etc. There are about a...