Search results

I have a table with 2 fields: FTE# and Workingdays. FTE# Workingdays MR301 477 MR413 45 MR303 26 MR312 77 MR316 149 MR404 5 MR408 180 I need to write a query to show the result (whole record, not the number only)...

My problem is: on the form, there are a combo box that contains all the positions and a Subform. What I need is: After I choose a position from the combo box, the Subform can show all the records that match that position. Or... if I create a command button under the combo box, after I choose...

Thanks Jon. It works. Really appreciate. coco

Thanks Wayne. The code looks like a VB code, right? But I would like write this in the query, how? Anyway, I'll try it and let you know. coco

Actually my doubt is: can I put messagebox(or Inputbox, or words like "Show report") statement in the IIf statement. For instance: IIf(Table.[End Date]<=[EnterDate], [End Date], Msgbox("Please try again.")) AS field name Thanks for your help. coco

I'm working on a project. There is a question that I couldn't figure out how to write the query: What is the largest ID# for each Division? For example: There are four divisions: MR, WHS, SS, LS. Each division has several ID# followed by a three-digits number in the ID# field. Like: ID# MR301...