Search results
-
P
Reassign values to other records. Make up for.
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...- pawson
- Thread
- Replies: 6
- Forum: Modules & VBA
-
P
Query to delete registers.
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... -
P
Goodmorning everyone. Query Question
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... -
P
Help. I need to make a Macro for my client.
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... -
P
I need to rename differents rows in the same field, but names are different.
Hi everyone I need to rename a list of softwares that are incorrect like : - Microsoft Professional 2019 - es (Remove -es) - Microsoft Professional 2016 - us (Remove -us) If it's possible to do that in just one query, but the program doesn't accept different UPDATE and SET in the same query...