Trying to correctly create a DCOUNT for unique transaction IDs.

Best Microsoft Access Programmer Portland OR

Trying to correctly create a DCOUNT for unique transaction IDs.

https://i.redd.it/t3tl0wpmo5531.png

I’m stuck. So I have attempted to build a DCOUNT with the objective of telling me how many bins per transaction ID (wireless_trans_audit_hdr). I don’t need to know the bin_ids, just that there are 37 or however many unique bins associated with this transaction ID.

For sake of time, I won’t walk you through the different iterations I have attempted, but most have either resulted in needing a parameter value, invalid bracketing, or lack of an operator. Most of it seems to do with the how I’m formatting and typing (which is 95% of Access errors right?)

My criteria:

– must be per transaction ID (there is only one in the screenshot, but know that there are hundreds)

– must not include anything beginning with SC or RC in the count.

– must not count blank cells

Where would you go from here?

submitted by /u/BuckFutton
[link] [comments]

Get the best Microsoft Access consultant

Get the best Microsoft Access programmer

Microsoft Acess Developer Portland OR