trying to create a report or query.

[kaim]

Trying to figure out a way to run a report or query on a unique identifier number and have it pull any similar numbers on a different column

EX

5 some information some information If linked to another record insert number
6 some information some information If linked to another record insert number
7 some information some information If linked to another record insert number 6



i want to be able to if they have a 6 in column a and a 6 in column c to pull into a report with all of the other information from the table...

Is this possible and if so how do i go about doing it?

thanks,
Kai M.

[June7]

Why would 6 be in multiple columns? Need better understanding of data structure. Provide sample raw data and desired output.

If you want to provide db for analysis, follow instructions at bottom of my post.

[kaim]

Why would 6 be in multiple columns? Need better understanding of data structure. Provide sample raw data and desired output.

If you want to provide db for analysis, follow instructions at bottom of my post.

Attached is the database. if you look at the main database table there is 2 records. i want the unique identifier number and the Previous record if mached to show up in a query or report with all of the other information so i can track how long a particular machine was down if it spans days or multi shifts..

[June7]

Oh crud! This is web database.

Pulling values from another record can be done with:

1. nested subquery, review http://allenbrowne.com/subquery-01.html#AnotherRecord

2. self-joining table

3. domain aggregate functions

[kaim]

Oh crud! This is web database.

Pulling values from another record can be done with:

1. nested subquery, review http://allenbrowne.com/subquery-01.html#AnotherRecord

2. self-joining table

3. domain aggregate functions

This was going to be attached to a sharepoint page but i found out that you must have the enterprise version of sharepoint to be able to do this and we only have the free version...

Would it be better if i recreated this into a "non Web" database?

[June7]

I've never used one but have edited some posted to forum. Is harder to edit objects that are set up as web type. You have the tables set as web type but the form is not so maybe won't have issues. But really, if not going to be a web database, why have anything set as web type and invite possible issues?