Creating a database report

U

UmHadeel

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
 
R

Rick B

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.
 
K

Klatuu

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
 
J

jahoobob via AccessMonster.com

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.
 
U

UmHadeel

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.
 
U

UmHadeel

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
 
U

UmHadeel

Yeah jahoobob i kind of get it now and see what i have to do, thank you
for your help.
 
R

Rick B

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. :)
 
U

UmHadeel

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.
 
U

UmHadeel

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
 
U

UmHadeel

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
 
K

Keith Wilby

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
Click to expand...

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
 
Top