Search results for query: *

Everytime I export to Excel, or even when I copy and paste into Excel, all of the fields come in as text. If I have a numeric field in Access, it comes into Excel in a general or text format. On my other computer, everything works normally, Excel recognized date and numeric and currency...

I need to delete duplicate transactions from a 3.5 million row table. The transactions appear with a different transaction number, but have the same store #, account #, transaction $ amount, transaction type, date, and are within 60 seconds of the original. I don't know where to go. I know...

That does what I need. Thanks for all the help.

All of the formulas yield the same result, a bold format. I start with 13 columns with category locations, I add 4 more, I need to identify if any of the 4 new locations match any of the 13 existing. So I used the conditional formatting and used: Cell Value is equal +$B2 Cell Value is equal...

I have a grid that I am using which is laid out in the following way: Store# - Bud - Coors - Miller 111 - A - B - C 112 - D - B - X 113 - A - R - G I currently have 13 categories and the location within the store. I need to add 4 more. If the new category replaces...

The format I used was a simple bold, is there a way to copy everything into another sheet, keep the bold format and lose the conditional formatting so that I can then do the 4th? I will only be changing the values one time, so once they are identified by the conditional format, they can stay in...

I am using an Excel file with conditional formatting, I would like to be able to use a 4th condition. Is there a way?

F11 was a simple answer which solved my problem. Thanks.

Whenever I open My Computer on Windows 2000 Professional, the toolbars are now missing. I have no File Menu or any of the others. How do I retrieve these?

Exactly what I needed, thanks.

I am working with a database for a trucking operation. I need to create a query that will find late deliveries. The problem that I am having is the information is being transmitted in the following format "2/9/2004 8:07:29 AM" and I am not sure how to write the query. I need to...

The problem with the default value is that it might change every 10 entries when there could be 1000 in a day. Instead of making the full 1000 entries, I would like to be able to enter 100 records with one of the fields being able to accept the 10 values for my package ID thus creating 1000...

Right now the table structure is very simple, there is only one. Everything is keyed in, line by line. There is a lot of repetition in the data entry which is what I am trying to eliminate. Could you explain the subform to me? I am not very familiar with its uses or creation.

I am trying to create a form that will allow multiple values for one field. There are 10 fields that will be entered, but 9 of the remain the same for a multipe (but varying numbers) entries in a row. I am maintaining records in a table for retail deliveries. The driver, date, vehicle all...

I am trying to find a way running 2000 Professional to disable the ability to clear the IE history for certain users or even groups. I have a user who has a problem with clearing the history constantly on other users machines. Any help would be greatly appreciated.

Is there anyone out there who can help?

Can anyone help me?

I am trying to create a report with columns. It works fine when I go "Down, Then Across" but when I choose "Across, then Down" it becomes a mess. Any suggestions onhow to keep the entire group together?

Thank you for the help....works perfect.

I am looking to write a query that takes part of a field and displays it. The problem is that the length is not constant. I have a table full of addresses with City, State ZIP in the same field. Using the left and right functions I am able to separate and create a field for State and ZIP...