Recent content by 1994mkiv

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)