Search results

Sorry for my repost, but I have the solution now its eiter.. WHERE INSTR(b.Product, a.System) > 0 or.. WHERE b.Product LIKE "*" & a.System & "*" Maybe I could help someone with this..

Hello, I've a short question: I want to write a query that inner joints two tables and updates a specific column based on a description that also appears in the other table. I'm working on the WHERE part of my query here. To show you what I mean: In table A column 1 should be updated with a...

Thank you arnelgp, that was a great help! Learned something now today =) Have a good day :)

Thank you a lot, Cronk! That worked =) One last question: Is it also possible to use your idea inside the exception part of a query? For example, when I have something like this: "...WHERE tblDevices.MaterialID IN (SELECT SNR FROM tblConfig) AND tblDevices.Description NOT LIKE '*#*'" Can I...

Hey community, I only have a short question: I've a table with several columns, one of them is a text field. Within them I have some records that looks like this and have a special character: "AX ELEVATE #O SUPERIOR" As you can see this record contains a special character -> # (hash or...

I will try that later and will come back to you if I've questions :)

Don't be sorry, arnelgp, you're always helpful :) Thank you, I read something about DCount later as well ;) Btw, is it also possible to check a whole list of items? So like if I had a list of systems in my table that I want to update (tblUnitsNewOrders), could I take this list and check the...

Hello community, I'm dealing with a rather small problem at the moment. I want to update a column in my table with a value from a SELECT Count query. But Access tells me that the operation must use an updateable query. The thing is that I don't know how to do it :/. Just to give you an example...

@sneuberg: Regarding the date, I do it like this: strDate = Format(strDateRaw, "\#yyyy\-mm\-dd\#") strFilter = "[SAPNr] = " & Me.txtSAPNr & " AND [AngelegtAm] = " & strDate This works :) If I've further questions I will turn to you ;)

Ah perfect, now it works! :) This method works for me, but thank you for offering that other version to me :) One last question: If I want to add a second filter criteria can I add this with: strFilter = "[SAPNr] = " & Me.txtSAPNr & "[AngelegtAm] = " & Me.txtDate ?

Hey sneuberg, thank you for the start :) I adjusted your code according to my needs: strFilter = "[SAPNr] = '" & dblSAPNr & "'" Forms!frmSnippet!tblFinalOrderSubForm.Form.Filter = strFilter Forms!frmSnippet!tblFinalOrderSubForm.Form.FilterOn = True The only problem is that Access returns a...

Hello community, I've a question: Is it possible to control an embedded table within a form by the use of a button? I created a form that looks like this: When the user enters a SAP number into the text field and clicks the go button some code behind it looks up the SAP number in a table and...

Yes I did, it works how I wanted it :) I also fixed the small issue with the extra parenthesis. It's so cool that you just throw in some code and it works.. I want to be as good as you :D

Thank you a lot, arnelg, you're the master! =) Every time I read something written by you it's like.. ok.. I was on the right track but there's always something I wouldn't come up with :D You're so helpful :) Also thanks to sneuberg for helping as well :)

This is the raw data for the sub query: Then I apply my code SELECT Sum(tblFinalOrder.System_AEMenge) AS Sum, tblFinalOrder.SAPNr FROM tblFinalOrder GROUP BY tblFinalOrder.SAPNr .. to get the results as shown in post 3. So I aggregated the numbers for every SAP number. And now I only want to...

So first I want to calculate the balance for each order number in column SAPNr. With the code from the SELECT part I get this result: Then for every number that has a "1" I want to set the value in my yes/no column "won" to true in my table tblFinalOrder. Do you understand what I mean? :)

Hey community (and a happy new year to all of you), I need your help for a simple problem: I want to calculate the balance for each order number I have in my table. If the result is = 1 it should set the value = true in column "won" (it's a yes/no column). So I've coded something like this...

Thanks for this tip, MarlaC! I created a yes/no column and adjust CJ_London's query accordingly. I figured out that when the query processed one month and set the true values for the numbers it changed then I will write another query that sets every other value to true that isn't true yet. When...

Hey CJ_London, first of all, thank you a lot for that!! That's really a big step in the right direction. I've only one thing to add: Somehow the code must know that an entry was already changed. So every time I execute it it would change the next entry that is not equal. What I mean is: when...

In my table I have 12 sap numbers that appear more than one time. 6240509 appears 3 times and 6231801 appears 5 times. I want to chose 6231801. I attached the Excel file with before and after. Please tell me if this helps you now :)