Search results

I think I figured this out... please let me know if my logic is correct here. If I create a new table with the same structure, assign the "business name" as the primary key, and then do an append query from the old to the new table, I should be able to remove the duplicates as that the primary...

If have a table with billing occurances and one of the fields is "business name" how would I need to setup a make table query which lists unique occurances within that data? Essentially, I want to remove duplicates. If ABC Pet Store has 5 billing occurances and XYZ Pet Store has 1... I want...

I am working through a lot of data and this is basically what I'm trying to do. Let's say we have billed occurances for ABC Pet Store. What I need to do, is to see how many "billed lines" appear in the data. So if there are 3 billing occurances (let's say bill amount greater than zero) - in the...

Sorry, I guess I should have mentioned that. If there are some missing data field for duplicates, how do you resolved this if you just want to compare a single field against itself? (such as: Location: Pet Palace - and I only want to show one "pet palace")

One more question for this project... The data has a lot of duplicates in it, if I want to query unique results only, what do I need to put in the criteria?

Thanks so much! It seems so easy I don't know why it didn't click. /shrug Thanks!

I just had to pull a large amount of data from an off-site SQL server. Due to speed issues, I broke up the data into 3 pulls and exported the data as text. I have now imported the data into Access and wish to combine the three tables into one. All of the fields are the same, the only difference...

I'll elaborate a bit more: This survey is essentially a study. Every single question is either Multiple Choice, Free-text, or a combination thereof (such as: "What is your favorite animal?" A)Cat B)Dog C)Other:________ ) - By the way, how would I set that up? I have been doing some reading...

This will only be for a one-time survey, so I am fine with doing it via the shorter method, as long as that will do the task. :) I am new to Access, so forgive me for my questions. :) Just a few more... So, with the short route I will only need tables "Questions," "People," and "People...

I am attempting to create an Access database that reflects a paper-survey. Basically, surveys were sent and have been returned and we now wish to enter the information into a DB for reporting purposes. The survey is all multiple choice, free-text, or a combination thereof (example being this...

Do you have an example I could look at of the type of code I would need to use?

Hello Everyone, Please let me say in advance that compared to many of you, I am an Access newbie, so pardon me if I miss some of what you're trying to say. :) Here is my situation: I have been tasked with creating a survey. However, many of the questions are if/then. Here is an example: "Do...

I am new to these forums and simply wanted to introduce myself. It seems as though a lot of information sharing goes on here, I certainly hope I can learn some as well as contribute! Good day!