Search results for query: *

Thank you.

OK, The first expression produced nothing, the second produced "Chambre" and the third produced "Vulture". These two were the correct output.

Duane, TblSignature looks like this: TxtComp TxtPosition TxtTrophy Centenary 1 President Chambre 1 Chambre Chambre 2 Vulture cock 1 Cock cock 2 Tappet Hen As you can see, some competitions (TxtComp) have both 1st and 2nd place trophies, whereas others have only 1st...

Duane, TxtPosition generates either 1 or 2 (the underlying query has the top 2 from each competition) and the trophy allocated is based on the position. I therefore need to compare the running sum value (1 or 2) from TxtPosition with the data in TblSignature. The DLookup text box, TxtPosition...

Sorry Duane, still comes out blank. I tried with and without "Report!" but it still doesn't work. It worked if I used a single comparison i.e. TxtComp with TxtComp but as soon as I try to add in the additional comparison it stops working. Just to clarify I have text boxes in both the report...

Problem - I can only join the TxtComp fields as there is no TxtPosition in the final Union Query. TxtPosition is generated in the report based on TxtTotal for each group. The result is four results for each TxtComp instead of two. I tried different type of join but it makes no difference. I...

Sorry, that ended up with a blank text box. TxtPosition in the report is a text box based on a running sum over the group, which I assumed to be numerical. I therefore made the data type of TxtPosition in my table numeric as well. When that didn't work, I then changed it to text because I...

Hi Dhookom, Thanks for that. I've changed the name Type to "TxtComp" throughout, just to be correct, but my code still does not work. I think it is all to do with the single and double quotes, but I can't sort it out. I would be most grateful if you check my latest code and sort it out...

Hi GingerR I'm making progress. I created the table as you suggested TblSignature Type TxtPosition TxtTrophy Centenary 1 President Chambre 1 Chambre Chambre 2 Vulture cock 1 Cock cock 2 Tappet Hen I then tried to join this to my Union Query but I couldn't find a way of doing it. If you...

Thanks GingerR, I'll have a go but don't be surprised if I come back to you. I'm very much into uncharted territory here! Best Regards John

Thanks GingerR and Duane, I see what you are getting at but I'm a bit out of my depth. My report is based on a Union Query which combines the results of three other Union Queries, as follows: SELECT Type, TxtUnit, Total, BisleyYear FROM QryResultIndividual; UNION SELECT Type, TxtUnit...

My report has a text Box which has a Control source based on a series of IIf Statements as follows: = IIf ([type]="chambre" and [position]=1,"chambre", IIf ([type]="chambre" and [position]=2,"vulture ", IIf ([type]="mersey" and [position]=1,"mersey", IIf ([type]="tyne" and...

Thanks PHV, that solved the problem. Your help was, as ever, much appreciated. Best Regards John

The following query selects teams that are competing as Honours Only (HO) and not Honours Only (NH). I have created individual queries, both of which work, but when I combine them in a Union Query, I receive a dialog box with the following statement: "The ORDER BY expression ([TotalFibua]+...

Thanks again to both of you for your help. I got PDF Creator working but I didn't like the combining part and, as I already had PDF995, I decided to use the combining part of that. Its very similar to Adobe and very easy to use. At the end of the day, I have solved my problem and can do what...

Lameid and Huggyboy I have downloaded the free version of PDF Creator and this does exactly what I want. I can now click on my Create PDF command button and all the reports in the list are automatically saved into a file on my desktop. I still have a problem with combining them, but that can...

Thanks Lameid, I know that CutePDF has a Custom version which will do what I want, but that is really expensive ($400+). Considering that I only need this two or three times a month, its not worth it. I'll have a look at PDF Creator and see if it will help. Otherwise, I guess I'll just have...

I have a command button which prints a series of reports to CutePDF. This work fine but each time a pdf file is created, a box appears asking me where I want to save it. Is there a way of adding a line to my code which does this automatically? The code I have looks like this: Private Sub...

Thanks Remou, I didn't think it would be as easy as that. I'll give it try and let you know. Best Regards John

I have a report which is 3 pages long. My printer properties do not offer me the option of printing in reverse order so I was wondering if it is possible to reverse the print order (i.e. Page 3, then page 2 and finally page 1) by adding some coding to the report. Any help would be much...