Search results
-
B
Query: Not commands
I'm hoping someone will be able to assist me with a basic question that I do not have the answer for: I have a query which I'm trying to have populate leaving out data within a single field that has the following listed: MD, RW, XX, MT, AC. I have tried the following but they all return the... -
B
If/ Then Help
Answer: I thought I would post my question into a new thread as I did get the answer to it, however I have another question concerning it. The answer did work for what I needed it to do which was provide the text indicated if the field "Certificate" had LH-11-0001. I'm trying to acomplish... -
B
Date Format
Hello, I'm hoping there is a way to do what I'm hoping can be done. I have import'ed several records from another sever which have defaulted the date records to the following format YYYYMMDD (text format). My question is, can I change that to show as a date. I would like for it to only show... -
B
Query Help "If Then"
Hello, I'm hoping someone can assist me with an issue I have been having. I have been using access for 8 years now, but it's all self taught and my limitation have been reached with coding/ expression. My question is; I would like to have a field named "Certificate", show the following...