General

Re: Concat Expression Formula

Monte Cristo — Mon, 10 Sep 2007 05:28:21 GMT

Hi Patrick,

I am calling on the max function to provide the next available number in the sequence, so the tbl in the database has only 0001, 0002 & 0003, so I use the max + 1 to return the next number in the sequence.

Once I have this number and I've filled out the form I record a new record in the database and it repeats.

Custom function any idea where to start?

Thanks,

Re: Concat Expression Formula

Patrick Halstead — Mon, 10 Sep 2007 04:12:43 GMT

Hi Monte Cristo,

Why are you calling the max function? I think that may be one of the problems. Try removing that and see if the data type of @Claim_Number is of type text. If it is, you will have to use a custom function to get the maximum (some string enumeration will be required.

Good luck!

Concat Expression Formula

Monte Cristo — Mon, 10 Sep 2007 02:15:07 GMT

Hi,

I have a database with one table, it has three coloumns, (1) a simple number format 0001, 0002, 0003 & so on....[text format in access] (2) Name [text format in access] (3) date [date format in access]

So I have connected this database as my main connection and this all works.

I have an expression box which queries the database coloumn (1) but the expression box returs the value without the 0's so all I get is 3, 4, 5 etc.

This is the formula in the expression box: concat(Year, "-", ProductLine, "-", max(@Claim_Number) + 1)

BTW - @Claim_Number is the one querying the database coloumn (1)

Can anyone please tell me how I can return the values of coloumn (1) with the leading zeros? I have tried to change the format of the coloumn in access to a number (long integer) still not returning the values with the leading zero's.

Thanks,