Search results

Ok I will review this and see if I can finally get these last two reports working. Thanks so much.

Yes there is a filter on the query, 2 of them.

I have a report which uses a query as its source. On the query the results are being returned correctly but report is not returning the same information. What might be the cause for this?

Ok so I created a query that shows how many jobs an employee has. but when I added a / qryempjobcount.empjobcount at the end of my existing formula the results went crazy...

hey jz not sure if you read my post where I was noticing some employees were having there attendance points multiplied. Well I just discovered what number it was being multiplied by, the number of jobs the employee has. Now how to fix this at the root cause, not sure. But if you could help me...

DoCmd.Minimize DoCmd.Maximize Will start the form minimized or maximized but how do I start a form in windowed mode?

that works. Thanks.

I was wondering if it is possible to assign this to a form caption forms!frmEmployee.comNumber. Like this "Employees with more than " & forms!frmEmployee.comNumber & " point(s)" Or something like that. Failing that is there a way to set a query caption?

You know I actually had 3 of the 4 parts of that correct. The last part that you just powered through is where I was hitting a brick wall. Thanks so much, now to read the sql code to try to make sense of it.

As I suspected it was a problem with the employee in the database, don't know what caused the issue. But I deleted the employee and reentered all the data for the employee and now it is giving the correct results. Is there a way to check for hidden duplicate data? I believe there was hidden...

As always very helpful. Thanks I will review this in a bit and see if I can get it to work. Thanks much again jz.

Should be noted that this issue was already present before your help. Just had not yet discovered it.

Not sure if you have any idea why it appears to be doubling some results. If there an error in one of pieces of code?

no that is the what i wanted, just didn't know the command. how will that command know the query name?

thanks John, but how do I pass that into the query from VBA? That is the part I'm really clueless on. Thanks for the tips though. Also I tried the query you posted and get a data mis-match error when I try to open the query. Not sure why with the exception of char(34) it looks the same.

Um...not sure if you read the question. That isn't a vba solution. That is already what I did.

See the below query, how would I write this into vba and have the criteria be set by cboNumber? If anyone could help that would be greatly appreciated. I got this code from the query designer generated code. I highlighted in red where I suspect I would change this to the combo box. Which...

Jz, I am having a heck of a time with a query. Do you think you could hop over to this post and see if you have anything to offer? I've tried stringing together 3 queries but the problem i'm having is that some days for each department do not have employees with days off. And as such they are...

Well I got it to work sort of, the only thing is it isn't showing days where no one is schedule off. How do I get it to show days even if no one is off?

I don't understand how these two are subtracted...since the first query doesn't give a sum of persons off...