O
ooxx
Hi alls,
Can the Query in Access do this?
Usually, the query in Access will have the reference or link with some
special "id" field with another Table.
When I need only to display different records not indexed by "id" in other
new fields, I have come to obvious that I get obstructed to overcome that
task.
Each field would display all records of that particular Table in the same
every row, but I do wish to change the way it to display.
I'd like it to display by creating in another field to display the different
specified "id" or the different row in that particular field.
Suppose I have the Table1 and the "id" as the field of autonumber and then
the "Field1" as another field of the data in form of text to display.
Then I go create query a query name "Query1" to display all records in two
fields, then I would like to create another field to display the different
specified "id" of the record in that same row.
Can you help please, if there are only two records to display?
Thanks,
Can the Query in Access do this?
Usually, the query in Access will have the reference or link with some
special "id" field with another Table.
When I need only to display different records not indexed by "id" in other
new fields, I have come to obvious that I get obstructed to overcome that
task.
Each field would display all records of that particular Table in the same
every row, but I do wish to change the way it to display.
I'd like it to display by creating in another field to display the different
specified "id" or the different row in that particular field.
Suppose I have the Table1 and the "id" as the field of autonumber and then
the "Field1" as another field of the data in form of text to display.
Then I go create query a query name "Query1" to display all records in two
fields, then I would like to create another field to display the different
specified "id" of the record in that same row.
Can you help please, if there are only two records to display?
Thanks,