Recent content by HRN_SciTech

Hi yes that's fine, the problem is if those results didn't have either a synonym or a category listed, (so absolutely nothing written in the field), they would not have shown up if you had searched for them as above

How do I do this? I am in control of the chemicals so each time they are used, the new amount is recorded. Unfortunately, those in charge of the chemicals before me have not done much record-keeping. The date is recorded when the data is entered into the system by me (which is the same date...

Forgot to quote your answer. Have attached the database in my last comment. The issue I was trying to show in database_ss3 & 4 was that removing one of the fields e.g. synonym meant that chemical no longer showed up in the query.

Sure. Attached.

Thanks very much :)

Hi there, I am extremely new to Access. I have my database up and running ok(ish) and would like to know if in my data entry form, I can have the "Date Entered in Database" box display the current date that does not change from day to day. I know you can use the "Now()" function but won't...

And this is what happens if I remove one of the fields from a chemical entry and then try to search for it.

Ok here's a screenshot of the table

Are we able to upload pictures on here or do I have to upload to another site and link from there?

If you are getting annoyed with this,you don't have to help, it's ok... It doesn't work means it doesn't work. The function of the query is to return results searched for. If it does not do this, it doesn't work. My clause works for "Where". Yours doesn't. That's what I mean.

I include all synonyms for that chemical under one heading 'Synonyms'. posting a jpg... hang on

Because replacing with 'ORs' doesn't work. I see where you're coming from and I see why that should work but unfortunately it doesn't.. a computer programming friend of mine said SQL is not logical at all. I tried fiddling around with putting the Iif(IsNull) in and I got it to work for one...

Hi there. Thanks for helping by the way. The search form works with the current clause which is: WHERE (((Chemicals.Chemical) Like "*" & Forms!ChemSearch!Chemical & "*") And ((Chemicals.Synonyms) Like "*" & Forms!ChemSearch!Synonyms & "*") And ((Chemicals.Category) Like "*" &...

Hi there. Amended as instructed. I entered nothing in 'synonym' & 'category' but entered 'Amm" (for ammonium), nothing came up. I tried entering 'fer' for "ferric" and nothing came up. I entered nothing and ran the query, nothing came up. I opened the query manually, nothing came up..

Just put that in.. the query now returns nothing