Search results for query: *

Duane just to confirm that I've cracked question 5 and the reformatting of the report. I would really welcome your views on Questions 3 and 4 and then if I crack that the botlle of champange is out!! Thanks Tony

Duane I think I've answered my question 5 by adding Q5 to the query I can use [Q4]-[Q5] to arrive at the Quater ended 12/1/2003, I think!! Tony

Thanks Duane I've never looked at Crosstab queries but I used your code and got some results, thanks that was a step in the right direction. HOWEVER, (and there is always one isn't there?) 1. Having run the query it appears that your code gives 5 qtrs and that Q0 is the latest quarter and Q4 is...

Okay thanks Duane for sticking with me here is what I think you are looking for: This is my data: Return Date Company Amount (My field name)[txtmonthlabel][txtcompany][txtDomfacsoleqtr] (Field Type) (date) (text) (Fixed Number) (In December they would...

Thanks for the reply Duane. I'm so lost in this that I think my explanations are not as good as they should be. First the practical issue, what am I getting and what am I trying to do. I have a database that holds data of statistics on performance from various companies. They provide us with...

I have posted a number of posts in the Access newsgroups concerning my problem with DLookup. I have had a number of the experts with helpful suggestions but I still can't get it to work! This is what I am trying to do: I have a table called tblmaintabs which holds year to date data for a...

I have a calculated control in the detail section of a report. The calculation is =[txtDomfacsoleqtr]-(DLookUp("[txtDomfacsoleqtr]","tblmaintabs","[txtMonthlabel]= [txtqtr1]")) The calculated control is called prevqtramount. In a footer I want to calculate the sum of this and have used...

Thanks, yes the form was created by hand so looks like I need to add the code for every calculation to the before update event UGH! there's loads! Thanks again Tony

Thanks for that, presumably that means that I have to repeat ALL of my row and calculations in this code in the before update proerty of the form as well as the before update of the totla controls? Thanks again Tony

I have a form that contains a number of numeric controls. There are a number of rows and columns of figures and each row and column has a total.The user fills in all the controls, even the totals. I have validation code on each total to make sure the total is correct (the user wants to key in...

Thanks again for all your help. I will certainly adopt your troubleshooting idea in future it makes good sense. Learning Access is one thing learning what to do when things go wrong is something different. That's why us newbies need guys like you!

I think I've cracked it. I created a new text box and put the formula in there and it worked. So I think I need to replace all the controls where I want this calculation to work with new text boxes. Although I don't know why it should work this way and not with the origional controls????? Thanks...

Done as you've said and they've all got values? Tony

No Ginger there should always be a value. Tony

Sorry just realised that missed off = sign. However I now get #Error. Anyone see why? Thanks Tony

Can anyone tell me what's wrong with this formula? ([Sum Of txtClients0]*[txtclientstotal])/[Sum Of txtClientsTot] TxtClientstotal is a calculated on the report the other controls come from a query. I get an error message asking for Extra "(" in the formula. I've tried putting () around most...

It would appear that there is a bug in Access 2000 according to the Microsoft site that want allow the sub report to go Down then Across it has to go Accross then Down. This is OK but it makes my report a little less attractive from a presentation point of view. Do you know of a work round...

Txs I'll let you know how I get on

Hi again! I'm not sure having looked at those webpages that they cover what I want to do. Just to develop my problem further. The report is 4 pages long, three (1,3 and 4) of the pages are set to 1 column in the Page setup but 1 page (page 2) is set to two columns. If I include the page 2 as a...

Thansk a lopt that's really useful info. Tony