Additional field in a query

[Berend Lindeman]

Hi, i am new to this forum, have some experience with excel and access (no VBA or other programming, just using the tools), but not into the details i read around the subjects in this forum.
I thought i had a very simpel question, but cannot find an answer myself, so turn to the group for help.
The issue is...
-1- Have 2 simpel tables, each with 2 and 3 fields.
Lets say table 1, persons name, brand of car ... table 2 brand of car, max speed, fuel consumption
-2- have a query that selects a number of records from the 2 tables
Lets say, name, car brand, max speed, fuel consumption.
-3- in the query i would like to add an additional field "use" with Y/N to indicate if i want to use that query record.
Lets say:
name carbrand max speed consumption use
mr A, Nissan, 150 km/hr, 10 ltr/100km ... Y
mr A, Porsche 250 km/hr, 20 ltr/100km ... N
mr B, Mercedes 200 km/hr, 14 ltr/100km ... Y
mr B, Nissan 160 km/hr, 13 ltr/100km ... N
mr B, Audi 180 km/hr, 18 ltr/100km ... N
This means the field "use" can only be filled in the query ..... or is there an option to automatically link to tables??
(notice that mr A as well as mr B drive the same type of Nissan, still i only want to use mr A with the Nissan an he is more efficient with fuel).


I will also update the list (lets say we find that the Audi uses less, so want to change consumption AND change use N to Y.
I tried make table, but that deletes all data already entered.
Hope one of you can help.
Regards - Berend J. Lindeman

[Robeen]

-3- in the query i would like to add an additional field "use" with Y/N to indicate if i want to use that query record.

The above does not look like something I would attempt to do in a query.
I think your 'Use' field should be in a Table . . . because a query doesn't really 'store' data - it just displays data that is already in your database [it can also modify, add or remove data . . .].

Perhaps I didn't understand your question correctly?

[mejia.j88]

what do you base the Y/N on? is this linked to a specific field in a table?
in other words, does (and if so, which) some information on your tables imply the Y/N?

if so, like robeen mentioned above, you might want to make a yes/no field in one of the tables.