Recent content by mfaisal.ce

Dear All, I want to make a query but cant able to do that, plz help..... I have 2 tables and i want to make a query to sum values... Detail: Sales Table SNO BID 1 222 2 555 3 333 4 222 5 333 Payment Table PID SNO Total Paid 1 1 1000 500 2 3 500 200 3 4 900...

this is code, how i can use DoCmd.OpenReport ReportName:="RPTSheet_Daily", View:=acViewPreview, wherecondition:="[Dated]=#" & Format(InputBox("Enter Date"), "yyyy-mm-dd") & "#" Where i can use datetime picker......

plz guide, how

Dears, I want the user to input date by datetime picker .... kindly guide me how i can do that, example input("Enter Date Here") When i use the above code, prompt comes for getting the value but i need datetime picker, like a normal textbox in runtime mode... regards,

thanks a lot....

thanks a lot .... it worked....

This is not possible in Query statement??

Dears, i want to make a query with a criteria based on value of Field.... Table: Purchase Field. ID Field. Balance I want to make a query in such a way that 1. Balance =0, output 0 2. Balance >0,output 1 3.Balance <0, output 2 Kindly guide....

Hi every one, I have a report and i have a field Name "Balance". I want following conditions on group level 1. Balance =0 2. Balance >0 3. Balance <0 How can i do that? Plz guide.... regards,

it worked.... thanks a lot.... but i used a trick before your reply, i make a fake DateField and used master child relationship and passed parameter to DateField at Report open command.... thanks all....

There is no master child relationship between main and sub reports but i need to show multiple sub reports on one page by date filter... each subreport has Date field, so i want to show the subreports data based on date....

Dears, I have a Report with 02 subreports. how can i filter the subreports all in one... , means normally if i have to open the report with filter option, where clause is used but how to filter multiple subreports once... kindly guide.... regards,

Hello everyone, i have unbound text box in report; i need to show multiple values from a table into unbound text box... For single output , dookup is working but i have to show multiple records into unbound textbox... kindly guide me how i can do that.... regards,

Hi every one, is there any way to combine two different from two different tables into one column.....; example t1:a1 t2:a2 what i need is, t3:a1+a2 how i can do that...

thanks bro, its really easy & simple....