Search results for query: *

Hello again, I eventually got the sub reports working but as suspected by both of us it didn't solve the spacing issues I was having! However, I have now found the code required to force a new line within a text box, entering Chr(13)& Chr(10)will force a new line: =[Field1]& Chr(13)& Chr(10) &...

I have tried setting up the sub reports, and it looks like it might work, however I am unsure about how to link the report and subreport to bring up only the fields required for that entry rather than all the records in each sub report! Hope that makes sense?!

Ha ha, well at least your honest, ill give it a go now then matey

Sorry for taking a while to reply.. I understand what you are saying Zoller, but I dont think this will work either for the same reason that I would have to leave sufficient space in the detail section of the report for the sub report to be dispalyed if there is data there. The only way I...

OK, thanks for your help, I could not use the individual fields though because then I would have to make room for them in the Detail and the space would be there even if there was nothing being displayed! Also, having a placeholder for a blank field in this case would not work, as there are a...

That is originally how the report was set up, however the these fields are arranged above each other like this (headings 3 and 4): Heading1 Heading2 Heading3 Heading4 [fielda] [fieldb] [field1] [field4] [field2] [field5] [field3] [field6]...

Hi there, I have a report that shows multiple fields in a text box. This works fine using the =[field1] & [field2] etc... However I was wondering if anyone knew of a way to make the next field appear on a new line as this would make my report look a lot neater and easier to read! I cant find...

Oh right! Well its good that you have told me about that one its had me stumped for a while! Thought i was going loopy! Cheers for that mate

Cheers mate that has got it going. If you dont mind me asking though, how did that solve the problem? Thanks for your help

If I do that though then the report does not know where to get the data from for that field. It comes up with a diolog box requesting the parameters for the renamed field. Sorry if I am getting the wrong end of the stick!? Also the data that is being displayed in this report is from a query...

The report displays #Error in the field in question.

No, why would I need to do this? Thanks

The field is from a query. I have already tried somthing similar to this and my latest attempt is =[fieldname]/12 (similar to what you suggested!). This does not work though! Any other ideas?! Thanks

Hi there quite a simple question really: I have got a report which displays the value of a field in months. This needs to be shown in years however. Quite simply I just need to know what the code is that you put in the control source of the field to make a division calculation. (As in divide...

Yes, its worked! Thanks a lot for that one mate!

Sorry, where does this bit of code go? Thanks

How can you rename a field in a query?

Yes, if you have a look at my SQL I have already done this: qry_ClientListwSyndMemOwner.ow_name is the first table and qry_ClientListwSyndMemOwner_1.ow_name is the second. (Lines 2 and 5 from original thread). To be honest I think it must be more of a problem with the report than the code...

Hi there, I have a database set up with a field that is used for two different entrys, depending on the relationship it has with another table. I am trying to create a report that displays this field in both of its contexts. So far I have set up two tables with the field in so the field can be...

Cheers mate