Search results

Doesn't matter what are you saying, it's just an exercice for my school. A real example. So the thing is how to reasign a value to others in the same field. The entries are about 30-40 more less, and this have to be automatic, not manual. Thank you sir.

Thank you The_Doc_Man you are right and understand what is my problem. When I say lower versions is because these ones have to be a license asigned with the high versions surplus licenses. For example the number 39 comes from : 54 + (-6) +(-5) +(-2) + (-2) = 39 That have to be like that because...

Good afternoon Access guys!! I have a problem with something. The next table shows the "Posicionamiento" of some software products (Posicionamiento = Licencias Adquiridas - Consumo) The next step is calculate "Compensación" and what I need is this: Licencias Adquiridas always will be in...

Hi, Table name = Extraction Field names = Product_Name & Device_Name I don't have primary key. I need to do it regularly but i know how to do it with macros. The thing is how to get the right query to delete the registers that are old version.

Hi good morning :D I need to remove registers with an old version (products). But depends on each device. Here an example: DEVICE_NAME PRODUCT_NAME A11234 Microsoft Project Professional 2019 A11234 Microsoft Project Professional 2010 A11234 Microsoft Visual Studio Standard 2013...

Thank you sir. But, which is the meaning A and B. are registers? Kind regards

Yes, always in a right position

I need to remove the registers with an old version

Nice to meet you all. I need to elaborate a query that is capable of removing products with an older version if a larger one is detected. For example: Microsoft Project Professional 2010 Microsoft Visual Studio Standard 2019 Microsoft Project Professional 2012 Microsoft Visual Studio...

As I said, i have no idea, i don't undestand what you are telling me. But thanks i supose.

Good afternoon. I need to make a Macro with different buttons (Project, Visio and Visual Studio), something visual and easy to execute . I will explain better. My client need to check how many softwares are deployed in her factory. I already got every query, joins and normalized my tables, I...

thanks, i made what you said, but there are some registers that disappear (just 3 registers), but i don't know why. I think in this way works, but some suggest about this

Thank you, but it's too difficult for me right now. But thanks

Thank you so much The_Doc_Man, it works very well. But now i have another question. If i have the next table: ID PRODUCT NAME 1 Windows Professional 2016 - us.es 2 Windows Office Professional 2019 3 Windows Profesional 2019 4 Windows Professional 2016 - en.proof Now i want to remove...

Bro, sorry but i'm very noob in access and sql. Firstly i have to execute the the first code and then the second? I'm a little bit confused. Isn't in my Sql view i think?

Why doesn't detect the string? It wants to update whole my rows. I don't know why?

Yeah it's a nice solution, but not necessary for my case, because these are some of example. I have another registres that have more lenght than 5, so what can I do? For example: Microsoft Professional 2019 - en.us-proof Microsoft Professional 2019 - en.en .... Please help :D

In the same field bro, first name and last name are different fields I need to doit in the same.

Thanks via-php. So what you are telling me is make different querys and updating my data base query by query?? I didn0t understand how to code the solution

I already done, thanks bro :D