I am adding an IF THEN Statement to a display string.
IF Count ({PS_EMPLOYEES.EMPLID}, {PS_EMPLOYEES.JOBCODE}) > 100 THEN "Needs Attention"
ELSE CurrentFieldValue
I can't get the current field value to display if less than 100. It is coming up blank...
Please HELP!!!
Thanks
herschelrj
I need to have a link to close the browser popup when clicked and one that will go to a url in a new window and close the current window. Any ideas??? I know it can be done. I just am not too sure how.
I am trying to take some form data and put it into an Access database on the webserver. Any help??? I was using Frontpage but now Dreamweaver. Here is the code for the form...
<form method="POST" action="sh_reg.asp" name="FrontPage_Form1" language="JavaScript" onSubmit="return...
I saw a website that uses tabs as navigation. Does anyone know if this is an applet or can this be done with dreamweaver delivered???
http://sandi.net/staff/staffbull/2006/1103/index.html is the site.
I have two date fields, a hire date and a term date. I would like to subtract the hire date from the term date and come up with the nuber of years or partial years. Any help appreciated.
All,
I have just completed a website with dynamic pages. Everything looks and works great on my local machine. Now I am ready to place it on the production webserver. When I place the folder on the server, everything breaks. I end up the code being displayed instead of my data. I know it is...
Where do I find the setting or how do I get a page to not resize in the browser when you change the size of the browser? Should I set the pages to 100%? Any ideas appreciated...
herschelrj
Anyone know how to populate a drop down list in a form using data from a query and still have it insert when the form is submitted?
Thanks for any ideas...
HELP!!! I have a registration page that shows when a class is available or closed. It worked like a charm. I used the wizard to get it working. IT restarted the server and now my results page no longer works. The for works. The database connection works. But the Database Results returns the...
I am trying to learn how to submit a form and have it check to see if a particular course is full by checking a query that will give it the information and return an error "Class is full, please choose another date" without having to re input all previous form information.
Any ideas???
herschelrj
I have a registration page that needs to check to see if the course is available before submitting for confirmation and bringing back an error if the course is not open. Anyway to have the form run that check before submitting to the database? Any help is appreciated...
herschelrj
I am trying to do the following. I created a query that gives me a count of employees and grouped by a registration date for training. I would like to display "Session Full" if the count is greater than 95. I tried to use an IF THEN statement in the criteria but keep getting a syntax error. Can...
Question...
I wouls like to display the information from one subreport. But if that report is blank, I wouls likw to display the second subreport. Some of the records have information in both. I want to display the first one only if both contain data. Any ideas?
Display CTY Credentials. If...
I am running a report in version 10. I need to include the records that have no values. Just have them there for reference. Any Ideas???
Example... I am bringing in all Nurses, Librians and Counselors for aprox 20 school sites. Some of these sited do not have librians, or maybe no counselors. I...
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.