Search results

I have a query listing those people who attended a training session. The query contains sessionid, attendeeid, surname. I want to be able to add up all of those present. I have tried putting "count" in and just end up with a series of "1". How can I get it to add up all of those who were...

I have a form with an embedded subform. The form has a firm and the subform shows employees at the firm used by us. I want to show the running total in some way or just have the numbers by the side of the columns in the subform. Is there an easy way to do this?

I've tried this about 10 times now on the subform (which does come out sorted alphabatically when i just open that). When I open the main form with the subform embedded then it goes back to them appearing unsorted on the subform section!!

I have a database with firms and employees. In the header I choose a firm, in the main form the data about the firm is dispalyed and then in the subform I have a list of employees who are part of our project. The trouble is they don't come out in alphabetical order by surname which I need...

That's fine but I'm not sure I understand the syntax and am not sure about your CHR(13) etc. If I have field add1, add2, add3,add4, city,zip where 2,3 and 4 are frequently blank, how would I produce the concatenation? Also, would this be in the query?

I have some reports that gather address data from a query. Some fieldds are blank (eg add4 and add5). How can I set up the report so that it doesn't leave blank line where there are blank fields?

I want to run a macro from a menu which opens a word document and runs a mail merge which gets its info from a query. I'm sure this is easy but can't find out how to do it. Any suggestions/examples? Many thanks

I have a form with a combo box in the header section and address etc in the details section. I want to be able to choose a firm from the combo box and then see the results below in the details part. It works fine, but when I open the form first of all there is data in the details section. How...