Autoupdate one field from another?

[fraser_lindsay]

Hello,

My access skills aren't as good as my Excel skills. I am trying to convert a large uwieldy set of Excel spreadsheets into a more manageable database.

Part of my Excel sheets use logical arguments - so they interrogate a cell and if there are two of three results another cell reports 'yes', if not a 'no'.

I have set up a matching table in Access but don't know how to, if I can, get Access to evaultae a field result from data entered ito another cell.

In one cell the data entered will either be H, M or L. I want another cell to report Yes if H or M are present in the other field and 'No' if not.

Is this possible, I'm pulling my hair out and I want to get away from using Excel.

Thanks,

Fraser

 

[fraser_lindsay]

Thanks for the response.

I assume you mean use a select query?

What do you mean by 'From' and 'Where'?

I understand the command, that's fine, but I haven't got it to work yet. I'm not entirely sure how I am supposed to set up the query containing that command.

Is it like this:

Field - [sourcefield i.e. containing H,M,L]
Table - [sourcetable]
Sort - blank
Show - Checked
Condition - [the string you gave above]

If it is I get no result in the query.

If I use this query as the record source for my form then I loose all data on the form.


Sorry, I have chucked myself in at teh deep end to be honest and I'm still learning as you can probaby guess.

Thanks for your time.

 

[fraser_lindsay]

Ah ok, thanks very much for your help.