Search results

Thanks zig

this seems to work: on the debug: name2 = "1234 Pheasant Street, Wherever CA 94587" les22 = mid(name2,instr(1,name2," ")+1) ? les22 Pheasant Street, Wherever CA 94587 on a query: select mid([address],instr(1,[address]," ")+1) As ADDSORT, * from wherever

this seems to work: IIf(InStr(InStr([address]," ")+1,[address]," ")<>0,Right([address],Len([address])-InStr(InStr([address],"")+1,[address]," ")),Right([address],Len([address])-InStr([address]," "))) AS SORTORD ty, =)

Not Separate.

Can anyone tell me how to sort a field [address] by street name not by street number. Is this possible?

Can anyone tell me how to sort street addresses by street name not by street number. Is this possible?

definitely a food for thought. now, I have to find out whether they want the loan to have a fixed or annual rate. A new dillemma. lol thanks, les

Ctrl-G .. got it. Very impressive raskew.

i am using access 2000 and typing ? whatever on the debug window comesback only with "print whatever"

Raskew, Your reply looks interesting. Can you give a step-by-step instruction to an obvious rookie on how to see this work. Attaching a file would help.

Had to use IIf() on the textboxes in the form. =IIf([MonthsToPay] > 0, [pay1],"") Gee, thanks all.

i tried to use CASE but it doesn't seem to work on access. please help

Can anyone please help me with my current dillema. I'm creating a billing form and i need to breakdown the monthly payments (date). I have a field where users enter the first payment [firstpayment] and another field where they enter the number of months [MonthsToPay]. Now, I breakdown the...

Can anyone please help me with my current dillema. I'm creating a billing form and i need to breakdown the monthly payments (date). I have a field where users enter the first payment [firstpayment] and another field where they enter the number of months [MonthsToPay]. Now, I breakdown the...

If it was a snake i'd be dead. thank you!

Thanks for the suggestion. However, I need to be able to query out records based on the textboxes with expression for monthly billing. The fom I've created is a Billing form that breaksdown when the dates of the payments based on [FirstPaymentDue] by using...

Can somebody tell me the best way to save a textbox with an expression into a field.

give it a minute. third option is a tad slow

As a work around, since IsNothing works on the converted database from 97 (so the wizard says), I copied and pasted all of my forms, databases, queries and reports into the converted one. Re: IsNothing being a built-in function in 97 or 2k is uhm... hmmm. I'll have to go with the saying "if it...

Finally got this working by creating a search form using a yes/no buttons based on a previous post : http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36145&highlight=searchhttp://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36145&highlight=search For some...