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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. davanderbilt

    combox box won't allow bound column set to 2

    Never mind, I figured it out :-)
  2. davanderbilt

    combox box won't allow bound column set to 2

    I have a similar issue. I have a table with ID and Ethnicity and have a combo box on my form where I'd like the user to see the text ethnicity to select from, but then have the number value associated with it pushed into the table. How would I do that?
  3. davanderbilt

    update query

    That worked, thanks!
  4. davanderbilt

    update query

    I was afraid of that. Thanks for your help.
  5. davanderbilt

    update query

    If I do a separate update query for every value (i.e. one for HeartAttackDOD, one for AnginaDOD, one for IrregularHeartDOD, and so on) it works as it should, but when they are all combined into one update query is when it doesn't work.
  6. davanderbilt

    update query

    Here's the entire update query: UPDATE Health_History SET Health_History.HeartAttackDOD = Null, Health_History.AnginaDOD = Null, Health_History.IrregularHeartDOD = Null, Health_History.OtherHeartDOD = Null, Health_History.StrokeDOD = Null, Health_History.FainitingDOD = Null...
  7. davanderbilt

    update query

    Randy, Please ignore my last post. I fixed the data type mismatch problem. I tried setting to NULL instead of " ", but it is setting HeartAttackDOD = NULL even when there is a value of 1 in HeartAttack. This is a problem because a value of 1 means that the person did have a heart attack...
  8. davanderbilt

    update query

    When I tried that, I got a data type mismatch error.
  9. davanderbilt

    update query

    Thanks, I removed the quotes from around the 2 since it isn't a string value, but it is still setting HeartAttackDOD = " " when there is a value of 1 in HeartAttack. UPDATE tablename SET tablename.HeartAttackDOD = " " WHERE(((tablename.HeartAttackDOD)=#1/1/2001#) AND ((tablename.HeartAttack)=2));
  10. davanderbilt

    update query

    I have an Access update query that is not working. Here's my SQL: UPDATE tablename SET tablename.HeartAttackDOD = " " WHERE(((tablename.HeartAttackDOD)=#1/1/2001#) AND ((tablename.HeartAttack)="2")); It sets HeartAttackDOD = " " even if HeartAttack = "1" and I only want it to set...
  11. davanderbilt

    Exclude data if calculated value is null

    Thank you Paul, that worked great!
  12. davanderbilt

    Exclude data if calculated value is null

    I have a report built on a query that combines data from 2 tables Body_Comp_Data and RMR_Data. There are 3 values for SBP and DBP and I have written code to average the SBP and DBP values for each table and have those values dumped into BC_AvgSBP, BC_AvgDBP, RMR_AvgSBP, and RMR_AvgDBP...

Part and Inventory Search

Back
Top