Try this,
=IIf(IsNull([Customer PO]) or [Customer PO] = ""),"NEED PO",[Customer PO])
Have you tried to see if this statement works in a regular query? Or if the query that the report is built upon is pulling the correct information (I know probably dumb questions, but it doesn't hurt to ask! :))
I have a report where I have 'due dates' for projects, and I want to order by date asc. Some of the rows do not have a date provided.
I want to have the report show all the itetms with dates first, then the ones with no date at the end.
Anyone have an idea of how to make this happen.
Many...
I'm very new to java script. But I figure I have to learn somehow.
What I'm trying to do is take the inputed values from a form and print out the calcuated value. I would guess it's something similar to an order form.
eg of what I'm trying to do?
<FORM>
<P>
<table>
<tr><td...
there is no lock file. That was the first thing I looked for, I should have mentioned that in my earlier post. I can see what I can do to have the admin restart the server. But I was hoping there was another way around that.
We have a database that sits on a shared directory on our server. As of last night we keep getting the following error message.
Could not use H:\projects\projects.mdb file already in use.
Noone is in the database. Please help! :)
Thanks from all of us here trying to use the db! :)
I think my post was not clear enough. I have a emp table with a PK of empID and a manager table with mgrID with the emp_mgr table handling the many to many relationship. What I'm asking is.....
when using a form to assign the relationship how would I check to see if there is already an existing...
I'm trying to assign a manager to an employee using combo boxes in a form. I have an emp_mgr table that contains the empID and mgrID. I'd like to show an error message to anyone who tries to duplicate the emp/mgr relationship if it already exists in the database. How could I do this. Please be...
Thanks humble! I used radio buttons instead, but your post was very helpful (I was in the middle of posting my reply when you must have submitted yours! )
:)
Hi!
I'm trying to have check boxes 'checked' or unchecked based off of values in one of my tables.
I have 4 check boxes:
Yes
No
Pending
Information not in file
The values in the table:
1=Yes
2=No
3=Pending
4=Information not in file
How do I get the apprpriate box checked for each customer...
When I export from sql server 7.0 into Access 2000 I lose all of my primary keys and relationships? Is there a way to keep my primary keys along with the relationships so I don't have to recreate them each time? Thanks!
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.