Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 24th, 2006, 02:08 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default Report Brainstorming


 Hi,:)

     I am trying to run an report in the following table pls give me an idea ..!

  I am having an table like :
    Name of the Employee , Personal Computer, Laser printer , Imkjet printer , Scanner , UPS ect . and i have allready generated the report using query as form Employee name & by the Equipment ament name but now i want to take the report by the above mentioned datawise ..

   The problem is all the employee won't have all the equipments . some ill have laser printer by not inkjet .. just like that .. so what i want to generate is if an employee is not having an equipmet it should come blank & the report should generate for whole employee's .. Iam trying with me but any idea will make me easy & gaining ..

 Thank in Advance ,
pap raguv..
Reply With Quote
  #2 (permalink)  
Old February 24th, 2006, 12:01 PM
Friend of Wrox
 
Join Date: Dec 2005
Location: , , .
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can you give us an idea of what fields are in the Equipment table? Aside from that, the way to assure all employees are listed regardless of whether or not they have equipment is to use a left join instead of an inner join:

Employees LEFT JOIN Equipment ON Employees.ID = Equipment.EmployeeID

Reply With Quote
  #3 (permalink)  
Old February 25th, 2006, 01:15 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Ok i ill explain
 I got an table Employee Name , Room No. , Name of the Equipment (Personal Computer,Scanner,Laser Jet, Inkjet & Laptop), Make , Model , Remarks.
 And i have generated the Report by Employee Name wise & Name of the Equipment Wise . Now i want to generate as Employee Name , Name of the Equipment ,Remarks (i.e) when i generate the report first NAme of the Employee follows with Personal Computer ,Scanner ,Laptop and Below this Equipment the Make & model as to come and if some body is not not having the Equipment the that place should be blank..
  Did u understand if not just give me an reply i ill explian u.

 Thanks for ur reply..

Bye,
pap Raguv
Reply With Quote
  #4 (permalink)  
Old February 27th, 2006, 01:57 PM
Friend of Wrox
 
Join Date: Dec 2005
Location: , , .
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It sounds like what you want to do is generate a report, in which the Sorting and Grouping is based on Employee Name, and then Equipment Name. To do that, create a report and add all the fields you need to it. Add Employee Name, and Equipment Name to the list in the Sorting & Grouping window, and make sure both have their own header. Drag the fields for those two into their respective headers, and you should be good to go.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
simple report and crystal report in vb.net saket123 .NET Framework 2.0 0 August 13th, 2008 06:55 AM
reset links main-report to sub-report from c#.net epanyun Crystal Reports 0 April 18th, 2008 02:41 AM
brainstorming doubt anukagni Access 4 May 5th, 2006 01:34 AM
Login fail Err when view report on Report Server dillig BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 July 22nd, 2004 05:31 AM
How to load a Web Server report into a Report Doc dshadle Crystal Reports 3 September 30th, 2003 03:47 PM



All times are GMT -4. The time now is 09:09 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.