Recent content by Danyul

Hi Guys, Thanks for these replies cheers Dan

Thanks to you both!

Hi All, I have a table that records information on jobs that my business customers need completing. There are several fields of varying types in the table, including a memo field. I am using a multicolumn list box on a form to display a number of these fields from each record - the intention...

Hello Again! I assumed (and we all know what happens when you assume!), that when I substitued your code: SELECT TOP 1 Comment FROM MyTable WHERE EnhanceID=1234 ORDER BY ID DESC; with: SELECT TOP 1 comment FROM mytable WHERE enhancementID= myreport.enhancementID ORDER BY ID DESC; it would...

Thanks HarleyQuinn, worked like a charm! Based on what I've seen on the forum learning to use SQL more effectivley will save me a fair few lines of code, and save what little hair I have left! Cheers Dan

Hi All, I have a table (mytable) that has the following columns: ID EnhanceID Comment ID is a numeric primary key EnhanceID is numeric Comment is text I have a simple report ('myreport') that returns all of the comments for an 'EnhanceID' and the corresponding 'ID' value (each...

Hi All, I have come across a bit of a problem. I am creating the site at www.ozbound.net, if I go to this homepage on any PC other than the one I did the creation of the graphics and html on then I can seee the page fine, it has a side bar menu, a frame for the inclusion of my blog and a...

spot on - thanks Nick

Hi All I have a query that should be a normal 'select' query but keeps askinig me for a parameter. This is the query: SELECT tbltransactionsbycatthismonth.key, (SELECT Sum([tbltransactionsbycatthismonth].[value]) AS Total FROM [tbltransactionsbycatthismonth] WHERE...

Jo, I gave method 1 a try as it seems an elegant solution but can't get it to produce a running total. Any chance of an example as suggested using Northwind ? Many thanks Dan

Jo, Thanks for those solutions, I shall give them a go and see where it takes me ! Regards Dan

Hi Jo, I've checked out the Northwind dbase and can't find what I need. I've included a short example date value c. Tot 3/4/02 10 10 4/4/02 7 17 6/4/02 5 22 7/4/02 11 33 The date and value info I have the c. Tot info I wish to calculate...

Hi I have a table containing transaction data entered from a form. For each record there is a 'value' field. I need to filter the records by catagory, order by date (both of which I can do) and then include a column that carries a running total of the value. I could push it all out to excel...

Jay, At the risk of over simplifying it. In the properties box for the control there is a 'source' field, nect to this field is a drop down arrow as well as the ... for the expression builder. When you click the drop down you should get all the possibles you can link to. Does this work ? Dan

Jo, Thanks for the help. I gave it a go and it seems to work most of the time but occasionally I have to open and close one of the other tables on the tab to get it to refresh. Any ideas ? Thanks again. Dan