Recent content by rinova

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