Search results

Hi All, Struggling to import a text file into an access table in a readable format. Everytime I import the file with space delimited, All data goes into the first field as the fields have a square between the data. if this was a space it would be perfect. Has anyone come across this issue...

Hi All, In need a quick fix, need to get these reports in ASAP. I have a text box which looks at the fields in The "Detail" part of the report. which looks like this: IIf(Len([SumOfCost] & "")=0,[SumOfSumOfActivity Cost],[SumOfSumOfactivity cost]-[SumOfCost]) But in the group I would...

thanks for your reply... It was my bad, had not changed the source data after copying the a previous query. Thanks

Hi All, Quick question... If I were to do a right join on four different attributes E.g. a = a b = b etc etc and the criteria would be Attendance is null. I am getting the results back which I want but the columns which I have joins on are blank? Any ideas why? Any help appreciated....

Hi, Is it possible to create a lookup in a query against a table which has not relationship but has a match? E.g. iif(spec(in query)=Spec (match table) then bring back cost in (match table) Hope this makes sense? Thanks

Sorry to invade this post but I was wanting the same info and an answer to my question regarding DTS. I currently have taken over this DB in new role and these is processing of data in VB and was wondering whether a dts would be more effective? What kind of things is it used for? The current...

Thanks for your help... Will post back when sorted. :)

What function would i use for this?

Hi, Wondering if anyone has a solution for my problem. I have 2 data sources, one which is an ODBC and one which is an import table. I have a 2 queries each querying the 2 data sources seperatly. My problem is... One of the fields which I need to do a join to a reference table has a...

Worked a treat!! A lot easier that nested iif statements. Thanks Brian. Also Thanks Ken for your efforts and help. :):):):)

Interesting!! I have never heard of this function before. Brian, thanks for your help(AGAIN) will have a try and post back.

Fellas, Thanks very much your input really appreciated. Brian, Any examples??

Hey, Still struggling with this. The -3 will not work as when it gets to January it will be -2?? Any ideas??

I have tried -3 and this seems to work but wondering whether i would come across problems when new financial years comes in? Financial_Month (Actual Month) DatePArt 1 4 2 5 3 6 4 7 5 8 6 9 7 10...

Ken, The datepart() function worked a treat but what if Im wanting to do it from the financial year? April = 1, May = 2 Any ideas?

KEN, Thanks very much for your help will look into what you have suggested. :):):)

Function. I am not the best with vba. Is there another alternative?

Hi, I am going to be creating a iif statement update qery, to update a column on dates, E.g. would be.... IIf([FinMonth] between 01/01/2008 and 31/01/2008,1)iif([FinMonth] between 01/02/2008 and 30/02/2008,2)iif(etc etc 2 questions?? 1) Is 12 nested iif's statements are allowed within one...

Well put the format as percentage, when added "", it would then take the percentage formatting off.

School bot error, was using the actual field!! Used a testbox and working.