Expression field in Query - text limit

Resolved · High Priority · Version 2000

Wed 10 Mar 2010, 11:33 Delegate 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:06 Trainer 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

Tue 16 Mar 2010, 08:47 Delegate Gary said...

RE: Expression field in Query - text limit

Jacob,

Sorry, I am unable to send the file as it is a data protected document.

I think I have solved it anyway.

Thanks,

Gary

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips