i need help creating database and queries

[MAdSci]

i need helpppppppppp badddd

[burrina]

You have not explained what problem it is you are having?? We are not mind readers here. In plain English, describe what it is you are trying to do and why! Examples.

[MAdSci]

You have not explained what problem it is you are having?? We are not mind readers here. In plain English, describe what it is you are trying to do and why! Examples.

I uploaded the question paper and I re uploaded the database I created for it. I need help with question with question 6. How do create the report that does what the question ask?

[MAdSci]

I am trying to upload the latest database but its not uploading

[burrina]

Follow the instructions: Remove confidential info, compact, zip. Click on Go Advanced, Browse, upload and Post.

[MAdSci]

this is the updated version please can some how help me create the report to perform the calculation

[burrina]

I will look at it and see if I can help.

[orange]

There is a free data model at http://www.databaseanswers.org/data_...cies/index.htm

that should help with your design.

[burrina]

This forum is not here to write your database for you, but to give you direction and assistance so you can learn and improve. With that said, here is your db with what I think you are asking for. See qryGHEMonthlyReport. You can create a report yourself if this is wht you want, if not, it should at least get you started.

Good Luck With Your Project.

[MAdSci]

I appreciate the help and I know that no one is gonna do it for me so I must get some credit for creating the database etc and doing the other question I have drafts here of the report but I don't know how to make a calculation in the report to check the sum as what the question asked

[MAdSci]

oh btw the database I have there is fake data so no worries

[burrina]

= SumAmounthOutstanding in an unbound textbox in the report footer.
Additionally, consider your naming conventions for your tables, forms, reports and such. Please do yourself a great favor and do some research on basic database structure, this will help you immensely in the future. Exampl; tblAgent qryGHEMonthlyReport, frmyourformname

Hope this helps. Good Luck.

[MAdSci]

I was looking around for help an I got this from a friend with there version of the report


can anyone explain how did they do this?