×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Having trouble with table relationships-Want to run queries

Having trouble with table relationships-Want to run queries

Having trouble with table relationships-Want to run queries

(OP)
Using Access 97, I am trying to construct a database that will house historical artifacts (ex. photos, maps, literature, monuments, landmarks, etc.) I've assigned each artifact a seperate ID and each artifact has a table with that ID number as the first field followed by fields with other descriptive info.  Here's what's not working: it's basically a spreadsheet at this point, and what I want to do is run a query or report for every artifact that deals with "adobe."  When I run the query, nothing comes up -- all the fields are blank.  I checked the relationships window and all the tables are tied together through the "Artifact ID" field.  Thanks for any suggestions or help.

RE: Having trouble with table relationships-Want to run queries


Please post your query and table structures. It is difficult to understand the problem from your description only.

Thanks,

Terry
http://members.home.net/tlbroadbent/prog.htm
_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes

RE: Having trouble with table relationships-Want to run queries

(OP)
Thanks for the quick response. . .

What is the easiest way to post query and table structures?
Is there a way to post the database (by link) to the forum?

Thanks so much.

RE: Having trouble with table relationships-Want to run queries


If you've been using the query designer in Design View, swicth to SQL View, copy the query text and paste to the forum message area like I did below.

Example:
    SELECT a.DateID, a.AmountA, a.AmountB, (Select count(*) From MyQuery Where DateID<=a.DateID) AS RecB
    FROM MyQuery AS a
    ORDER BY a.DateID;
A simple explanation of the table structures like the following will help.
    table1:
    ArtifactID int
    Description text(128)
    .
    .
    .

    table2:
    ArtifactId int
    col2 date/time
    col3 text(40)
    col4 currency
    .
    .
    .
Hope this helps.

You could provide a link to a database that we could download if you are willing to make it available on the internet. Or you can Email it to me as an attachment. Email to tlbroadbent@hotmail.com. Hotmail does limit the size so it would be best if you compact the database and ZIP it if possible.

Terry
http://members.home.net/tlbroadbent/prog.htm
_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes

RE: Having trouble with table relationships-Want to run queries

(OP)
Terry-

Thanks so much for your assistance with this. . .

I emailed the database (it's not too big) to the address you gave me.  Any help with it would be great!

David

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close