Hi Guys,

Thanks for the replys. The requirements have changed so I've left this behind now. I never did get to the bottom of it though.

Thanks to those that contributed.

Mark

Hi Gail,

Thanks for replying. I'll get some sample data together, my explanation probably isn't great!

Thanks

M

Aah, gotcha,

I've place the join inside my existing query and it works beautifully.

Thanks for the extra advice. I'll have to have a think about all the issues you've raised.

Many Thanks...

Hi Guys,

Following on from Seth's post...

I understand the design of the tblCurrency and the reasons for it. I also understand that I will insert CurrencyID in the "other" table.

When...

I'll start again. I have a table where a number of fields are inserted by a user. One of these fields is "currencyname" which stores the currency name eg. pounds,...

I'm sure it's me that's missing something not you!

From what I can gather, you're saying I can use the value I have that was entered via the DDL, check what...

Hi Chris,

I already have the currency name and currency symbol list in a table with the Currency Name populating the drop down list the user will select from.

This DDL is...

Hi John,

That works a treat. Thanks for your help. It's much appreciated. Thanks also for the info in formatting code listings. I've never really looked into doing things this way....

Ok Here goes.

I'm just working with test data too so I've only created a very small set

SELECT '1','6','Jan 1 2009 12:00AM','Jan 8 2009 12:00AM', UNION ALL

SELECT '2','6','Jan 15...

also just discovered that if I change from WHERE NOT EXISTS to WHERE EXISTS then all rows are returned. This suggests the subquery is not working correctly no?

Regards

Hi,

I assigned a date format dd/mm/yy to @StartDate and @EndDate.

I have different data in my table than the data supplied above but the first query works fine with these values...

Hi Chris,

Thanks for your interest . Very bizarrely, where you have put operator missing some of the query has disappeared. I've tried to edit the post and repost the whole...

Hi,

Ive used the tutorial i found (see above link) to produce a query that will give me the Id of any unit the DOES have a reservation between 2 supplied...

Hi Seth,

Just one more thing i've just come across:

It looks like if the number of rows retrieved in RateCount is 0 it returns NULL. Is it possible to have the...

Well I've got to hand it to you....

I'm very grateful for your effort with this. It would have taken me forever to figure this out.

I hope you're always this helpful!

Once...