Access question
- Thread starter cabbie
- Start date
Your link was bound to a session which returned me a message saying the session has been logged out. You may want to go to that article without signing in to link it correct.
That said, you would do a Update query for the table, select the column then in update to row, type in "karaoke " & [column C]. (Note the space after karaoke- it's there to make the string literally hold a space between the word 'karaoke' and the name in field).
That said, you would do a Update query for the table, select the column then in update to row, type in "karaoke " & [column C]. (Note the space after karaoke- it's there to make the string literally hold a space between the word 'karaoke' and the name in field).
Here is a view of the process for the search engine Maybe this will explain a little more. I guess I should have said every row in column C..
1. Column A = ARTIST
2. Column B = SONG
3. Column C = FILTER #1 - appears as a search filter (i.e. genre).
4. Column D = FILTER #2 - appears as a search filter (i.e. decade).
5. Column E = DISC # - appears in the final request list as a song location reference (i.e. disc #).
6. Column F = TRACK # - appears in the final request list as a song location reference (i.e. track #).
For FILTER #1 and FILTER #2, the search filters, It is recommended to not have more than 20-30 variations for each field. For example, if you are going to have genre as one of the fields, it is not recommended that you have more than 20-30 different genre types. Having more than this could cause the search page to load very slowly. 30 character max. Other examples of filters can be decade, year, tempo, BPM, style, event, function, mood, date, charts, ranking, etc.
1. Column A = ARTIST
2. Column B = SONG
3. Column C = FILTER #1 - appears as a search filter (i.e. genre).
4. Column D = FILTER #2 - appears as a search filter (i.e. decade).
5. Column E = DISC # - appears in the final request list as a song location reference (i.e. disc #).
6. Column F = TRACK # - appears in the final request list as a song location reference (i.e. track #).
For FILTER #1 and FILTER #2, the search filters, It is recommended to not have more than 20-30 variations for each field. For example, if you are going to have genre as one of the fields, it is not recommended that you have more than 20-30 different genre types. Having more than this could cause the search page to load very slowly. 30 character max. Other examples of filters can be decade, year, tempo, BPM, style, event, function, mood, date, charts, ranking, etc.
Similar threads
