Search results

  1. L

    Variable INNER JOIN

    The variable field is a field name in the countries table. This field name is entered into multiple records in the Prices table. This is currently a normal query. I'm not sure if it helps, but the full query currently looks like this and it's just the one instance of Crystal that I want to...
  2. L

    Variable INNER JOIN

    That's exactly what I'm after. I've been able to get everything I want to behave using content entered into the form, e.g. by using [Forms]![Travel Agent Form]![TXT_weight])/1000)), except the join.
  3. L

    Variable INNER JOIN

    Hi. I am not massively technically minded, I try and do as much as I can in queries, but having done some coding and scripting work in the past I can read SQL. I have three tables: 1. Data is a list of generic country names, each country might appear multiple times. 2. Countries is a list of...
  4. L

    Autonumber increment not working

    No, the database lives on a shared drive, but all the users work directly with said database. I'm not the system administrator, this means, for a variety of reasons, that I cannot repair the database as recommended. That the number is not sequential is not a problem. I did look into using...
  5. L

    Autonumber increment not working

    Okay, but how do I stop it from happening again?
  6. L

    Autonumber increment not working

    Sorry if this has been answered elsewhere, I haven't had any luck searching for a solution to this particular problem. I have a table with an autonumber id that recently has been generating numbers which are already in the table as opposed to incrementing from the last number generated. I've...
Back
Top Bottom