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...

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.

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...

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...

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...