Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Querys

Status
Not open for further replies.
Tubalife

Tubalife

Technical User
Apr 22, 2003
11
US
I have a table linked back to an Excel worksheet. I want a query that will be able to set criteria, that if the value in the cell is greater than 50, it will check the box yes, and if it is less than 50 check the box no. Can anyone help me??
 
Sort by date Sort by votes
try this...

DoCmd.RunSQL "UPDATE YourLinkedTableName SET [YourYesNoBoxFieldName] = IIf([NameofCellValueField]>50,'Yes','NO')"

hope this helps you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Marleyuk
  • Locked
  • Question
Export Querys to Multiple Excel Worksheets
Replies
1
Views
24
JerryKlmns
JerryKlmns
Fensbo
  • Locked
  • Question
Querys
Replies
2
Views
20
lespaul
lespaul
SUnderwood
  • Locked
  • Question
Best Practice: Databases: Querys in DB or WebPage
Replies
1
Views
18
psemianonymous
psemianonymous
Lotek02
  • Locked
  • Question
Access Querys
Replies
3
Views
43
fredk
fredk
areric
  • Locked
  • Question
Double Click on List box querys db
Replies
2
Views
21
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top