Search results

  1. A

    Multiple fields and remove duplicates

    Importing data from a csv (Data.zip) into tables within Song-V2_Mihail.accdb
  2. A

    Multiple fields and remove duplicates

    Works excellent, just what I wanted. Thankyou so much!!!! Do you know a way I could easily import songs into without typing them into, for example the attached Data.zip frmSongsArtists and frmSongsGenres don't work.
  3. A

    Multiple fields and remove duplicates

    I may have missed read or your database doesn't allow songs to have multiple GENRES. I've attached two databases with data, yours(Song-V2_Mihail) and mine (Song-V2_anhlongqld). If you could please help with the qrySong4Export to have it output like the Result.jpg image.
  4. A

    Multiple fields and remove duplicates

    I want to export the data to Excel or just a csv file.
  5. A

    Multiple fields and remove duplicates

    hi Mihail, I was after a query so I could export the database, like shown in the Result.jpg. However, I do like the forms, they make easier for entering data. Do you know of a query that I could use to export the data?
  6. A

    Multiple fields and remove duplicates

    I've attached Example Database and Result of what I would like to help with, been search for months but no luck. Thanks very much for checking/helping.
  7. A

    Query Distinct and Concatenation

    Please help with the query below, I would like to make it display like the attached image but couldn't work out how to. Thanks. SELECT tblSONG.CallNo, tblSONG.ID, tblSONG.Title, [tblSONG-ARTIST].Artist, [tblSONG-GENRE].Genre, tblLYRIC.Lyric FROM tblLYRIC INNER JOIN ((tblSONG INNER JOIN...
Back
Top Bottom