Search results

  1. S

    Reference to old DAO keeps breaking

    Hi, I guess it is easier for you to look up late and early binding to get more information about that. Pretty sure there is alot of infos out there to read up on. And there is nothing wrong by late binding which is the case when using object. Downside of using late binding is that you are not...
  2. S

    SQL string Syntaxerror(Missing Operator)

    Hope a zip file works here ok? I will be away for a few hours so no rush ... Cheers again!!
  3. S

    SQL string Syntaxerror(Missing Operator)

    Hi MajP, just a few data in it hope this is clear? Made a few mistakes thats why the ID's are a not in order. Many thanks to you!!
  4. S

    SQL string Syntaxerror(Missing Operator)

    Hi thanks again for your help! So I did the first option as you mentioned or at least how I understood it. Again that newly created join I can not change to an outer join. This query shows again no records "no Articles" where no discount is given. I give up on this soon pff,... I am also...
  5. S

    SQL string Syntaxerror(Missing Operator)

    Hi gemma-the-hausky, So you mean create a new table from a base query and use this new created table for a new query? I tried with have it seperated into two "queries" but as I mentioned not really getting the right amount of records. But I will kepp trying .. There must be a way of getting...
  6. S

    SQL string Syntaxerror(Missing Operator)

    Hi guys, thanks again for your input! I did had a very instructor who had a look over the relationship and the model and he aproved it ;) In the query I did add one more Criteria WHERE (((tbl_Kontakte.Kont_ID)=123) AND ((tbl_ArtikelStamm.ArtS_ArtG_IDRef)=[tbl_ArtikelGruppe].[ArtG_ID]) AND...
  7. S

    Hello

    Hi and welcome to the board )
  8. S

    SQL string Syntaxerror(Missing Operator)

    Hi, thanks for taking the time and helping me getting through this! It means alot as I am working for quite some time on that one. Yes in theory I know all this but when it comes down to actually doing it with this query I keep getting errors or wrong amount of recordsets. This is the query at...
  9. S

    SQL string Syntaxerror(Missing Operator)

    Well I do know about the joins you show here but when I do change to join from tbl_ArtikelGruppe ("Group") ArtG_ID and tbl_ArtikelStamm("Artikels") so it would show all records in tbl_ArtikelStamm I get an Error it has to many outerjoins... So do I need to change my original query to be able to...
  10. S

    SQL string Syntaxerror(Missing Operator)

    Hey, this is now working thanks to you guys and especially MajP!! However there is still one more slight problem with this. As there are some "Articels" with no "Rabatt" which join needs to change so it shows me all the "Articels" Can this be done within one Query...? Cheers.
  11. S

    SQL string Syntaxerror(Missing Operator)

    Thanks for your help MajP, No more Error but the outcome is not right... NettoRabattiert shows -120 from a Discount of 25 Percent of 5,00 pff ArtSPreis_PreisNetto=5,00; ArtGRab_Rabatt = 25; NettoRaattiert =-120,00 I guess he assumend that the ArtGRab_Rabatt is in a negativ Number. -25 but in...
  12. S

    SQL string Syntaxerror(Missing Operator)

    Hi guys, thanks for your reply! I will have a look if I can manage that.. Yes I did put the string into the SQL View... I must of missunderstood. Will have a better look at the tables again and check if there is somewhere something I can spot. Thanks for all the help to all of you!!
  13. S

    SQL string Syntaxerror(Missing Operator)

    Thank you, well then there must be a typo somewhere, I will look closer. Many thanks for your help! Cheers )
  14. S

    SQL string Syntaxerror(Missing Operator)

    Thanks MajP, for clarifying! Will look further into it...
  15. S

    SQL string Syntaxerror(Missing Operator)

    Hi, the issue is that a friend helped me with the SQL String but as he helped me already quite bit I was hoping to get someone to be able to point the issue out. And because I have no idea how it suppose to be I can not really use the SQL Design. If that makes any sence?
  16. S

    SQL string Syntaxerror(Missing Operator)

    Hi MajP, many thanks for your reply! Unfortunatelly it is not fixing the issue ( When I run the the SQL string it highlights SELECT tbl_ArtikelStamm.ArtS_Bezeichnung, tbl_ArtStammPreisliste.ArtSPreis_PreisNetto, tbl_ArtikelGruppenRabatt.ArtGRab_Rabatt, SPreis_P Is that showing where the...
  17. S

    SQL string Syntaxerror(Missing Operator)

    Hi guys, just wondering if someone could be so kind and let me know where this Syntaxerror (missing Operator) is in that SQL string? I checked for Typos and it seams to be ok so I guess there is something else causing the Error. SELECT tbl_ArtikelStamm.ArtS_Bezeichnung...
  18. S

    Hello

    Hello, and wellcome !
  19. S

    Old Newbie

    Hey, welcome aboard )
  20. S

    Hi all,

    Hi Isaac, thank you ! (y)
Top Bottom