Search results

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...

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.

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...

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...

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

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...