hi chris i looked at that and it fine but you giving me the start and the end date but i want the list of all the dates within those...

for instance '01/09/2008' - '07/09/2008' by looking in my calendar those dates fall in week 36 so i need to get all the dates which falls on wk 36,37,38,39

hi Chris

thanks for the response, actualy i'm trying to get dates within week 36,37,38,39.

apologies for my mistake, i didn't elaborate that thorough

hi guys

sorry i took some time to respond, i was out of the office for quite sometime and i'd like to thank everyone who participated in this thread.

you guys rock

hi serinor

the query you sent did exactly what i needed, and now i can continue with my work cause that was holding me up.

thanks again and all of you guys...

my id is unique value... what other possible ways there could be.

i tried this approach:

SELECT Depreciation.Depreciation, Depreciation.TransactionID,Depreciation.Depreciation +

coalesce

(

(

select sum(Dep.Depreciation) from Depreciation Dep

where Dep.TransactionID < Depreciation.TransactionID

)

, 0)...

thanks Ken, will work on it now and see if it's works

thanks again

thanks for the input, though in my case i'm using a dropdown which has a list of 289 records a user has to select from but when populating not...

hi

i wonder if you could help me with this one, i'm going nuts here cause i can't seem to figure out where the problem is:

i have a report with parameter...

hi guys

thanks for the responses and references it's helped and i've started using crystal and yes it's a pain working with formulas when you have to create grandtotals by i...

hi

i need a favour i'm struggling to get a correct value out of my table:

AssetID AssetCodePcodeDepIDStaValue

6370IT_INFR 1006102421953.43

6370IT_INFR ...

thanks for the input, i'll sure give it a go....... can you give me any links where i can get reference books??

thank you sooooooo much nigel.c.west, the listbox did exactly what i wanted, it really helped and now i'm able to run my report the way i want.

thanks again

sorry jack for not giving you the complete info.........

and thankz for giving me the lead, but i don't think i follow though but i'm gonna try and do as you...

thankx Jack for responding so quick

the thing is the format of my report is different from the normal layout,

i'm displaying the property information here's the layout of my report

my...