lost once again
lost once again
Last edited by ChazF; 09-08-2020 at 05:09 PM.
your description is not very clear - which of your descriptions is a field, which a table, what fields in which table
Rather than describing, show us - Suggest show your relationships, some example data and what you want to see from that example data
If your trouble concerns empty fields, try the NZ function: example, for numeric fields NZ([Fieldname],0) returns the field value if it has a value and 0 if it's empty
lost once again
Last edited by ChazF; 09-08-2020 at 05:09 PM.
really confused - where does the 3 come from on the first row? Is that from the column heading? and is the 2 from the column heading or the player code? It may make sense to you, but I'm struggling to see how this is supposed to work. At the moment I suspect your data is not normalised which makes things at best difficult or at worst impossible.
So repeat my request for the relationships and what you want to see from that example data
you say
which I understand but then you sayThe fields [runner_1b], [runner_2b], [runner_3b] show the IDs of runners on 1st, 2nd, and 3rd base. If the filed is blank, then there is no one on that base.
- which says this is after something has happened - which is the 'current position' after this event?The fields [dest_runner1st], [dest_runner_2nd], [dest_runner_3rd] all show where the runners end up after the batter has got on base or made an out.
Seems to me that you are trying to use a field name (or part of it) to generate data in another field if that field has a value in it. If that's the case, there must be a better way. Decisions about what to put in a field should be governed by the data in some other field and not the name of a field just because it has data in it.
EDIT - maybe what you need is the Switch function, but I kind of doubt it.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
lost once again
Last edited by ChazF; 09-08-2020 at 05:10 PM.
OK,
we want to help, but you do not provide the information requested. Your expressions make no sense to me your len expression will either be 8 or generate an error, you might as well use 1, 2, 3 and not bother with an expression.
If you can get it to work in excel, suggest stick with that. Access is a completely different application and works in a completely different way.
good luck with your project but I don't think I can help any more
If you really cannot figure out what I need to do from what I presented, then perhaps you should remove the appellation "VIP" from below your name. Sorry that to have bothered you all and to have taken up your time.
AND, AS I HAVE ALREADY EXPLAINED, WITH 97 FIELDS AND CLOSE TO 200,000 RECORDS, EXCEL REALLY ISN'T THE ANSWER.
Huummmm...... All I've seen from you isIf you really cannot figure out what I need to do from what I presented, then perhaps you should remove the appellation "VIP" from below your name. Sorry that to have bothered you all and to have taken up your time.
AND, AS I HAVE ALREADY EXPLAINED, WITH 97 FIELDS AND CLOSE TO 200,000 RECORDS, EXCEL REALLY ISN'T THE ANSWER.
in Posts #1,4 & 7, then a rude post with some YELLING...
I haven't seen anything about 97 fields. I am pretty sure with that attitude, you are going to be blocked by a lot of members.
If I say "Car Broke", can you tell me how to fix it?
It would be very helpful if you posted your dB with an explanation of how to find the error/problem.
I hope you can find a solution for your problem, but I can't try and help you - no info......
Hope you day gets better...