Search results

Thanx very much for the help. I have all 5 columns of data now in a single table with a unique identified for each row. if i want a user to select a specific data element, how do I create a query to search for the specified data element, and only return the total count? All suggestions are...

Pat, you suggested: You can normalize it locally to make your queries simplier. Please explain. I am relatively new with Access... thanx

Thanx...I appreciate the insight. My table is fixed as it pulls from a much larger database. I can query each of the 5 columns individually or a as a sing query of all 5. I am looking to have a single action (push a button) that will ask what data you want, then display the total number of...

i have a large table of data... the 5 columns contain various codes... each row can have more than 1 code.. ie... row 1 CF1: CF-B1 CF2: CF-R CF3: CF-B2 row 2 CF1: CF-R etc.. my query pulls these 5 columns and shows only rows that have the specific code. if i want to sum all the CF-R, there...

rodmcThanx for the reply. i am looking for specific txt in each of the columns and totaling the occurrances. How many CF-B in each of the columns and adding them for a total. an another example. book sales, customers purchase 1-5 books... I need to know the total number of a specific book...

suggestions please... i have a query that finds specific data in 5 columns. How to i combine the resulsts into a single point? five columns are CF1, CF2, CF3, CF4, CF5 The criteria for each is [code], allowing the user to pick which code to search for. data is txt (ie. CF-B, CF-B1 etc...)...