Search results

  1. A

    Select records in Table 1 that are not in Table 2

    You have an interesting take on the world.... Your first post to this thread made no pretention of providing any help but instead simply criticized because the wording was not put in a form that YOU liked. The reply that I provided was to Jon K and HIS posting. I think he fully understood what...
  2. A

    Select records in Table 1 that are not in Table 2

    The original posting was worded intentionally to be a simple representation of the situation and was not intended to be a technical description of the database. The intent of the post was to describe the situation simply in order to avoid side discussions about database structure, foreign keys...
  3. A

    Select records in Table 1 that are not in Table 2

    Thanks, but that did not seem to work. However, I did get it to work with this idea from someone else... SELECT Reviews.PK_ReviewID FROM Reviews WHERE ((Reviews.FK_StatusID)=3) AND (((Reviews.PK_ReviewID) Not In (SELECT Results.FK_ReviewID FROM Results)));
  4. A

    Select records in Table 1 that are not in Table 2

    I have two tables [Reviews] and [Results]. When a Review has a Status = 'Not Accepted' then there should be one or more records in [Results] that indicate what the result of the review was. I want to structure a query to perform a data integrity check to select any Review ID that satisfies the...
  5. A

    Parameter Query

    You have to use the following syntax in the QBE grid. forms![FormName]![ControlName] or Like forms![FormName]![ControlName] is null Where FormName is the name of your form ControlName is the name of your control on that form Then once you run the query, save it, close it, and open it again...
  6. A

    How to set up database?

    Correct - the 7 copies will be independently installed, one copy on each person's PC. Currently the tables and all the data input and reports are working fine. There are a whole bunch of bells and whistles everyone wants but those are not finished. So no one wanted to wait because we really need...
  7. A

    How to set up database?

    Well, thanks for replying, I guess, but this is not helpful. We considered the issue you raise and for the time being it is more important to get the database into everyone's hands so we can start using it. There are some time constraints at the present time that will go away later when we can...
  8. A

    How to set up database?

    I have finished creating a database - my first one. Now I don't know how to deploy it. About 7 people will be using this database. We have decided that it won't be a multi-user database shared on the network. Each person will have their own copy. I want to split the database into...
Back
Top Bottom