Hi, I think this is probably a silly question, but hopefully an easy one!
I am making a query in Access 2003 in design view and I want all the fields to be in my new make-table query, so I dragged the star into the query to get all the fields. I now want to specify selection criteria for one of my fields. Can I get the star to expand itself so I can put the criteria in the right field? Or is there a way to specify your criteria without expanding them?
Thanks so much!
I am making a query in Access 2003 in design view and I want all the fields to be in my new make-table query, so I dragged the star into the query to get all the fields. I now want to specify selection criteria for one of my fields. Can I get the star to expand itself so I can put the criteria in the right field? Or is there a way to specify your criteria without expanding them?
Thanks so much!