Recent content by Blackops
-
B
Query: Not commands
Thank you very much. It worked, much appreicated. -
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
Sorry, I found the answer. If the field is a Number field than I need to do away with the quotes. -
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
Sorry to keep posting over myself I found the issue. I was entering the information incorrectly. The format worked. Thank you very much for your help. -
B
Date Format
No because the table I"m pulling from is linked from another server and will not allow changes within the table itself. -
B
Date Format
Ok, I understand the format provided and see how it return the month and year of March 2011, however, is there a way to have it return the date and month of what ever is within the field. Not all fields are March 2011. -
B
Date Format
Am I correct in assuming that this format can be entered within the query to display as stated? Which of the following formats should I be using. I have tried them all and still get errors: 1.) Format(DateSerial(Left([LRDTE],4),Mid([LRDTE],5,2),Right([LRDTE],2)),"mmmm yyyy") 2.)... -
B
Date Format
When I try to enter the format, I'm getting the following error: "Data type mismatch in criteria expression". Is this because some of the records within the field have nothing in them or have a 0 and nothing else? -
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"
Perfect, thank you very much. It works. This will help me a great deal -
B
Query Help "If Then"
Re: Query Help "If Than" I'm sorry I understand now. It never occurred to me to just delete the field from the query and allow the new expression to display the message I want for it to display. Thank you very much for your help. I do have one other question on the same topic. How can I... -
B
Query Help "If Then"
Re: Query Help "If Than" It did work however, it seems to only work if I type it into the query in another field. Is their anyway for it to show the message in the same field the data is in. Meaning can it not show the data but instead show the text. Thank you for your help pbaldy -
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...