Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 1994mkiv

    How to suppress the record

    The thing I don't understand is since balance is calculated field and the result is coming in GF how would that suppress the GH.
  2. 1994mkiv

    How to suppress the record

    Three step process GH: initialized balance:={onhand} Detail: balance:=balance-{qty used} FG: Print balance
  3. 1994mkiv

    How to suppress the record

    Here is how my report currently looks like: Group Header: Part # : ZZZ OnHand qty: 100 Detail : Job #1 (qty used) 25 Detail : Job #2 (qty used) 15 Group Footer: Balance: 60 what I would like to do is suppress...
  4. 1994mkiv

    Deleting records in Table

    Thank you, it worked like a champ
  5. 1994mkiv

    Deleting records in Table

    Error Again "Could not Delete From Specified Table" Thankyou for keep looking at the code
  6. 1994mkiv

    Deleting records in Table

    There is an error in the qry "Specify the table containg the records you want to delete
  7. 1994mkiv

    Deleting records in Table

    We have 2 tables LaborHed and LaborDtl. LaborHed contains EmployeeNum, ClockInDate ans some other info. LaborDtl contains EmployeeNum, ClockInDate, JobNum and some other info. Example of LaborHed: Example of LaborDtl: To show the records the qry I wrote is : SELECT PUB_LaborHed.EmployeeNum...
  8. 1994mkiv

    Making charts from Calculated Values

    Thanks lbass for pointing me in the right direction. Unfortunately the technical paper give the solution for CR 9 and higher and I am on 8.5. The good thing is I did able to solve the problem and here is what I did. *-Made some shared variables and pass the calculated values to them in report...
  9. 1994mkiv

    Making charts from Calculated Values

    I am making a report to calculate the "# of parts in stock" vs "# of parts not in stock". Overall the report is complicated because I am calculating some values in subreport and then passing the values to main report to make the decision. *- The main variables are defined in the main report...
  10. 1994mkiv

    How to upade the table

    I am sorry I am really new to the access. Where do you write the sql quires in access.
  11. 1994mkiv

    How to upade the table

    I have some old open orders in the database that I would like to close. The way the table is design the value is 0 if the order is open and -1 if the order is closed. I want to close all orders older than 1/1/2004. Can I update all records by using the query?
  12. 1994mkiv

    Grouping Question

    I am working on a paycheck report and the report has to be grouped for each 2 weeks. I set the grouping and everything is working correctly except CR is grouping wrong weeks. CR might be grouping week 1 and 2 together but the way my company payroll works it has to be 2 and 3 together. Can...
  13. 1994mkiv

    Cross tab grouping question

    The names are PODetail.PartNum, PODetail.OrderQty, PODetail.UnitCost and POHeader.OrderDate Thanks for looking lbass
  14. 1994mkiv

    Cross tab grouping question

    The only thing I wrote was select table."UnitCost" from table and I verified from database->show SQL query about the punctuation The error I am getting is ODBC error: [DataDirecrt-Technologies][ODBC PROGRESS driver][PROGRESS]Syntax error(7587)
  15. 1994mkiv

    Cross tab grouping question

    Never used the SQL expression before, When I create a new SQL expression and even just save an empty screen it's giving me ODBC error, is there something I need to define in CR before start using SQL expressions.
  16. 1994mkiv

    Cross tab grouping question

    I am thinking about making this report in a cross-tab. So each row will be part # and each column will be order_qty. What I want is to group the order_qty in a way that it will count all the part ordered on a same price and make column and put price in summarize field. So the report will look...
  17. 1994mkiv

    Modifying forum in vista 6.0

    I need to change the existing production forum and like to add couple of new fields (date and a check box). I still like to use the existing table but will connect both of these fields to empty spaces in the table. Can somebody tell me how it can be done. Thanks
  18. 1994mkiv

    Cannot calculate Sub-Total

    Posting the pic for better answer. As you can see the report is grouped by week then Dept then Employee ID. The second column is subtotal of the employee hours for the whole week. I used the function for the third column to calculate the over time which is If sum({employee.payhour}...

Part and Inventory Search

Back
Top