Search results

  1. B

    query working in test db, failing in real db

    Hi, got a query which works in a test db, but fails in the real db. The SQL of the query is: SELECT a.LG, a.dat, a.[anz-schl-], a.RMNR, a.[PB-DAT], a.STATUS, a.KST, a.E3, a.E4, a.LIEFERANTENNR_8, a.LIEFERANTENNR_9, a.LIEFENAM, a.ARTID, a.ARTIDX, a.ARTDESC1, a.[tech-entsch], a.merkmal1...
  2. B

    Round function in A97

    Hi, how can I round the result of a calculation in A97 ? There seems to be no round-funktion in my German A97, so ppm: ROUND(1000000*[s_schl]/[s_gel];0) doesn't work in the design view of a query; instead I only get an error message "undefined function 'ROUND' in expression". Thanks in...
  3. B

    printer dialog box

    Hi, got a form on which I created a print button via the wizard. The button works, but it prints the report without the printer dialog box appearing. What must be changed in the code created by the wizard to make the printer dialog box appear ? I've searched this site already but found no...
  4. B

    RunTime: Custom Format VS. function

    Hello, what's faster: "Custom Format" in the Design View: VIEW, then PROPERTIES. setting for example "YYYY" or the built in functions: funtions that will return part of a date. i.e. Year([Field containing DOB]) ,...... when 'manipulating' dates ? (I deal w/ tables w/ 300 000, 20...
  5. B

    Group and THEN select Top records

    Hi, is it possible to Group and THEN select the top records from a table ? I got a tbl like this: Group....Month....Prt-No....Qty a..............Jan.......a1..........1 a..............Jan.......a1..........2 a..............Jan.......a1..........3 a..............Jan.......a1..........4...
  6. B

    Faster Queries by setting relationships between tables

    Hi, I've already searched the forum for this "newbie question", but I found no answer to this. I'm wondering if queries run faster if I set relationships between the used tables via the menu ("extras", "relationships") or in the queries (in the design view by pulling one field on the other and...
  7. B

    Find record with maximum in one field

    Hi, tried to find the records with the maximum in one field. Got a table like this: month…invoice…..qty Jan……..123………55 Jan……..124………76 Jan……..125………344 Feb…….126………865 Feb…….127………744 … The result of a (simple) query should be: month…invoice…..qty Jan……..125………344 Feb…….126………865 …...
  8. B

    page break from sub-report

    Hello, got a sub-report with a page break. If I run just the sub-report, the page break is shown; but if I run the main report, the is no page break. Do I have to enable page breaks from sub-reports in main reports ? TIA, Barbarossa II
  9. B

    Using Parameters in other Query

    Hello, Is there the possibility to use the parameters of a parameter query as criteria or in an expression of another query ? For example I got a query >MyQuery1< and a 'column' >SearchedColumn< with the parameter-criteria >[MyCriteria]<. Can I use the result / the value of >[MyCriteria]< in...
  10. B

    Special 'aggregate' query / "Second"-function

    Hi everyone, need a special 'aggregate' query. Got a table like this: PrtNo..... txt 1.............txt1 1.............txt2 2.............txt3 2.............txt4 2.............txt5 3.............txt6 A query should return: PrtNo..... ALLtxt 1.............txt1_txt2...
  11. B

    run query, form, report from 'outside' db

    Hi, I wonder if there is a way to run a query, a form or a report from the 'outside' of the db via a special command (in a batch etc.). Thanks in advance for your help, Barbarossa II
  12. B

    Transform m:n-matix into n:m-matrix

    Hi, is there a way of transforming a m:n-matrix (a table in my db) into an n:m-matrix (result of a query) ? The query should diplay its elements Q_ji pulled from the table elements T_ij in a way that Q_ji equals T_ij (with i=1..m and j=1:n). For a better understanding of the query, the names...
Back
Top Bottom