Jump to content

LDCorey

Members
  • Content Count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About LDCorey

  • Rank
    Newbie
  1. LDCorey

    SELECT problem

    Hi, I posted this same message on the MS Access forum and got the reply that I'm not aboe to do this in the tables. It will only work when creating a report. Lance
  2. LDCorey

    SELECT problem

    Yes, I'm certain that the field is in that table. After all, how would I be able to tell which Minor Category belonged with each Major Category. If you would like, I could post the database so you can see what I have. Lance
  3. LDCorey

    SELECT problem

    Hi , I am creating a table in MS Access where I would like to use a List Box to select a value from a list. Unfortunately, I need to change the values in the List Box based on a previous column in the table. The second column is "Major Category" and the third column is "Minor Category". I have a list of items for "Major Category" in another table and a list of items for "Minor Category" in another table associated with the Major Category. When I use this statement:SELECT [Minor Categories].[Minor Category] FROM [Minor Categories] WHERE (((Questions.[Major Subject])=[Minor Categories].[Ma
×
×
  • Create New...