Recent content by bsnapool

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?