Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by elefantmannen

  1. elefantmannen

    Two different sources in the same text box

    no, it doesnt work. I write it in the textbox, save it and run the report. When I open the design again access has changed it into =table1.name & " " & table2.name
  2. elefantmannen

    Two different sources in the same text box

    yes it works, but there is still a problem here... I have a query where information comes from two different tables and they have the same name. (table1 has a name, and table2 has a name) so I would like to write =[table1.name] & " " & [table2.name], but it doesnt work...
  3. elefantmannen

    page break subreport

    it worked like a charm! Just sorted on a value which ws the same for all the rows and the subject appeared on every new page!!
  4. elefantmannen

    Two different sources in the same text box

    I read in some post about adding two differet sources in the same text box. (Like value1 + " " + value2) but I cant find it when searching the forums. Someone who can direct me to the post or just put the answer here??
  5. elefantmannen

    page break subreport

    I have a main report with a subreport included. Problem is the sub report is a couple of pages long so I want to add a heading for each new page. Eeeeasy, just use the page header... No! it doesnt work. The page header from the sub report doesnt show up in the main report. Its like the sub...
  6. elefantmannen

    Dynamic heading with a sort

    HURRAH!!!! It works, big thanx for hanging in there!!! I'll be back with other problems.
  7. elefantmannen

    Dynamic heading with a sort

    they are connected by the fo.frageid and fr.id, but I can make an inner join on these two fields. Problem with the adding of a new column is, I cant even create it as it keeps telling me it is wrong syntax.
  8. elefantmannen

    Dynamic heading with a sort

    Damn, your fast! sql: SELECT * FROM formular as fo, fraga as fr WHERE fo.frageID=fr.id AND fra.kontroll='Mat' OR fr.kontroll='Ins' OR fr.kontroll='Kva';
  9. elefantmannen

    Dynamic heading with a sort

    Nope, I get the same error message here as in the report "Wrong syntax...".
  10. elefantmannen

    Dynamic heading with a sort

    No, it is not a table it is a query.
  11. elefantmannen

    Dynamic heading with a sort

    hey, dont be sorry, there is still hope! What do you mean by "New column in your query"? What I did now was creating a control with the control source "IIF([tablename].[svar] = "ja", 1, 0)" Was that correct? Maybe it is obvious but I have never used IIF before.
  12. elefantmannen

    Dynamic heading with a sort

    Hi Bob, No sorry it doesnt work. Guess my access is all f-d up. Thanx for all the help though!
  13. elefantmannen

    Dynamic heading with a sort

    I really start to think there is something wrong with the entire IIF procedure on my computer. I get a syntax not valid-message for the above mentioned expression. No matter how I try to use the IIF, it fails. Tried it on two different computers and it doesnt work on any of them... Could there...
  14. elefantmannen

    Dynamic heading with a sort

    ok, I have the category controll, which is named svar. I have added another controll named checkAnswer in the detail field. How shall I bind it to the controll svar? (Now I have [svar] in the control source for checkAnswer)What I really cant figure out is the "Me"-thing, what is that?
  15. elefantmannen

    Dynamic heading with a sort

    I dont know if it is the Me.yourControl that is the missing link. Now I type =Sum(IIF([svar]="Ja",1,0)) where svar is the category to count. If I write it like this, it says "bad syntax". I have an Access book where this seems to be the way to write it, but it just doesnt...
See more

Part and Inventory Search

Back
Top