Gary has attended:
Access VBA course
Excel VBA Advanced course
Expression field in Query - text limit
Hello,
I have a really complex expression field that I wish to use in a query to sort a group of numbers into different string values i.e. 172 = "Bread Maker", etc. This is based on the IF...Then...ElseIf....Else expressions using the IIF in the expression.
What I need is when the data is inported it looks at the [Officer] field and associates that officer to a string value.
I believe there is a limit on characters in expression fields, can you help me with this??
Thanks,
Gary
RE: Expression field in Query - text limit
Hi Gary
Thanks for your post and outline of what you are trying to acheive.
To be in a position to confirm we can assist we would need to have access to your working files to see what solutions are possible.
This does take us beyond the scope of this forum and more into bespoke and consultancy areas. When we review your files we can let you know of scope of work, durations and costs.
If you would like to discuss this in further detail please contact us.
Kind regards
Jacob
