Search results

I use CDATE to convert my DOB from CCYYMMDD to MM/DD/CCYY CDate(Mid([DOB],5,2) & "/" & Right([DOB],2) & "/" & Left([DOB],4)) But I like yours better

Date of birth is text

Hi Everyone, Hope everyone is doing well, I need some help. I need to know if it is possible to convert a date of birth (Ex: CCYYMMDD to MM/DD/CCYY and calculate age within a single query? Thank you, Rinova

Hello Everyone, I need help. I have a table with dates and other info and I'm trying to create a query that will show the date just before the most current date. Example: PS_Date Status 12/1/2017 E 10/1/2017 I 12/1/2016 E 6/1/2015 I...

Plog, I used the code you provided to check if my assumptions were correct and it was, no results were returned by the query. Afterwards I did everything else you said, and it worked perfectly with the sample and actual dataset. Thank you, Rinova

Thank you for the quick reply! Below are the answers to your questions. 1. Your table has no primary key field - add one e.g. SubscriberID or make a joint PK field of both the existing fieds (but see point 3) 1A. I forgot to add a PK to my sample. I updated the sample to include it. 2. You...

Hello everyone, I need help. I am trying to determine the four Tier Indicators base on 2 Fields, the Primary ID and The Relationship Code. Here is the logic. Tier Indicators 1. Tier SGL: A Subscriber that has a “Relationship Indicator” of ‘01’, and does NOT share a “Primary ID” (only this...

They both work perfectly. Thank you so much! This will fix another problem I have in a different query. THANK YOU SOOOOOO MUCH PBALDY!!!! :D

Hi Access Experts, I'm having a problem using Trim with StrConv functions, when I use this code Trim works. FullName: Trim([dbo_sponsor]![spn_chair_person]) but when I add StrConv, Trim stops working. Below is the code that doesn't work. FullName: Trim(StrConv("Dear " &...

The table stores employer demographics (Name, Address, City, State, Zip, Zip4) but for some reason someone decided to create non-existing (fake) employers in this table with record numbers in to 90000 range. The problem is they added a existing (real) employer, and for some reason assigned it a...

Hi Access Experts, Need help including a record that's inside an excluded range. I have a table with record numbers from 1 to 91599. I want to exclude records from 91011 to 91599 but I don't want to exclude record 91102. How do exclude a record that is included in the excluded range? I could...

Hi Plog, Here an update on editing prompts to only what I need. I decided to use a Multi-Select List box to Filter a Report and was able to get help from BaldyWeb.com here is the link http://www.baldyweb.com/multiselect.htm there is also a sample DB link on the web page. With his code I was...

Thank you plog, I figured as much. :( I will start from scratch and do it the way you recommended. BTW: I found this link, do you think this will help me accomplish what I'm trying to do as well...

Help with parameter query that prompt users for input Hi All, I have a Form that is used to print a report and the report is based off of a query. I don’t like the WHERE statement in the query. I want the user to enter the employer codes and not have to continue to press enter when they are...

Last post on this item: Do you know any sites that I can learn how to create a user-defined function? Thanks, Rich

@vbaInet Thank you for all your help I was able to modify your code to this (See Below) and it works great. I'm not sure it is the best way to do what I'm trying to do but it works for me. Thank you again. Switch( [DOS]>[dbo_depfile]![dep_term_date] And [CLAIM STATUS]="PARTIAL PAID",2...

I'll work on learning how to make it a function now. Need to do some reading to learn how. Thanks

I removed the iif statements from the query and it ran without errors Here is the code after I removed the iif statements SELECT DISTINCT ALLGHIUTILIZATIONRPTS.Year, ALLGHIUTILIZATIONRPTS.Month, Format([ALLGHIUTILIZATIONRPTS]![CERT-ID],"000000000") AS SSN, ALLGHIUTILIZATIONRPTS.[PATIENT-NAME]...

Sorry I misunderstood you, I thought I did what you asked by not using the iif statement in the query. I'm obviously not doing this correctly. Sorry I hate to admit this but I don't know access that well to do what your asking. How do I remove the iif statement but keep the rest of it and get...

I removed the " " surrounding the numbers and it didn't work. I then changed the numbers to letters and it worked but it only seem to use the first two iif statements and didn't recognize the last two. I then did what you suggested and removed the iif statements. This is the code I used...