H E L P

[Naka]

hey guys, i need to know if i can do something like this:

i want to in my query, create a new calculated field. this field, is calculated by taking the "quantity" field in my table, multiplied by the "status" field in my table. but the problem is, some of the entries in my status field have a letter in them, ie "N3" and most of them have just "5" or something. so to calculate the new field, titled "total prints". i need to multiply quantity and all of the single digit numbers in the status field minus the letters

 

[Brianwarnock]

Val(field) will just return the numbers

Brian

 

[Moniker]

Val("N3") will return a 0. If the string starts with a letter, Val returns a zero. Val also stops the first time it hits a non-numeric character, so Val("12AB34") would return 12.

Use this function, which will return only the numbers regardless of how they're mixed with characters. Look at response #8.

 

[Brianwarnock]

OOPs! apologies to all my readers I've only used Val for nnnddd type fields never realised the sting in the small print, read help and you'll see what I mean.

Brian

 

[Naka]

thanks guys