Hi.
Currently trying to concatenate several text and date cells but when I finish the date comes out as a number so I need to format in my formula but can't figure out how.
Here's my formula:
=CONCATENATE("CB:",A5,": ",D5,"")
Cell A5 is the date field that needs the formatting around it...
Hi there.
I'm having a problem updating a field for everyone in one of my tables. The query I have so far is:
UPDATE EmpBen LEFT JOIN Eml ON EmpBen.Emp= Eml.Emp
Set EmpCov=(Case when Eml.AnnlFrzSal>=50000 then (35000+(Eml.AnnlFrzSal-50000)*.50) Else Eml.AnnlFrzSal*.70 End)
Where...
Hi there.
I'm having a problem updating a field for everyone in one of my tables. The query I have so far is:
UPDATE EmpBen LEFT JOIN Eml ON EmpBen.Emp= Eml.Emp
Set EmpCov=(Case when Eml.AnnlFrzSal>=50000 then (35000+(Eml.AnnlFrzSal-50000)*.50) Else Eml.AnnlFrzSal*.70 End)
Where...
Hi There.
This is super basic. I was wondering how to format this statement:
If({Organization.Work Status}In["HrlyFT","HrlyPT"]) then "H"
Else "S"
Won't let me save it.
Any ideas and sorry for being so lame.
Hi there.
I'm currently running Windows XP and I'm trying to reformat my hard drive. I want to wipe everything out and start fresh but when I go to the cmd prompt and type format c it says the volume is still in use.
How do I stop all items from using the volume?
Hi there.
I’m trying to update one field on a sub-form once the value of another field on the same sub-form is selected from a combo box. I wrote a macro using the SetValue command.
In the ITEM area of the macro I have:
[Forms]![frmDataEntry-Main]![frmEntry Detail Subform].[Form]![IntName]...
Has anyone notice speed reductions since installing IE 7? It seems to take way long to load than IE 6.
If anyone has experienced this is there any current fix?
I have a super powerful computer with tons of memory. I also have no viruses, etc.
Thanks.
Hey there Everyone.
Is it possible to set up an auto reply for my outlook express email account? I want to do this as I'm going on vacation and would like everyone to get an auto reply message. I would also like all my emails during my holiday to go into a vaction folder. That's probably asking...
Hi there.
I have a situation where on a weekly basis I am updating a data source (spreadsheet) by adding a column on the right side and deleting a column on the left side. This creates a rolling type of chart for dates.
Problem is that the chart based upon the data source keeps changing and...
Hi there.
I'm currently writing a macro that inserts a column and give it a title 7 days from the title of the last column. I then want to copy the forumlas from the original column and just add 7 days to the sheet reference in the formula. So one formula might be: ='June 9'!I7/'June 9'!H7 and...
This is a really pervasive 'virus'. I can't get rid of the MSN Toolbar.
Has anyone come up with a method of blowing this thing away? Regular removal techniques are not working.
Thanks.
Hi There.
I'm designing some stationary in for email messages. In Outlook stationary uses the background feature as the main area to reference your images, colours, etc.
I want to put a picture as my 'non-repeating' background and also make it a hyperlink so when the person receives my email...
Hi Gang.
I'm having the weirdest problem. I've used hover buttons in the design of my website working in Microsoft Frontpage. When I upload (FTP) my site to my ISP some people can see the hover buttons and some can't. It seems different computers handle these differently.
Is there anyway to...
Hi there.
I have a situation where I want to pull back a person's previous cost centre (department) only if they have had a department transfer.
So the logic is something like if person A has a change reason of department transfer go back to the record before this and get me their cost centre...
Does anyone know how to find weekend days in a date range. These would be Saturdays and Sundays.
I have a date range of July 29/04 to July 29/05 in which I want to deleted data entry for any Saturday or Sunday.
If anyone can help I would be ver greatful.
Thanks so much.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.