Search results

I have found the solution for my problem. This is the steps: - Create a select query (name it q_combine) to combine the handle_type and kernel_type columns as one. SELECT blockname, [handle_type] & [kernel_type] AS hk_combination FROM table; - Create a crosstab query to show the count value in...

I have a problem to count a multi columns into one field. For example, I have a table consist of these fields (simplified version): - id - block_name - handle_type (lookup: big and small) - kernel_type (lookup: big and small) - fruit_set (lookup: 1, 2, 3 and 4) I want to create a query to count...

Thank you so much for the reply. :) I am not sure :o, but I try to practice the best of normalization that I know. To make it clear, this database is about fertilizer for each block of plantation. So I had to use several queries for each purposes, which is needed for another. For example...

I have a report based on query with some calculation (sum, avg, division) which is also based it from another calculated query which is also from another query. When I want to preview/load the report, it takes more than 10 minutes. :banghead: Is there a way to load or format the report faster? I...

Thanks for replying. :) I have succesfully solved the problem, by using different way. I am creating a several Crosstab Query with this :TRANSFORM Count(table.n_status) AS CountOfn_status SELECT table.plantationid, table.yop, "N" as nutrientname FROM table GROUP BY table.plantationid, table.yop...

As an alternative (depend which one is the best), maybe someone could share the way to combine all the crosstab query (that I already create for one nutrient) into a single table.

I have table with these fields: id plantationid sampleno yop n_status p_status k_status mg_status All of the nutrient status fields above (n_status, p_status, etc.), consists of these values: Def Low Optimum High Excess I want to create a crosstab query with this structure (column) and...

Right now, I am developing a database which will be connected to maps collected from MapInfo or ArcGIS. I want to know how I can connect my DB into the maps, so users can select the area within the map in Access and show connected data related to the area shown. Or maybe other easier method. I...

Relate to the password, do you want to build a fix password or dynamic password for each user? I prefer dynamic one. For this, pls make user table where you can keep the dynamic password for each user. If you like you can also make another table for group level security (eg. administrator...

I have figure out the way to do this, still in my head though. I'll try to write down the code. After opening DB by using Shell command, the centralized DB will write down the active username in TXT file. Then the new DB will try to find out the active user name from the given TXT file.

Thanks G37Sam, but still that is not what I am looking for. Thanks anyway.

Thank you so much for the reply. I am so grateful, but still I have no clue how I can transfer the username between the databases. I can't join the databases into 1 database, because each database consist of massive data, so I'm afraid it will reach 2GB limit in very short time.

Hi, I have a problem in my current project. I have several databases link to one central database. I want to build a user level security by using User Name table in one database. I have built the login form and it worked in the central database, but how to transfer that user name into another...

Hi I am new here, I'm joining today but I've visit this forum for some time to read several interesting and resourceful threads. I think this forum is one of the best forum related to Access, where so many times gave me solutions when I have trouble developed my project. I come from Indonesia. :)