Search results

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...

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...

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...

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. :)