Good day to all the problem that I have is a table with the following info
COMPANY PRODUCTS
AAA A,B,C
BBB A,C,D,F
CCC D
DDD F,G,H,I,J,K,L
and I would like to see if it can be saved with some code in the following way:...
I have this query in access, but I can not sort the Format ([DateCob], "mmmm") by the order of the months, they are sorted by alphabetical order (April, August, December, etc.) and I want it by order of months (January, February, etc.)
This is m...
I test this in Access 2013 and says there is an error, but it does not specify which one.
SELECT DISTINCT factura.n_factura, factura.data, factura.import, factura.concepte, departament.nom, programa.nom, despesa.nom, emisor.nom, destinatari....
I am developing a project, which under the circumstances my only option is to use access, but I have encountered this problem. I do not know how to store an image and read it from an Access database.
I have looked in forums that indicate that wi...
I have a Access Database in which I look for registered users
When I perform a search, it generates results, when I click to see the information, it does not generate any of the information I added.
This is the macro that executes...
I am trying to add the values that return these two queries in MS Access , and I receive the error
"Syntax error in FROM clause"
I have already tried in many ways to achieve the sum of these two queries, someone could tell me w...
I have a Database in MS Access 2016 with a Path to export Queries to Excel. However, sometimes I must work on other computers, so I need to define a permanent Route for my Database.
In the lines of code below, the first route works wel...
My problem is that I am making a database in Access, it is very simple, it only has the tables of Students and Courses, linked to each other, so that the courses group the students. My problem comes when a student changes course, how could I kee...
Hi, I'm trying to fill a datatable in php but I can not do it, this is what I have:
driver
public function VentasXvendedor(){
$IdVendedor= strtoupper(utf8_encode($_REQUEST['IdVendedor']));
$arrayCli=array();
$dat...
I'm having a problem that brings me headlong. I have a TELEPHONE table in Access with the columns Prefix_provider and Prefix_client. I need (preferably with sets) to find Provider_Prefixes that are never Client_Prefix. Any ideas?
This is what I...