Search results

Just put up a noddy excel example.. It's hard to explain but in essence I need to take the dates from the cash record and add it to the collateral records based on me assigning the worse quality collateral first.. In the attached example you can see the cash and the collateral table... then...

After a 5 year hiatus from ms access I find myself back using the tool in anger and struggling with something that would have been very basic back in the day The problem I'm trying to solve for is as follows : I have a two tables - one is cash with a term date and the other is collateral...

Thanks Neil, Unfortunatly that how the data is sent to me. I have no control over this. I need to find some way of extract these one by one and look them up on the index table

Hi there, In my table one field has several codes to relect the fact that on equity can be listed on multiple indecies. It looks like this ;2;5;1;1;GF;1;LX;1;GD;1;SE;1;GB; I have a table which contains all of these codes and a yes no flag. What is the best way of parsing this information...

Thanks for your reply Pat. The field is text and I already changed the table properties to AZL and set the required field to No. Its still an issue unfortunatly

Hi there, I'm using a passthrough query to get information from sql server. Unfortunatly when I try to append a field to a local access table I get validation errors as the field is blank. The table is set up to allow nulls but I think the sql field has some other type of null init. Ive tryed...

Ok - I worked out what was happening for anyone stuck with the same issue. The dba was setting up the data type as decimal(32,10) while access only allows a maxium percision of 28.

Hi, I am trying to link an access database to sql server but whenever I link or import it it changes datatypes which are decimal and numerical on sql server 2005 to data type text in access. The DBS doesnt want to use float as its numerical data and I dont wanto to have to convert loads of...

Hi MikeC1408 , After much trial and error It looks like the issue is realted to data type differnces between access and sql derver. In sql the decimal dattype trasnlates to text. I asked teh dba to change to float but hes firmly gaianst it as its ths the wrong dat type for financial data. I...

hI. I want to connect msaccess to a sql server database using a dns less connection. I dont want each user to have to set up a system DNS as they all should have acceess to the sql server. The problem I have is that using the following code the data types are differnt between the sql server and...

Well done microsoft, another great fully fuctional feature http://office.microsoft.com/en-gb/help/HP052389601033.aspx You cannot create calculated fields (calculated field: A field in a PivotTable report or PivotChart report that uses a formula you create. Calculated fields can perform...

Thanks Shades. Unfortunatly the nember of records prevents this and the whole purpose of the cubes was speed of analysis. Seems a shame to limit the olap functionality in excel.

Hi, I am trying to build an analysis tool to assist one of my colleauges. I start with a results tables in my access db with 2 days worth of the data in extatly the same format. I then create a cube in excel with 2 dimensions. One shows a Legal entity -> Ultimate parent -> individual. The...

Thanks for all your help. I didn't subscribe to the thread so I dint think anyone had answered. Thanks I do appreciate your responses

Thanks for all your help. I didn't subscribe to the thread so I dint think anyone had answered. Thanks I do appreciate your responses

Thanks for all your help. I didn't subscribe to the thread so I dint think anyone had answered. Thanks I do appreciate your responses

Hi, Im new to sql server so please forgive me if this question is obvious. Any help is appreciative what I'm trying to do is a recursive look up of child to ultimate parent. The data is structured like so . if I look up child 2-4 I want to return sub Parent 2 child sub Parent...

The only way I could get over the "too many tables open" was to convert the database from 2003 to 2000 (or vice versa). This process seem to reset the table ids and I haven't had the problem since. I'm still struggling to understand the best way to Look up the reporting currency (USD) for each...

All of the records on the deatiled table does not have "USD" to allow me to link. I would have to add this in an update query and then link through. Just wondering of there is a better way to do it. BTW i managed to clear the database of the tool many tables issue by converting it to access to...

I have never some across this before but my database keeps throwing a "Too many tables open error" which has taken me a day to get to the bottom of. I believe that the use of a dlookup in one of the queries not cleaning up after itself. The issue I have now is that even importing the tables...