Search results

Think this might do aswell! Do you know if I can do this as a parameter? Cause the date is actually already a function (the dbo read it in as a text). So I had to do this CurrentDate: CDate([date]) Or maybe I have to make another query with that as field?

Hi there! I am having some trouble with a weekday function or something else that might help me pick a proper date as a parameter. I want to build a function that picks yesterdays date if it's tuesday-friday, but on mondays I want it to pick the date from friday. OR if this might be...

Hats off to you, that is correct.. Do you know if it is possible to hide a column but still have it as a sorting column for the table?

Hi there! :) I am wondering if it is possible to send a report as xls file and keep the format exactly as the report looks. When I try to send it now, it automatically changes back to the column names from the table, which I in the report have changed and want to keep in my excel output! :)...

Woah thanks! This definetly seems like it would do the trick! So do I only put this in the parameter field or where do I put it? :P

Okay that can be done aswell I guess.. However I'll try to explain this again. I have a column named sens_test_name In column the value in the fields are named the following: EUR, maturity 0.002739726 EUR, maturity 0.083333333 EUR, maturity 0.019230769 EUR, maturity 1 EUR, maturity 2 What...

I have in a column named maturity which is linked in a reply after! The fields in them are named "maturity 0.002739726" for example. I was wondering about the code or something to change this field "maturity 0.002739726" to just "1d"?

or maybe I can fix it in a query?

http://img835.imageshack.us/img835/1618/nre2.jpg image of column

Hi there! I dont really know where to post this, but im thinkin this could be fixed in a report, if not, I am sorry for posting in the wrong section :) but I got this column representing the maturity sens_test_nameEUR, maturity 0.002739726EUR, maturity 0.083333333EUR, maturity...

How do I write it right in the design view of the report? I want to leave out 0 from SumOfMARKETVALUE so Select SumOfMARKETVALUE FROM USE_Secondary_Trades WHERE SumOfMARKETVALUE>0; Where do I put it? :P never used report tool before!

Hi! I am trying to select a few values for my report, can this be done in the report design view or do I have to make a query and take from that? I am using access 02! Pre-thanks! EDIT: I want to leave out all the values that are 0!

Thank you, will definetly try this!

Hi! I'm having an issue with my query that I can't even figure out where to start with! Here is an example how my tables looks like. dbo.Murex [Instrument] [Duration] [Volatily] OMX2 4 0.18 OMX3 9 0.17 CMD1 2 0.16 NAS1 5 0.14 and a second table dbo.DurationLength...

Thank you! It is a part of a larger book. So Im going to have to go with that alternative. :)

Hi there! I am having some trouble with a query, I'm gonna try to put this out as good as possible :) I have linked two tables together in a query. Each row in the column [Trunc_Name] is so suppose to be unique, but my query put out dublicates for some Trunc_Name's. Almost all duplicates(that...

Here's my assignement to be exact! I've got a table called StructDerivBonds. What I've been assigned to do is somehow make this table appear in an excel sheet. This table is refreshed once a day, therefore I need to have it linked somehow so that the excel sheet is refreshed aswell! So...

Thank you david! How ever I think I want it the otherway around.. I want to link my table to my worksheet.. So the result from the table gives the values to the worksheet!

That is exactly what I have in mind! How do I link a table to a excel sheet? Is it possible to link a query?

Is there a way to make a function/query anything that can copy over to excel? I mean update a sheet in excel or something like that? :) Thank you!