Recent content by JMZ

The aggregate query works I didn't add the new field to my report and kept trying =DLookup in the control source on properties. It all came together. Thank you for helping.

I did the aggregate query and it shows exactly what I want ex. 1st place on November 24, 2024 with John Smith and we matched up 6 times. How do I get the 6 to show up in the unbound text box.

DCount works but it counts all partners as a total.

My report shows the number of times I've placed 1st, 2nd and 3rd place and the name of my partner. What I'm trying to do is add an unbound text box to show how many time we have partnered up together. ex. 3rd place Nov.24 John Smith Partnered up "6" times before My query qPlace brings in all my...

I thought notepad removed all formating.

I did not know that I copied from here and pasted it in notepad and change num to placed, copied and pasted it in the control source where access changed it, so I didn't question it. My apologies GPGeorge for being rude.

GPGeorge I did copy what Gasman posted, when I placed it in the control source of the text box the code was change automatically to what you just posted. Quit being so quick to judge.

MajP It worked like a charm. I will learn more from this code, thank you.

GPGeorge I think I've done that, go to the start of the thread.

=Choose([placed],[”1st”],[”2nd”],[”3rd”])

It wants me to enter paramenter value "1st"

CJ Can you explain how, I'm just getting into programing.

I have a report that show what place a player finished at, this text box will show 1, 2, 3 and I would like it to show 1st, 2nd, 3rd. Does anyone have an idea on how to.

Thank you for responding.

How can I get a ComboBox selection to match one of three fields and fill in a subform? I tried the OR operator but could not get it to work.