Recent content by OnziTam

rsmonkey appreciate your advice but can I merge vertically column from Excel through the importation process. the thing is some players may have never won or other ( the champion) had never lost that is why I heed the names from both columns merged vertically in one field (column).

that is because the data is imported from excel spreadsheet I did a lot of research on DISTINCT but the answer for me is union query: SELECT winner FROM Table1 union SELECT loser FROM Table1;

I have this basic question (obviously not so basic for me): how to pull out only unique records from two fields. More details - two fields with names of competitors in a tournament (Winner or Loser) and i need to build a query to have all players names participating in the tournament...

10x jon k that is exactly what I needed. the idea for join list box has come up earlier but if the the list with the clients is hundreds going through it will be very inconvenient

nop, this is not what I mean. i want to select a value in the first field (name) and the second field (country) to auto populate. and vise versa if i select value from the second field (country) the first(name) to auto fill. Exactly the way it is in excel attachment. in your example if I...

I attached an Excel file as an example of what i am trying to achieve with Access. I need a form with two linked fields when i assign value regardless in which one the linked field has to change (autofill). Any suggestions will be appreciated

hi, i justs start experimenting with database applications and i think filemaker is a dam good one. i find it very easy to collaborate my MS Excel knowledge with in it. my qustion is can I use formulas such as this below in access to automatically calculate a fields based on another fields...