How to stop Microsoft Access Error 3817?

[SwenGyrowetz]

This is a full error Description: «The multi-valued field '|' is not valid in a CROSSTAB query.»


Any help is greatly appreciated!

[June7]

Have to build query that expands the multi-value field elements to separate records. https://support.office.com/en-us/art...E9BEBBEC31#bm7

I NEVER use multi-value fields.

[ssanfu]

How to stop Microsoft Access Error 3817?

Don't use multi-value fields. Like the rerror states : "not valid (can't be used) in a CROSSTAB query"

This is one of many reasons experienced developers do not use multi-valued fields. They are a real pain in the backside.
I never use multi-valued fields nor look up FIELDS (in tables).

[CJ_London]

I also avoid multivalue fields but you can try using [multivaluefield].[value] rather than just multivaluefield but may not work. However here is a link on how you are supposed to do it

https://support.microsoft.com/en-us/kb/109939

good luck with your project

[Adriano0]

This is a full error Description: «The multi-valued field '|' is not valid in a CROSSTAB query.»
Any help is greatly appreciated!

Causes of Error 3817
• Corrupt download or incomplete installation of Microsoft Access software.
• Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall).
• Virus or malware infection that has corrupted Windows system files or Microsoft Access-related program files.
• Another program maliciously or mistakenly deleted Microsoft Access-related files.
Runtime Errors such as “Error 3817” can be caused by a variety of factors, so it is important that you troubleshoot each of the possible causes to prevent it from recurring.
Read info here: https://social.technet.microsoft.com...eitproprevious