Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle 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
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 8th, 2005, 04:38 AM
Registered User
 
Join Date: Dec 2005
Location: Leeds, West Yorkshire, United Kingdom.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Database Help

I have a form that enables users to input data to a certain number of tick box fields, i then have a query that collates 5 tables into one. I now need to have create a form which has all the fields used previously blank, still as tick boxes mark off the ones you need then it needs to produce a report of all the fields that have the same boxes marked.

ie.

I have a table with all makes of car
i have another table with all colours
then anonether with all tyre sizes

i run a query that links the makes of car id all together and gives me a list of all the cars that have the colours and tyre sizes together.

I now need to run another form that alows me to choose the tick boxes i want and produce a report for all data that matches.

Please help

ta

  #2 (permalink)  
Old December 8th, 2005, 05:54 AM
Authorized User
 
Join Date: Aug 2005
Location: Vathiyur - Kanchipuram, Tamil Nadu, India.
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
  To use in this query

 select a.car_fieldname, b.color_fieldname, c.tyres_fieldname from car a , color b , tyre c where a,carid = b.carid and b.car_id=c.carid


if carid is primary key/ common field for all table

Regards
Arasu. S

 


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
Access database database format itHighway Access 0 February 24th, 2008 06:34 PM
Database Connection to Access Database reachsevar ASP.NET 2.0 Basics 1 November 28th, 2007 08:56 AM
Remote access to an Access Project Database bright_mulenga Access 0 February 9th, 2006 10:51 AM
Access issues with ASP and a MS Access Database rj_conceptsnrec.com Classic ASP Databases 2 May 19th, 2005 12:44 PM
using access database in C# chang C# 2 March 18th, 2004 06:17 AM



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


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