Search results for query: *

I've been having problems with my dates Could you please help with my date queries? Day functions are not working. "Pulling the correct information" Monday Date()-((((Weekday(Date()+2))+3))) Tuesday Date()-((Weekday(Date(),2))+5) Wednesday Date()-(Weekday(Date(),2)+4) Thursday...

I’m looking for some help with my sql. • What I’m trying to do is ‘his • Take the Date of Service • Group all matching Master Account Number Have sql look at the group of Master Account = Then find the lowest Date of Service in at Master Account group. So the outcome would look like this. I...

Hello, I'm trying to create a report based on a query I'm looking for a formula that will take my Report date field and sort it by year (Oldest to Newest) I would also like to put this date in a Colum header for each row year (Oldest to Newest) I would like to continue breaking down the...

I've been trying to find a way to make access case-sensitive. in one of my tables I have a Aw and a AW. is there any way I can make it so they both don't look the same in access. Thanks TCB

Hello, I have a report titled “Monthly ABC Report” I use the following code to send out the email. How do I attached the “Monthly ABC Report” to my code below so that it will attach when I send out this email and change it to a PDF? Option Compare Database Sub...

Hi. I'm trying to find a formula that I can use to calculate the number of days left in the month and also the number of days current to past days in the month. I've seen some examples of this when searching on line but I don’t know how I would add them to my current formula that I have to...

Hello, I'm trying the to calculate the projected amount. I'm needing help putting this formula together using 2013 MS Access for starters I need to be able to Calculate the number of days to date in a month Calculate the number of days left in the month. I tried putting together some...

I've been researching how to add a paragraph under the first line. objItem.Subject = "Placements and Assessments Reports " objItem.Body = "I have attached this weekes Placements and Assessments Report. TCB Company P:555-555-5555 F:444-444-4444 TCB

Can someone please help me? I need to convert a numbers column in an access table to a text format TCB

Hi, I’m looking for a macro that I can assign to a button on my spreadsheet that does the following I’m trying to add save as from taking from two cells. So if cell B2 shows 01/15/2015 And cell B4 shows Tim Web I was hoping we can take the combination of 01.15.2015_Tim_Web open up a folder and...

HI, I’m working with MS Access 2013. I’m looking for the Macro that allows me to export a query to a .csv file. Did they remove this from 2013 or is it called something else? Thanks TCB

I’m trying to put together a formula that looks at 3 different cells, and returns the cell that has data in it, and block from putting data in the other selection. IF ANY INFORMATION IS COMBINED IN CELL B2,B7,B9. an error will show If B18 = 90 PUT 100% IN CELL b1, IF B25 = 40 PUT 100% IN...

Hi, I’m trying to put together a formula that looks at 3 different cells, and returns the cell that has data in it, and block from putting data in the other selection. IF ANY INFORMATION IS COMBINED IN CELL B2,B7,B9. an error will show If B18 = 90 PUT 100% IN CELL b1, IF B25 = 40 PUT 100%...

Hi, I have a spread sheet I’m trying to come up with a formula that will add text to the totals box depending on the dropdowns that have been selected. There may be a total of 3 different text words depending on what words they pick from the drop downs. if only one word was selected for all...

Hi, I have a spread sheet I’m trying to come up with a formula that will add text to the totals box depending on the dropdowns that have been selected. There may be a total of 3 different text words depending on what words they pick from the drop downs. If only one word was selected for all...

Hi, I’m trying to make a number field show an N/A. Below is the formula I'm using. any help =IF(B33="",0,IF(B33=N/A,N/A,IF(B33="FAIL",0,20))) =IF(B38="",0,IF(B38=N/A,N/A,IF(B38="FAIL",0,20))) TCB

Hi, I’m working with a spread sheet that has a couple of formulas. One of the formula is 90%. For some reason I’m not able to get the conditional formatting for work on this cell. Would someone take a look and let me know what I’m doing wrong...

Hi, I’m trying to find a formula that will pull the date for the future days Tuesday, Wednesday, Thursday, and Friday. The formula’s I was using pulled the data from the previous week until It’s that day. =Format(Date()-(Weekday(Date(),2))+1,"mm/dd/yyyy")...

I’m wondering if there is some type of formula that would find a date and then allow some kind of wildcard date Something like #12/01/15# and “*” TCB

I'm trying to find a way that I can make Access find number 1 or 2 in a column then add any other numbers that would match the record number -60 days for Referral Date Column “Coll#” must have a 1 or 2 but then also let me the other numbers that are in that column I guess another way of saying...