Search results

Try: Format(Table.Field,"short time")

I can't figure that out. As an example: Policy Trans Company Amount Created_By AB123456 A001 Client 1 1,000.00 MCS AB123456 A001 Uwtr 1 -900.00 MCS AB123456 A002 Client 1 2,500.00 FMD AB123456 A002 Uwtr 1 -2,000.00 FMD...

Just a thought, but both of the above expressions will only work if the City is one or two words. Because it looks for a second space to use as the cut-off point, it will produce duff results for any string with more than two spaces in it, i.e.: Salt Lake City UT would produce "Salt Lake" as...

Try: Left(Trim([ADDR2]),InStr(IIf(InStr(InStr([ADDR2]," ")+1,[ADDR2]," ")>0,InStr(InStr([ADDR2]," "),[ADDR2]," ")+1,1),[ADDR2]," ")-1)

This isn't pretty, but works with the examples given: Right(Trim([ADDR2]),Len(Trim([ADDR2]))-InStr(IIf(InStr(InStr([ADDR2]," ")+1,[ADDR2]," ")>0,InStr(InStr([ADDR2]," "),[ADDR2]," ")+1,1),[ADDR2]," ")) Hope this helps!

I have a list of transactions processed on insurance policies, and am running an aggregate query to find the total amount on a policy for each client/underwriter. Each transaction has a created_by field, identifying who deals with it. I can obviously get the aggregate query to give me the min...

Too many quotation marks (around the =). Try: x = DCount("[TelNo]", "[tblData Comparisons]", "[ALO IDENTIFIER] = [BLO IDENTIFIER]")

Is it whole records that are incorrect, or just particular fields? And how do you identify the incorrect data - are you running a query?

Issue now resolved, although I don't fully understand why. I have placed the DoCmd.Hourglass True/False statements within the on_change procedure of the tab control. I was actually using images on the first page, not command buttons, and the hourglass would not appear. By placing...

I have a tab control which has many pages, most of which have subforms on. I have removed the tabs and control the page-change by using command buttons on the first page. The source objects of the subforms are set and requeried as part of a Select Case statement within the on_change event of...