Search results

  1. F

    Add query data to existing export function

    Hello I'm trying to add some data to an VBA-export function I created a while ago. Basically I need to add the data from the table Stik_Samling to the bottom of my first export function with OpenRecordset VBK_Knude. However I've run into a few issues, the number of columns in Stik_Samling can...
  2. F

    Solved Use query with subquery, to run an update query?

    I'm trying to update a tables in access database column based on a query that I've shown below. I keep getting an error saying "Operation must use an updatable query." I have one standard select query before the one shown below, which I believe is the culprit. The subquery that counts and gives...
  3. F

    Solved Add result from one function to another export function

    I have a VBA-function that currently joins two queries and finds the XY in sequence between two and exports it in a seperate file (export not shown). I also have a different function that exports a table in a very specific format needed for it to be importable in another program. Instead of...
  4. F

    Iif query returns duplicate rows with null data

    Hello I'm trying for each ID to get the PIl_TXT, DIM_TXT, FRA_TXT and TIL_TXT. I'm trying to pull the values using an Iif function in the query. However I know I'm doing something wrong, as I'm getting 8-10 rows (with Distinct and without Distinct), where the expected output should be 2 rows...
  5. F

    Solved Export Query to txt where each row of data comes in groups?

    Hello I have a pretty basic data setup, where the end query looks like the data in the table: $NODE XY Z_F Depth OB POST HTYPE UTYPE LTYPE ENTREPRISE STATUS DIMENSION STATION PERPEND CATCHMENT Q A_KOEF ANM Owner TEXTXY DK_TXT '01' 6200000;454545 40.10 1.20 0.70 '1.1.2' 'KO' 'Well' 'KO'...
  6. F

    Count number and multiply with field value

    Hello I'm trying to do a Total query, that is calculating the cost of building certain systems. Right now I'm just trying to count the number of Nodes and multiply that with field UnitPrice, to find out how must the cost of nodes is based on their size (the sum of all the money spent on 1 meter...
  7. F

    Rank query returning same rank

    Hello I'm trying to Rank my column SKU by lowest price. I have set up the query as described below. However for two items with the same price, it returns the wrong rank. Example where two items have the same price, it should be ranked 1, 2 (don't care which one of the two is first). But...
  8. F

    TransferSpreadsheet with prompt for file location

    Hello I'm trying to Export 2 queries into one Excel file, in two different sheets. I can get this to work, by calling the below code in a macro. Public Function Export2Queries() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Concatenate"...
Top Bottom