98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Expression field in Query - text limit
Expression field in Query - text limit
Resolved · High Priority · Version 2000
Wed 10 Mar 2010, 11:33Delegate Gary said...
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
Fri 12 Mar 2010, 11:06Trainer Jacob said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Copy a Previous Record's Values to a New RecordIf you often enter the same value in one field of a table, there are two methods to save re-typing the data. |
