Search results

  1. A

    Graph: Variable number of data series

    Hi, unfortuately I have a problem with the data source of a graph in an form. First of all: I am using Access 2013. I have a cross table like this: tbl_crosstable: C_Datum | Company A | Company XY ----------------------------------- 2011 500 100 2012 600 300 2013 700 200 If...
  2. A

    2nd run of a function caluclates wrong results

    Hey guys, i am using the following function in a query: Public Function Progress(ByVal varCompany As Variant _ , ByVal varPercent As Variant) As Variant Static varCompanyOld As Variant Static varValueOld As Variant Dim Value As Variant If varCompany &...
  3. A

    Continuous performance calculation

    Hello, maybe I can not not see the forest for the trees ... or it is realy difficult. I have a table like: -> tblPerformance P_ID | P_Date | Performance ------------------------------ 1 | 01.01.2010 | 1,03 2 | 02.01.2010 | 1,05 3 | 04.01.2010 | 0,98 4 | 05.01.2010 |...
  4. A

    Compare the last two datapoints with 1

    Hello, one more thread of mine today :D I have this table: -> tblTest test_id | test_Name | test_Date | test_value ------------------------------------ 1 | Company A | 01.01.2010 | 0,90 2 | Company A | 02.01.2010 | 0,95 3 | Company A | 03.01.2010 | 1,10 4 | Company A |...
  5. A

    Variable field name in query or table

    Hello, is it possible to name a field in a query or a table with a variable name? For example: I want to choose in listbox "fieldname" the name of the field. And the query field name looks like: forms![testform]![fieldname]: FieldOfTheTable Unfortunately it doesnt work. Also if I save the...
  6. A

    Listbox selection based on a table

    Hello, I need support one more time :) I have a form with a listbox that allowed multiselection. The listbox depends on the field "name" And I have a table "names_should_be_selected" (fields: name, date ...) It would be great if alle names in the listbox are selected when the name is in...
  7. A

    Call a Function via control element in SQL

    Hello, is it possible to call a function in a query with the input of a control element? I have a form, and there is a list box in which I can choose the calculate method. In the query, a field should calculated with the choosen function. Example: SELECT tblTest.price, tblTest.Date...
  8. A

    Find the recent available data based on the dates

    Hello, I already asked this question in my last thread, but unfortunately it was overlooked because the topic question was solved. Anyway, sorry for double posting. I have a price table: tblPrice PosNr PriceDate Company Price 1 01.01.2014 Firma A 5...
  9. A

    Speed up this Query

    Hello, I have this query: SELECT A.PosNr, A.PriceDate, A.Company, A.Price, (SELECT TOP 1 B.Price FROM tblData As B WHERE B.Company= A.Company AND B.PosNr < ( A.PosNr - 364 ) ORDER BY B.PosNr DESC )...
  10. A

    Import from Excel (variable ranges)

    Hello, I am trying to import data from an Excel file to MS Access (2013). The Excel sheet consists of 700 columns. A group of 7 columns (always same header) are to be implement in Access one among the other. That means: At first columns A-G, than columns H-N, than columns O-U I am trying to...
Top Bottom