 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2006Creating a database report
Hello Everyone I am currently doing a course in Business Admin and i have a unit on designing documents. I am required to create a database of a list of 20 guests, that are invited to a conference. Pretty straight forward so far, however out of the 20, 2 wont be able to attended (so taken off the list) and 2 of them have special diertary requirements. I added a column for the dietary requirement no problemo. The question then asks to prepare a database report containing only the 4 that replied! with thier dietary requirements. I have no idea how to do that, i tried using the report wizard and ended up with all the names and no dietary requirement column. I went to microsoft's website and thier tutorials take forever. I would really appreciate if someone would tell me exactly what i have to do. Thanks Since this is part of your class, it would not make much sense for us to tell you how to do it. Selecting specific records to pull to a report is very very basic. If you did not get that concept, then you might need to talk to your teacher. I will give you a hint, selecting specific records is done by using a query and telling the query what to base the selections on. A report can be built off of a query. Hope that helps.  SignatureRick B > Hello Everyone > [quoted text clipped - 13 lines] > > Thanks Thanks Rick i am not trying to get off easy, i did ask my teacher and she didnt provide any help because she doesnt know how to do it either which really sucks! She simply told me to submit my work and then she will see. But i dont want to risk submitting it and failing! Anyway thank you for your help i will hopefully be able to sort it out with the info you gave me. If your teacher does not know how to limit the records returned to a report, I'd get my money back and recommend that the school hire someone who has a basic knowledge of Access. :-) SignatureRick B > Thanks Rick i am not trying to get off easy, i did ask my teacher and > she didnt provide any help because she doesnt know how to do it either [quoted text clipped - 3 lines] > Anyway thank you for your help i will hopefully be able to sort it out > with the info you gave me. I wish i could Rick but its too late now. I am stuck we were never taught how to use Access! That is why i am not getting this and when i did complain all she said is well this is what you have to do so get on and do it. I have managed to get a report with all 20 names, i dont quite get how i can create a query that returns only those records that have the responded colum I have created a column with a Yes/No as Kaltuu suggested however i cant find the Where argument of the OpenReport method I have managed to get a report with all 20 names, i dont quite get how i can create a query that returns only those records that have the responded colum I have created a column with a Yes/No as Kaltuu suggested however i cant find the Where argument of the OpenReport method >I have managed to get a report with all 20 names, i dont quite get how > i can create a query that returns only those records that have the > responded colum > > I have created a column with a Yes/No as Kaltuu suggested however i > cant find the Where argument of the OpenReport method Open a new query and include your table. Drag the fields from the table onto the query grid. In the criteria for the yes/no field, type True. When you run the query it will return just those records with a tick in the box. Use this query as the report's data source. Keith. www.keithwilby.com You will need to add a column for Responded, if you have not already. I would suggest a Yes/No data type field. You will then need to check the check box for that field for those who responded. Then when you open the report you need to use the Where argument of the OpenReport method to limit what is included in your report to only those records where Responded is True (Checked). You can look up the OpenReport method in VBA Help. It will look something like this: DoCmd.OpenReport "MyReportName", acNormal, , "Responded = " & True > Hello Everyone > [quoted text clipped - 13 lines] > > Thanks Klatuu, thanks for replying and helping me out. What you said makes sense and hopefully i will be able to work it out. I will go try it out now and let you know how i go Without doing your homework for you: You will need to create a query that returns only those records that have the special dietary checked and then create a report on that query. >Hello Everyone > [quoted text clipped - 13 lines] > >Thanks Yeah jahoobob i kind of get it now and see what i have to do, thank you for your help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.