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

.HTMLBody = strbody & "<br>" & .HTMLBody this is where I put my name and title 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...

I don’t use a date. I just need the number to calculate the Projected Amount today's would be Project Amount: [Fees_Collected]+(([Fees_Collected]/8)*22) Project Amount_NB: [REFERRED]+(([REFERRED]/8)*22) TCB

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

Thank you Andy TCB

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

Thank you, I think you are correct about having to do this in VBA TCB

Rocking Job SkipVought, works perfect TCB

its still not working TCBhttp://files.engineering.com/getfile.aspx?folder=8f49acf6-5279-42a6-8a49-f55d1c30d35c&file=Copy_of_SCORING_(1).xlsx

Not working - see attached TCBhttp://files.engineering.com/getfile.aspx?folder=d62f148a-37c1-49a6-bff9-9e8a8336652e&file=Copy_of_SCORING.xlsx

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