Search results for query: *

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.

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

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

Thank you, it worked like a champ

yes they are

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

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

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

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

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

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

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?

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

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

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)

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.

I am using 8.5

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

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

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