Search results for query: *

Actually I figured it out....thanks for help though. Data - account = DR12345 To remove the DR I have to use the "right" and correct function. Right([account],5)

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...

So, Would this be correct? DateDiff([completed date]- [requested dated])

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.

This is what I ended up using: Right('0000000000'+[Account],10) Thnx again Q

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...

Thank you...That worked. You have been very helpful.

O.k....I guess maybe I should explain this a bit further... I am importing a csv file into a table. I want to make a query that will update the account # to 10 digits if it is less then 10.

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

Thank you all for your help...the problem was not your suggestions but the database itself. I got the same error when trying to run a macro that I have been using for years. That problem has been fixed and I entered your suggestions again and finally have what I was looking for. Thank you...

Added field and criteria - still get the same error. Any other suggestions? Q

Here is what entered for the query suggestions. Field: Refcode Requestdate Table: SLA-Incomplete SLA-Incomplete Criteria: =Now()-2 Also tried (h,Requestdate,Now()-2) This is the error I receive: Compile error. in...

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