Search results

Hi, I have a combobox that I want to fill its value dynamically. I write: if ........ then combobox1.rowsource="Select specialist from table1" elseif combobox1.rowsource="Select specialist from table2" endif but when I run the form, the combobox value is the SQL statement, like (Select...

Hello everybody, I had made a report based on a query last year as bellow, but I don't remember how did I sort the results by "Totally"? TRANSFORM Count(ID) SELECT specialist,Count(ID) AS Totally FROM projects GROUP BY specialist PIVOT main_firm; The results are sorted by Totally...

Hello everybody Lets suppose we have Table: products (As Attached) I wrote the following query: TRANSFORM Count(prod_ID) SELECT seller,Count(prod_ID) AS Totally FROM products GROUP BY seller PIVOT color; It gives "Query1" result (As Attached) Now, How could I get "Query2" result...

Hello I have a database which would be used by 15 users via network. Unfortunately network admin has disabled sharing system on all domain computers. There is just one pc in the network which all users of this department (15 users) could share files with it. USB drives are also disabled except...