Hi,
In the first sub report create an formula
WhilePrintingRecords;
Shared numberVar num := 0;
if somecondition then
num := 1
In the main report create a formula
WhilePrintingRecords;
Shared numberVar num;
place this formula below the section where the sub report is placed
link the main...
Hi innu,
create an view based on u r original query i.e
select * from cars, carcolor where cars.id = carcolor.idcars
Use the following query to get the desired result
select count(*) As rank, v.car, v.carcolour from viewname v, viewname v1 where
v.car + v.carcolour >= v1.car +...
Hi digital_dude,
The following query will solve u r problem
SELECT tdata.output_id, t_data.output_id
FROM t_data AS tdata INNER JOIN t_data ON tdata.input_id = t_data.output_id;
Hi roddy,
I hope the following code will help u
Dim CBarMenu
Dim CBarCtl
'Menu
Set CBarMenu = CommandBars("MainMenu")
'File Menu
Set CBarCtl = CBarMenu.Controls("File")
CBarMenu.Controls("File").Visible = True...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.