Hi:
I'm trying to figure out a way to remove duplicate records (rows) from a large Excel spreadsheet. If there isn't an easy way to do this in Excel, maybe there is a way in Access.
Example data:
1236 - Tom Jones
1696 - Jim Smith
1788 - Aimee Hunts
1236 - Toms Jones (duplicate)
1966 - Billy...
Hi:
I'm trying to create a database that will automatic populate a field when I enter something in the prior field. For example, the table has the following four columns: vendor, address, town, and date of service. The vendor's contact address and town will always be the same, so I want to...
Hi:
I'm trying to create a database that will automatic populate a field when I enter something in the prior field. For example, the table has the following four columns: vendor, address, town, and date of service. The vendor's contact address and town will always be the same, so I want to...
Hi:
I'm trying to create a presentation that will have the same header on every page except for the title page. I've tried everything that I know how to do, I even tried drawing a white box over the text that's appearing on the title page, but it looks really bad when I print the presentation...
Hi:
I've created a simple data entry form in Access and added a command button to add a new record. The button works, but I want the cursor to go back to the top of the page. Can anyone help???
Thanks!
Hi:
I have a spreadsheet that has a sum function that does not update until I save the spreadsheet. Can anyone help me figure out why?
Thanks for your help,
Swan717
Hi:
I am creating a report (template)in Access that has several charts, table, and text. The template has all the same charts, but each page corresponds to a different town and therefore has different numbers. The problem is that I am missing data for some years for some of the towns (not the...
I've copied and pasted some information (3 columns) from a pdf file into Excel. I pasted the information and everything appeared in one column. So I used the Convert Text To Columns - Delimited - by a period (as the text has periods to separate the three columns. However, some of the...
I am in the process of designing a form to act as a user interface. The form is for internal requests for information/project assistance. Basically the person will enter the criteria for the project or information that they need and will hit a submit button. I would then like the information...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.