Search results for query: *

I have a field that includes "DR" in front of the data. I'm trying to build an update query to remove the DR from data. Here is what I have tried: Left$([account],InStr(1,[Account],"DR")-1) Left([account],7) Both gave me a compile error. What am I doing wrong? Thanks in advance for any help...

I'm working with an excel spreadsheet which has dates. I want to be able to change the dates to the next business date if the date should fall on a weekend or holiday. I found a couple of scripts but they do not tell me how to submit the script into the VB of an excel spreadsheet. I also need...

Hi All I have 2 tables in which I import data to. Some days there is no data. Is there a way, besides going into the table and entering zero's, to still have a record created with null values? I have a query which counts the number of records by date, that number is then added to another count...

Good Afternoon I am trying to build a query that will give me the number of days that are between the "Completed Date" and the "Requested Date". I am not familiar with VB or modules. I thought I could just enter: Completed date - request date = Any help would be much appreciated.

I have a table that holds records of checks that will either have todays date or are future dated. There are certain circumstances where a check is also back dated. What I need to do is make a query that updates the date to the next business day if it happens to fall on a weekend or holiday...

I am looking for help on creating a query that will add a zero to an account number if it is less then 10 digits. Any help would be much appreciated. Thnx Q

I am trying to create an if statement to determine how many requests were not met within 48 hours Fields request date: 06/21/2005 10:03:00 AM Todays date: 06/23/2005 10:34:00 AM Any help would be much appreciated. Thanks Q