Recent content by aoswald

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...