Recent content by Xerox

Hi all, I want to be able to limit a combobox to a list which is depended on the first 2 comboboxes. I have a Master Catgegory, when selected you move onto the 2nd combo the 2nd combo is depedant on what is selected in the Master Catergory combo. The 3rd combo is dependant on the 2nd combo...

Guys thank you for your help, replacing the GroupBy to Where has solved the problem.

Hi I have a query which totals up the sales of each product between 2 dates. The problem is that I am getting every entry for products sold between the 2 dates entered by the user. What i need is total sales of each product between 2 dates without showing every entry (Just the totals of each...

Not too worry Colin, I have sorted it out now, thanks for the help anyway.

I have a an indentical database like northwind except that I have weights that are needed to calcuate the extendedprice.But I have a couple of products that have no weight associated to it and hence need the extended price to be calucated differently for example: If Weightlb > 0 then...