Search results

How would you group data based on two different fields within Access. Looking for some type of query or calculated field that I could then use to see the two-paired lines together. Attachment shows data better than preview Here is what I am trying to do Column A Column B Column C...

No Duplicates I tried the query but it seems to put me into some to put me into some kind of loop. 5 minutes later and it is still running the query. Here is the SQL as I ran it. SELECT DISTINCT Mission2.entry_nbr, Mission2.AIRBILL_NBR, Mission2.TRACKING_NBR, Mission2.arrival_work_dt...

I am working with several compliated queries in which I need to eleminate duplicates in my query based solely on the data from one field. Is their a way to write into SQL or the design view to eleminate all records that are duplicated in a single field.

Category Jon Thanks a million.. Works like a charm

Category The name of the field is "dest_total_customs_amt" . The critera shold not be overlapping it needs to be >5 and less 200. This would be named "NE". If the value is greater than 200.01 or equal to or less than 2000 then it would be named "SI". If it is over 2000 then it would be...

I need to run a query that will give me "NE" as the answer when my field meets certain criteria. I need it to say "NE" when the field has a value between 5 and 200 and "Formal" when the value is between 200 and 2000. Here is the query as it already has some filters build in to it. SELECT...

Yes.. I want the union query that will show all records which do not fall into the stated categorys with the Category name of : "Other" I figured it would be some kind of wildcard like the below but that gives me everything and not just what has not been identified already. SELECT...

Thanks Ian, Your soultion worked like a charm. Is there a way on this same query to have a kind of all others query. I want the query to end with a if not found by the above Query specifics then put everything left under the catagory of "other" thanks, Bill

I have a union query that is trying to extract some jumbled information in a field. I have gotten the Query to extract what I want to a point but I need to take it a step further. My problem is I need my Query to give me the wildcard of *AGR* but not anything that is "AGRI" because it needs to...

Is there a way to create a querry that will account for both instances of the jumbled text. I need to analyis how many instances I have of both ABC and 123 in my records. If my querry overwrites the ABC123 with ABC I won't be able to also sort out my counts for 123 also. Thanks, Thomp

wildcard and Jumbled text Jon, Thanks for your response. I have just one concern. If I run this querry and I have the jumbled text ABC123 in one of my records and then run this querry as an update querry with both the wildcards "ABC" and "123". Will the querry return two records now for ABC...

I am importing data from another database I can't control in which I am getting data in a field that has text data all jumbled in together. Ex..ABC, ABC123, 123XYZ..The data needs to be seperateed out into like catagories. If I run a wildcard that is *ABC* I would see all the data that has ABC...