Search results

Haha, I apologize for my noob-ness spike. ! Yeah, I have no idea how complicated this one thing is to do. Your email suggestion is not far off from what might be needed though, it's the correct idea. Clients writing in the specific data and that data getting into the database tables. Hmm.

Pat, spikepl, thanks so much for your replies and information. To be clear - I have no idea exactly what I need.? All I know, is that we use a MS Access database to set up competitions and I have been able to learn how to add and program our "scoring" into it. It's a split mdb database. I'm not...

Where does one start to look for information on what is needed to set up an online web form that can write to an Access database? I'd like to learn how I could possibly set up an online registration form for clients to use via a web page. I don't really know where to start, but I have seen some...

Ok, to anyone interested, I solved this. Not in the report though. I was able to build a second query that grouped (totals query) my Division/Category/AgeGroup to one field (Concatenated) and the Score to another field. I then created a third query from that and was able to do a "rank within...

Well, thanks again for the reply Pat. Hmm. I'm not sure what this would allow me to do. ? My report sorts and groups Divisions > Category > AgeGroup > Score. There are hundreds of entries, maybe 15 Divisions, 25 Categories, and 30 AgeGroups - all with a Score. My report groups/sorts all of...

Thanks for your reply Pat, I appreciate it. I basically need something like a DCount expression over a group in a report. Ha, I think. Currently, I am using a running sum over the report groups to show rank (place) by score number. However, I need it to display score ties within the rank...

Brian, I now have a rank within a query that displays ties and orders sequencially like this = 1,2,2,2,3,3,4,5,5,6,6, etc...

GtH - your post sparked my thought. I was able to achieve my desired results by creating a group query with *only* the scores (grouping the score numbers). Then I was able to create another query that distinct-counts those grouped scores. It works. Thanks yet again!

Thanks for the reply GtH. Wait... "just modify the version you have to identify the UNIQUE scores". ?? Not exactly sure what you mean (please excuse my novice-ness). However, I do not need to know who the "4th placed person is" - I need to know who tied for the 2nd highest score, and then...

Oh, I seem to have a bunch of questions lately. Is there a way to have an expression in the control source of a text box in a report, that re-starts or is exclusive for every group within the report? Thanks and thanks again!

Hello all. I have some queries that rank with DCount and show ties like this - 1,2,2,4,5,5,5,8... Is there a way to get a rank that would look like this instead? 1,2,2,3,4,4,4,5 The change would be that the numbering stays consecutive, instead of jumping to the next "number of record"...

I have a report that will be used for award certificates. Each "studio name" is the header of each page, and then rows of "entries" are listed (per studio). The number of rows per page varies. What I'd like to know = Is there a way to automatically space the rows vertically on the page so that...

No sweat Brian, I appreciate your reply regardless. Yup.

Brian - I am not using any formula in the report. I *do* have some ranking queries not related to the report that I need to rank in which I use DCount (with>) for correct results within those queries. What I need to know, is if there is a way I can use a formula within a *report* to show me...

Thanks for your reply Sean. I've googled (and googled!) and seen that page before. The main thing I'm seeing in a report ranking is a running sum counting the records. However, I actually need to see the ties if possible.

I have a report in which I am ranking a group (sorted scores) by using a text box with a running sum. This works, however I'm needing it to display ties according to scores (i.e. 1,2,2,4) - it doesn't display any ties as it's just counting the records, not really 'ranking'. I do know how to...

Sean - thank you so much. This is working. ! Wooo hoooo! Is "vFlag" creating a bookmark, and then the code finding that bookmark each time?

I have two places that can trigger the requery. The main trigger is a 'close/save' button on a subform that opens from the continuous form. The other trigger is a 'requery' button on the continuous form (I could live without this button). So, I have a continuous form displaying registrations...

Thanks for your reply. I'm afraid I'm a bit of a novice regarding code. Would this code be placed somewhere in the "events" properties tab of the form?

OK this is one which I'm sure has bugged loads of people, when you requery a continuous form, the scroll bar position goes back to the top after the requery. Does anyone know a way to return to the same scroll position from before the requery was performed? TIA!