Recent content by SORI

THanks this works perfect. :banghead::banghead:

I have a table with Zip CODE field. I uploaded my information to this table form an excel file. There were over 120K rows of data so no way i could do this in excel. So I found that some of the ZIP codes are either blank or have less than 5 digits. Can I build a a query with the ZIP code...

It is open but I guess this is not the solution I am looking for. I want user to be prompted with a combo box when running the query. Instead of typing the crieteria I want them to have a drop down menu! I feel like I would need to build an event for this. Thanks!:banghead:

HELP! I can't figure this out I have a query where I want to use a combo box in the parameter. However, its not working. SELECT Call_Details.Emp_ID, Call_Details.[Call Status] FROM Call_Details WHERE (((Call_Details.Emp_ID)=[Forms]![TTY_ID]![TTY_ID])); I get this in the Parameter Value...

Thanks! it worked just as I wanted. But I want to get even dirtier. Say I throw in another column "Call_Channel" I want to only count the calls made face to face. Should I run a query separate by this criteria and then run the expression above on said query? SELECT T1.Emp_ID AS Expr1...

Hello everyone, not so new to Access I understand the capacity of the program. Not so good with SQL. With that said I want my query to count only records that are not duplicated base on a set of criteria. I have a table with customer IDs and Call dates and the employee ID. I want a count of...