I have a strange problem that I've been trying to fix for the past two weeks. I've seen posts here (did a search) that have the same problem, but none of the solutions thus far offered have worked in my case. I'll try to explain the full scenario in details and hopefully it will neither be too...
Ok. quick question.
I had some old betamax tapes (vacation tapes from the 70s/80s and I wanted to convert them to DVD. I got my hands on a Betamax player, hooked it into my standalone DVD recorder (GoVideo) and made a DVD from 3 tapes. Now, I don't really like the DVD/titling options that...
Ok, so I figured out how to get my Top 50 Report going. It works great. However, because my file has nearly 100k records, whenever I want to open the report, it takes roughly 10-15 minutes. Secondly, if I need to print any portion (the report is approximately 10000 pages total). Each page...
Is there an automated way to have Excel find dates from a date that is specified only to the last day that year which is not specified? For instance, I bought a stock on February 1, 2002. I then bought more stock that year, and some in 2003. However, I only want to see any stock I bought...
Is there an automated way to have Excel find dates from a date that is specified only to the last day that year which is not specified? For instance, I bought a stock on February 1, 2002. I then bought more stock that year, and some in 2003. However, I only want to see any stock I bought...
I have a database of clients in which there are 6 fields set aside for address lines. There is also a field called "namelines" that has a value of 1 to 6. This value shows how many fields are actual names of clients and not address portions. Is there a way to have my report show...
I had to import a CSV file for a new project I'm working on. I did everything I needed to do and my report came out fine, except that the reps are claiming they need the dates and phone numbers in a standard format.
I could easily fix this in Excel, but I can't because the CSV file has 95,000+...
I have a database with over 90000 records. It contains many fields, but the pertinent ones for my query are as follows:
rep_no, account_no, value, address_1, address_2, revenue, ACH
I need two reports from this data. One report will use the data as is. The other report needs to show the top...
Hey everyone,
I'm using Adobe Premiere 6.5 and am having problems importing video from my Camcorder (not digital) into Premiere. I bought a TV capture card (ATI TV Wonder). I have the camera set up properly. I can record video/sound perfectly with ATI's software, however Premiere doesn't...
Hi,
I have a form where I'd like a user to be able to enter some data and have it pull up related records based on what was entered. For instance, if I have an inventory of products dealing with fruit, my data would look something like this:
item
----
Apple Sauce
Apple Cider
Orange Juice...
Ok, here's my dilemma. I have a database with 350000 transactions. Each transaction is linked to an account number. There about 64000 unique account numbers (field: account_no). How can I make a lookup box that will only include unique account numbers. Currently, I have the look up box get...
I have a query called "manager_total" which has 6 columns: manager, rep_no, count1, count2, count3, count4. Sample data will looking the following
manager rep_no count1 count2 count3 count4
----------------------------------------------------------
john doe 1...
Hello everyone,
Here's my dilemma. I have two queries, "mailing_list_full" and "officer_search". The fields in "mailing_list_full" include account_no, address1, address2, address3. The fields in officer_search include account_no, address1, address2, address3...
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.