Having trouble with table relationships-Want to run queries 1

[mencius]

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.

 

[tlbroadbent]

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

 

[mencius]

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.

 

[tlbroadbent]

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:[ul]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;[/ul]A simple explanation of the table structures like the following will help.[ul]table1:
ArtifactID int
Description text(128)
.
.
.

table2:
ArtifactId int
col2 date/time
col3 text(40)
col4 currency
.
.
.[/ul]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

 

[mencius]

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