Search results

I tried to upload a screenshot of the design view but the file is too big. I can't upload the db because there is sensitive information in it

ok I have the Contacts table on the left and the Leave table on the right. In the Last Name field I have this expression [Contacts]![LastName] , Nz ( [Leave]![Pay Period] ,0) I get a syntax error

change in formula returned same result removing the format fixed it thanks so much for the response

i am using this formula: expr2: DateDiff("yyyy",[hiredate],Now())+1 it returns the correct number for example the first record is 1/15/1900. The 15 is correct but why is it giving it to me in this date format? thanks

so do i put Select A.EmployeeName, Nz(B.TotalLeave, 0) in the critera field?

I have the employees in one table and the leave they have taken in another table. The query returns their name and the date and type of leave taken. but now the boss wants to see everybody's name on the report whether they have taken leave or not.

I need to pull names from a list to report leave taken but I need to list all the names on the report whether they have taken any leave or not any suggestions?

ITS WORKING!!! I was going to make some changes and thought I should back it up first. After I did that it started working I appreciate your patience

I have the bound column as 3 which appears to be the column the names are sorted by. If I change the bound column to 1 which is the last name, will that screww up the over 700 records currently in the table? thanks

OK SQL now looks like this: SELECT Contacts.LastName, Contacts.FirstName, Contacts.File_Number, Contacts.WorkPhone, Contacts.PRCode FROM Contacts ORDER BY Contacts.LastName; Still not sorted in the combo box by last name.

Here is the SQL: SELECT Contacts.LastName, Contacts.FirstName, Contacts.File_Number, Contacts.WorkPhone, Contacts.PRCode FROM Contacts; yes this query is the source for my combo box: When I hit the combo box drop down, I see the Last and First Name-- OUT OF ORDER :(

It's not working - the query is sorted correctly but the combo box still has the list out of order

Onload is not a field in the query. I want the results to be sorted by LastName

in the SQL view of the querey it says "orderbyOnLoad" Yes

What do you mean by explicit sorting

I have a similar problem. I have a combo box with a query as the source but the list does not appear in the same order as the query. How do I get the list in the combo box to be in the same order as the querey? thanks

huh? sorry - I don't understand what you mean

too many clicks Yes I can right click on the field and then drill dow to "text begins with" but that is 3-4 steps. I want a shortcut

I want a button or shortcut to use the "text begins with" filter on a form. How can I put such an icon or shortcut in my tool bar across the top? thanks

I input info into a combo box in a form. The info is a number that I then use to populate other fields in the form based on that number. When I try to sort based on that number I get a type mismatch error. Why is that? I would really like to be able to sort based on this field but I can't...