Search results

Thanks Paul certainly works for me , and has given me the basis to tweak it for my use. steve

I have a string field called WCodes which can consist of 1 to 10 Codes ie "W01 , W02 , W03 , W04" ETC Trying to run an update quert through the dataset to find any that have W01 AND W04 in the string (the rules apply to a few different code mixes but just for this example) as in the case of...

Also made a note of the link http://www.techonthenet.com/access/f...vanced/iif.php Thank again

At first glance, the start should look like: IIf([Weight]>5 and [Weight]<21 __________________ Many thanks that work a dream

Trying to get this iif function to work but keep getting wrong results ie minus or 1st part result instead of second part when applicable. There are 2 charge levels based on a consignment weight minus an allowed value Charge 1 is if a consignmet is greater than 5 kilo then [Weight]-5 gives me...

Thanks Brian works like a dream, sorry I did look at the link you sent but got "way-laid" on something else and I picked up Daves reply today. thanks again Steve

Thank you Gemma I thing I will go down the line of sorting the codes into a single new field, then using a lookup. Could you advise the best way of actually sorting the codes in a query / function aim is to have R393 / R252 / R334 or R393 / R252 / R393 sorted as R252/R334/R393 (removing spaces...

This is snapshot jpeg of the look-up table, Each Route is coded with a store code , when more than 1 store on a run the code is R### / R### / R### etc The Carrier will submit charging using the store code R### / R### etc depending on the actual run on the day. What I am trying to achieve is a...

Thank CJ I will take it away and let you know if I succeed

thanks The routes are a combiniation of deliveries could be Drop A with B with C etc. The Drop Table has indivisual A B C but also the combinations as a string i.e. A/B/C/D or A/B/C so trying to find the correct table code for a combiniation string. I knw it unclear as Im trying to explain and...

I have a large number of 4 digit codes which describe a drop which can be applied to a route, the route is made up of the combination. I am look for a way to check the codes against a table. "A001/A901/C002/V004" could be the chosen string code BUT they may be entered as "C002/V004/A901/B001"...

:eek::eek:Hoping for some good advise I have several DBs (Ak2000 .mde) running on many PCs using the Runtime2000, these have worked 100% until the recent roll out / introduction of Office 2010 / Win7 (None with Access 2010 application as part of Office). We have many pc running o/s from win...

Just a quick update UQ is generating fine for Holland and UK only problem is I overlooked the time field which is part of my UQ String Holland were using ie 9:30AM while UK was 09:30:00 dohh !! cured that with Format([TIMEStr],"Short Time")

Ok, thanks for the updates I have decided to go with using the Clng function to create the UQfld Date portion of the string for the unique field , I have amended both the live version creation into this format and the appending, I will monitor how this goes.

Thnaks for the reply I am using transferspreadsheet range from saved xl version, inported into tem table, various routines run on temp table including making the UQ field, then appending to the live table. this would not be a problem but some data is entered directly into the db by the users...

I have various users inputting data into excel sheets which are then imported into a database. I need to prevent duplicates and for this I use a UQFld:[DateFld]&[TimeFld]&[Booking]&[OtherRef]etc at the point of importing if there are any of the fields missing the data row is not imported. Once...

Thanks but that works within access but still is lost on the export. I have been searching around and have found a piece of code which does work even when exporting to Excel2003 or 2007 just in case its any use to anyone else its below. thank for your responses. Not 100% sure where I picked it...

I am exporting a routing table or query by the main fileld is a Postal Sector text field of 5 chr length. This field includs some with trailing spaces which must be included i.e. s=space; AAsss or AAAss or AAAAs. The reason the Space is required is that this output is imported into a...

thanks for the reply: In the process of typing my reply I just reailised how stupid I am and solved my issue by referencing the stored DAY in my process table. thanks for the reply All sorted now !!

Need some help with Date time calculations I receive orders which rules are required agianist the file Day/Time stamp ie. File Name contains the string 20110922032802 = yyyymmddhhnnss = Thurs 22/9/2011 03:28:02 The Rules are against the DAY and Time and need to function as below: if a file...