Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 03-09-2015, 11:09 AM   #1
Newly Registered User
Join Date: Mar 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
gibbons1984 is on a distinguished road
Trouble with generating specific reports

Hi i am new to Access and databases in general. My problem is, i am using SQL server 2008 and Access together and i have created all the tables for a fake hotel booking system, i'm not sure if its a fairly simple problem or whether my tables are designed wrong i just can't seem to get my head round it. The problem is i need to generate 2 reports for this:-
1) A report which shows how much income each room type generates
2)A report which shows available rooms on a specified date.
Attached are my tables and relationships between them. Any help at all would be greatly appreciated. Kieran
Attached Images
File Type: jpg Tables.jpg (49.4 KB, 67 views)

gibbons1984 is offline   Reply With Quote

access , reports , sql 2008

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating Quarterly Reports wakeuky Reports 6 10-11-2012 09:17 AM
Generating Invoices With Reports thegooser Reports 5 11-22-2010 04:26 PM
Automatically Generating Reports Infamous Flame Reports 0 09-17-2007 12:24 PM
Generating a Report from a specific part of a Form - BarCode OneFire Forms 3 09-01-2007 05:30 AM
Generating reports in html jaddison Reports 0 08-26-2001 07:26 PM

All times are GMT -8. The time now is 06:12 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World