"kevcar40" <ke******@btinternet.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hi
i have imported two tables from excel each table contains information
about a team
what i want to do is display the records on the same form
side by side
i have created a table using a query and append the two imported tables
but i cant get the records to display the way i wish
fields are
team
time
fault
action
i would like the form to be laid out as folows
information for team 1
information for team 2
time fault action time
fault action
can anyone help please
thanks kevin
So you no longer have two tables, but one - is this how you want the data
structured?
Does the data really only relate to two teams and the main form only
displays team 1 and 2, or will the form be used to show other 'pairs of
teams'? What about any other functionality of the form, eg find, sort, add,
edit delete?
At its simplest (and if there are no other requirements) I would have an
unbound main form with two subforms with recordsources of:
SELECT MyTable.* FROM MyTable WHERE MyTable.Team=1
SELECT MyTable.* FROM MyTable WHERE MyTable.Team=2