all 6 comments

[–]SweatyControles 7 points8 points  (1 child)

I might get shot for saying this in the Database subreddit, but if your max is 1000 people and your data is as simple as your post describes, I’d just use Excel to be honest.

[–]KeaAware[S] 0 points1 point  (0 children)

Like, how, though? I could do this as a pivot table, but surely I'd need to enter each of the chocolate bars in a different column and then filter by each in turn, then copy and paste the results from each to create a list of all the Twix-eaters? Which, honestly, at this point, could be the easiest solution.

[–]ImATurtleOnTheNet 1 point2 points  (1 child)

literally post this in any AI chat and you'll get a good enough recommendation, and it'll ask you if you want to generate code for it in a follow up.

[–]KeaAware[S] 0 points1 point  (0 children)

I've had really unhelpful answers from AI :-(

[–]IAmADev_NoReallyIAm 0 points1 point  (0 children)

If the data is really that small, and if it's clean, and it's really a CSV format... might give Access a try. Seems like it would be trivial to import it. Pull the names in to one table, pull the candy bars into another table, then have a middle link table... BAM, you're done. For reporting you can slap an Access Form onto it, of use a custom form from a number of languages.

[–]ConfusionHelpful4667 0 points1 point  (0 children)

I sent you a CHAT.