Job Closing provides an error message

<!-- #ygrps-yiv-456933304 _filtered #ygrps-yiv-456933304 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-456933304 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-456933304 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-456933304 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-456933304 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-456933304 #ygrps-yiv-456933304 p.ygrps-yiv-456933304MsoNormal, #ygrps-yiv-456933304 li.ygrps-yiv-456933304MsoNormal, #ygrps-yiv-456933304 div.ygrps-yiv-456933304MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-456933304 a:link, #ygrps-yiv-456933304 span.ygrps-yiv-456933304MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-456933304 a:visited, #ygrps-yiv-456933304 span.ygrps-yiv-456933304MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-456933304 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-456933304 code
{
font-family:“Courier New”;}
#ygrps-yiv-456933304 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-456933304 tt
{
font-family:“Courier New”;}
#ygrps-yiv-456933304 span.ygrps-yiv-456933304HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304attach, #ygrps-yiv-456933304 li.ygrps-yiv-456933304attach, #ygrps-yiv-456933304 div.ygrps-yiv-456933304attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304bold, #ygrps-yiv-456933304 li.ygrps-yiv-456933304bold, #ygrps-yiv-456933304 div.ygrps-yiv-456933304bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304green, #ygrps-yiv-456933304 li.ygrps-yiv-456933304green, #ygrps-yiv-456933304 div.ygrps-yiv-456933304green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304replbq, #ygrps-yiv-456933304 li.ygrps-yiv-456933304replbq, #ygrps-yiv-456933304 div.ygrps-yiv-456933304replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304ad, #ygrps-yiv-456933304 li.ygrps-yiv-456933304ad, #ygrps-yiv-456933304 div.ygrps-yiv-456933304ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304underline, #ygrps-yiv-456933304 li.ygrps-yiv-456933304underline, #ygrps-yiv-456933304 div.ygrps-yiv-456933304underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-456933304 span.ygrps-yiv-456933304yshortcuts
{}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304ad1, #ygrps-yiv-456933304 li.ygrps-yiv-456933304ad1, #ygrps-yiv-456933304 div.ygrps-yiv-456933304ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304ad2, #ygrps-yiv-456933304 li.ygrps-yiv-456933304ad2, #ygrps-yiv-456933304 div.ygrps-yiv-456933304ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-456933304 p.ygrps-yiv-456933304underline1, #ygrps-yiv-456933304 li.ygrps-yiv-456933304underline1, #ygrps-yiv-456933304 div.ygrps-yiv-456933304underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-456933304 span.ygrps-yiv-456933304yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-456933304 span.ygrps-yiv-456933304yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-456933304 span.ygrps-yiv-456933304EmailStyle34
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-456933304 .ygrps-yiv-456933304MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-456933304 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-456933304 div.ygrps-yiv-456933304WordSection1
{}
#ygrps-yiv-456933304
_filtered #ygrps-yiv-456933304 {
}
_filtered #ygrps-yiv-456933304 {

font-family:Symbol;}
_filtered #ygrps-yiv-456933304 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-456933304 {

font-family:Wingdings;}
_filtered #ygrps-yiv-456933304 {

font-family:Wingdings;}
_filtered #ygrps-yiv-456933304 {

font-family:Wingdings;}
_filtered #ygrps-yiv-456933304 {

font-family:Wingdings;}
_filtered #ygrps-yiv-456933304 {

font-family:Wingdings;}
_filtered #ygrps-yiv-456933304 {

font-family:Wingdings;}
_filtered #ygrps-yiv-456933304 {

font-family:Wingdings;}
#ygrps-yiv-456933304 ol
{margin-bottom:0in;}
#ygrps-yiv-456933304 ul
{margin-bottom:0in;}
–>

We wrote an updateable query showing labor transactions either unapproved or active. When we get this message we filter the query by job# to address.

I get the following error message when attempting to close a job.  Could someone offer suggestions on how to solve this.  Thanks

A labor detail record is either active or has not been approved.

You have a labor record that has not been approved in time and expense. That needs approved before you can close.

Sent from my iPhone

On Oct 9, 2014, at 1:07 PM, "jesusfreak2437@... [vantage]" <vantage@yahoogroups.com> wrote:

 

I get the following error message when attempting to close a job.  Could someone offer suggestions on how to solve this.  Thanks

A labor detail record is either active or has not been approved.