creating a query for a report

  • Thread starter Edward Letendre
  • Start date
E

Edward Letendre

I am in a bit of a confused mode at the moment.

I am building a new query to get data that is linked between an access 97
front end database and a sql server 7 backend. The situation is as follows:

I have multiple tables that contain seismic data. From this collection of
seismic data, I need to form it into a query that will display the following
information:

line name, client name, prospect name, etc. The client name comes from the
client table that is in turn linked to the line_header table. There are also
other pieces of information such as what company captured the seismic info
that also has to appear in the header of the information. Each header will
contain new information each time data is displayed. So for example,
prospect 1 will be displayed and within prospect 1 there are multiple line
"records" if you wish. Thus you would see the following data:

line: BL-02
client: National Oil
prospect: Garfield 01 3D
contractor: Ralph's seismic Inc.

etc.

The body of the information is as follows:

Line Point LAT LONG EAST NORTH ELEVATION COMMENTS
BL-02 303
 
Top