Search results

Hi Spikepl, I had tried to work on the macro as I got stuck with VBA code. Below is the code which I have so far. I am facing a error .i.e. Run-time error '3061': Too few parameters. Expected 1. in the below code: Private Sub Commandbutton_Click () Dim rst As DAO.Recordset Dim CustomerID As...

Hi All, I have form in one of my mdb file which gets opened automatically when I open the mdb file. Now I have two combo boxes on that form first one is Region and second one is country and then I have command button to print. The first combo box gets populated with regions like USA, Asia...

Hi All, I have access database with a form which gets open directly when I open the file. The form has two Comboboxes on it to select the parameters once we select the parameters we can click on the print button and then it opens the report is preview and then we need to hit ctrl + p and print...

Hi DCrake, Thanks a lot for your reply, I have created a separate query using the Avg query which was posted by you. It's working fine but can we use both of them together .i.e. can we combine both the queries .i.e. avg and add query or atleast can we use the output of add query and then...

Hi DCrake, Did you get the chance to look into the above post. ? Thanks a lot for your help in advance.:)

Hi DCrake, Thanks a lot for your reply I will be adding two categories. .i.e. Amt of L1 "ABC" and "IFA" on the basis of date. For e.g. L1 Column has different categories from which we have "ABC" and "IFA" reflecting multiple times and that two for the dates between 11/25/2010 to 11/29/2010 for...

Hi DCrake, Thanks a lot for your reply, It seems to be working fine now but can you please also look into my other issue where I am adding two categories data first and then calculating the average from the total of the same. Please have a look into the attached workbook. Cell H7. Below is...

Hi All, The query which was posted by DCrake is not working as per my requirement. I think there is misunderstood my issue. So I am attaching a excel file with the calculation which I need to do in the access query. I would request you guys to look into the attached excel file in order to...

Hi DCrake, Thanks a lot for your reply, I have incorporated the code it seems to working fine now but can you please help me with the below as well Thanks a lot for your help in advance.:)

Hi Brian, Thanks a lot for you reply, I have tried below but still it's not working. SELECT mydata.L1, mydata.L2, mydata.Retx, mydata.Prd, mydata.[As of Date], Avg(mydata.Amt) AS AvgOfAmt FROM mydata GROUP BY mydata.L1, mydata.L2, mydata.Retx, mydata.Prd, mydata.[As of Date] HAVING...

Hi, I have checked both the links and I have tried to do whatever was mentioned in the same but still doesn't work. Can you please have look into my file. Attached is my file for your reference. I selected avg in the dropdown as suggested by you and entered the below line in the criteria...

Hi All, I want to come up with a query in which will find the average between two dates. Below is the data sample which I have : L1 L2 Retx Prd As of Date Amt ABC XYZ AFX XXF 11/29/2010 112123 IFA SDF BBS STR 11/28/2010 112841 SFS FDS KBS SDF 11/27/2010 154422 SLS SDR KSS SLF 11/26/2010 164222...