query criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm new to using query in access, so I need some help. I have an unbound
combo box that shows dates, but the tables have different ID with same dates,
so I want the combo box to show a date only once. What should I write the
criteria so that dates do not repeat. thanks

esca007
 
Hi,
I'm new to using query in access, so I need some help. I have an unbound
combo box that shows dates, but the tables have different ID with same dates,
so I want the combo box to show a date only once. What should I write the
criteria so that dates do not repeat. thanks

esca007
Click to expand...

Base the combo box in a Query selecting only the date field (not the
ID); set the query's Unique Values property to Yes.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting Text Box in Query Criteria 4
Setting criteria in query 2
Filter subform from combo unbound text box 3
Access Dcount (multiple criteria) 3
IIF ([date_combo_box] Is Null,“xâ€, Between date 1 And date 2) 1
Date search query 0
How to show qry "criteria" on a report ? 10
Search criteria for querys 3

Back
Top