deadlyhunk
Last Activity: Mar 5 '07, 03:45 PM
Joined: Nov 30 '06
Location:
-
Thank you for ur comments. I have got the reports to be generated.... -
I don't think I can put combo box for the year because the reports are for future use. What if we have two textboxes for the datefrom and dateto and have 2 command buttons for month and year. So, once we enter say 1/1/2003 - 1/31/2003 and click on the month button it should give the report for that month calculating the sum of amount and same is for the year. Here my problem is I am able to generate the report monthly and yearly but I am not able...Leave a comment:
-
Is there anything that I can do with the reports? I tried in various ways but could not make it up.Leave a comment:
-
As you said I have removed the field and now when I execute the query it was successful. I have created the report based on this query I mean in the report's recordsource I have given the name of this query. Now when I run the report it prompts me asking for the amount and date_check_rcvd .
And one more thing I want the report in such a way that it should prompt me saying that which month for monthly repports and which year for yeraly...Leave a comment:
-
So, Do I need to remove the field in the query?...Leave a comment:
-
when I run the query it gives an error saying duplicate output alias "TotalAmoun t"...Leave a comment:
-
I don't think I can do that because I want all the fields in the report....Leave a comment:
-
The field is nothing but the date when the check was sent.Leave a comment:
-
I even tried the code given by ADezii but it prompts the same msg saying "enter the parameter value date_check_rcvd " and also when I run the report it asks me to enter the amount,date_che ck_rcvdLeave a comment:
-
My reply is for the post given by mmccarthyLeave a comment:
-
Thank you for the reply.
I am sorry in my previous post I forgot to mention other field i.e., Memosent which of data type date/time. Now when I run the query you have given me in the post it prompts me the message saying " enter the parameter value Memosent". When I click ok on the message then the report opens.Leave a comment:
-
Reports
Hi,
I have a table which contains the fields Empid, Empname, Amount, Date_check_rcvd . Now my question I want to generate a report which gives the sum of amount by month and by year thru the date of check recieved. I have a problem in writing the query where if I say sum(amount) and execute the query it gives an error saying " you tried to execute the query that does not include a specified expression Empid as part of aggregate... -
Reports
hi,
I have a database in MS ACCESS 2000 in which I have a form with 6 fields. For this form I need to generate monthly and yearly reports. For the monthly reports I want to generate the report in such a way that when the user clicks for monthly option it should be able to give the month report for example if we want the report for january it should give the whole report for the january and if the user wants the report for january 2005... -
Thank you so much for helping me out. I never thought that this will be very simple.
Once again thank you so much...........Leave a comment:
-
I have tried as you said but when the pop up form opens it just opens with the Id ,it does not give the details on the pop up form related to that Id. Wht I should do for this?Leave a comment:
-
Hey I am sorry I was bit confused between the forms. As I mentioned it is a main form and subform I was wrong in that. Actually my database contains a form in which I have command button by clicking on it a pop up form opens up..so, i wanted the details to be populated in the pop up form with the field ID on the main form.Leave a comment:
-
I understand what you are saying but as I said I have created the subform using the icon "create a form through wizard". I haven't created using the subform wizard. So, now what do you suggest me for this?Leave a comment:
-
thank you for the reply. as you said i will just go with one field so that it can populate the related fields in subform.
And also i don't find any linkchildfield and linkparentfield in my subform as i hv created the form through wizard and attached it to the command button onclick() event. i just wanted to know how we write the code in order to call the details for subform with the main form ID field.Leave a comment:
-
Populating subform
hi ,
I created a database using Access 2000 with 2 tables and 2 forms. one is main form and the other subform with ID and Name as common fields. I have a command button in main form which is used to open the subform. Now my question is whenever I enter ID or Name in the main form and then click on the subform it should give me the whole record in the subform which is related to the ID or Name in the main form. I am able to open the...
No activity results to display
Leave a comment: