Search results

2007 I right clicked on the field and selected Equals(the value in the field) I wanted all the records with that value in the field I get the same error no matter which field I try to sort on

"The method you tried to invoke on an object failed" *You may have specified too many or too few arguments for a property or method of an object. Check the component's documentation for information on the properties and methods it makes available for Automation operations *There may not be...

yes there is

OK I already know the answer - yes I can query more than one table because I have done it before. But now as soon as I add the second table, I get no results in the query. I know there should be some results. what am I missing? thanks

The method you tried to invoke on an object failed. *You may have specified too many or too few arguemtns for a property or method or an object. Check the component's documentation for information o the properties and methods it makes availalbe fo Automation operations *There may not be enough...

Nevermind - I figured out how to copy a record and paste it into a new one.

I need to keep track of our contact with Agents. I want to make a new record everytime I contact the agent but I don't want to have to fill out all the fields everytime because once I make the initial contact, most of the information will be the same. Is there a way to duplicate a record and...

allan57 do I just put that formula in the criteria field if yes - it didn't work

What forumla do I use to return entries one week on either side of today's date: thanks

sorry - I mean ONE week on either side of today

what formula do I put in a query to get entries on week on either side of todays date? thanks

Got it - works great - thanks

I understand the =>16 but I don't know how to group on associates

I have a table the tracks training hours for associates. Training credits are earned in 1,2,and 3 hour blocks I want to know the names of associates that have completed at least 16 hours. How do I do that? thanks

This is what I have now: SELECT Contacts.EmployeeName AS Expr1, Nz(Leave.hours,0) AS Expr2, Contacts.LastName, Leave.[Pay Period] FROM Contacts LEFT JOIN Leave ON Contacts.File_number = Leave.File_Number WHERE (((Leave.[Pay Period]) Like "11/16*")); It seems to work until I put in the 11/16...

Ok - looks like I am getting some names with a 0 in the hours taken column but I need to narrow it down to a specific pay period. When I do that, I don't get the names with zero hours anymore

OK that got rid of the syntax error but I'm still not getting the results I need from the query the leave table has the hours people have taken in each time period. The contact table has everybodys name in it. Manangement wants everybody's name on the report whether they have taken leave for...

I didn't think of looking at the sql view. Here it is: SELECT Contacts.FirstName, Contacts.LastName, Leave.Type, Contacts.File_Number, Leave.Hours, Leave.DateUsed, Contacts.PRCode, TimePeriods.PayPeriod, Leave.DateUsed, Leave.Ending, [Contacts]![LastName].Nz([Leave]![Hours],0) AS Expr1 FROM...

That is correct - a table called Leave and a table called Contacts That's a good idea about labeling with tbl prefix. I'll do that on my next project as soon as I get this one to work changing the comma to a semicolon didn't work.

Using this suggestion from Wayne Ryan: Select A.EmployeeName, Nz(B.TotalLeave, 0) From tblEmployees As A Left Join tblLeave As B On A.Employeeid = B.EmployeeID I put [Contacts]![FirstName] ,Nz( [Leave]![Hours] ,0) Contacts.File_Number = Leave.FileNumber I get an invalid syntax error