Search results

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...

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...

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 " &...

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...

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...

Hi Everyone, I need some help with an error I'm receiving when I try to setup a relation between the results of a IIf statement and a table. The IIf statement produces result codes is here: DISCREPANCY CODE: IIf([STATUS]="I" And [CLAIM STATUS]="PAID CLAIM","1",IIf([STATUS]="I" And [CLAIM...

I need some help with copying/updating data from a database table to another. Details: I have a MS Access table containing Dependent social security numbers but some of the dependents social security numbers are blank. I have a MS Sql Database that contains a table with most of the missing MS...

Hello everyone, I need some help with an age query. Here is the situation: I have a date of service [DOS] and a date of birth [Birth Date] I'm trying to calculate the age at the last day of the date of service year not the current year. Example: [Birth Date] = 6/25/1993 [DOS] = 10/18/2013...

Good afternoon Everyone, Any help will be appreciated. I have a date of birth field (DOB) and want to be able to add 23 years to the DOB then I want to take the result and modify the date to the last day of the year. Example: DOB = 11/17/1969 Date Became 23 = 11/17/1992 Modify Date Became 23...

Good morning everyone, I need help with creating a query with two tables. Table A contains multiple records with the same ID number and SERVICE DATES (Some service date may not contain a date [BLANK]). Table B contains multiple records with the same ID and STATUS DATES and a STATUS FLAG that...

Hi, I'm creating a form letter in Access 2002 and the letter is completed but I want to change the formatting from align left to justify but can't find a way to do this. The detail section contains 2 label boxes and 1 text box. Can this be done?

Hi everyone, I'm using MS Access 2002 and I need some help with the following, I'm trying to create a prompt for a date and then enter that date into the body of the letter. Also can the date format be short and converted into a long format on the letter. Example: Prompt - Enter Date Date...

Hi all, I have a field that is populated the a single letter code. I want to write a query that will assign a number to the code. CODES = ASSIGNED NUMBER H = 2 W = 2 If the code is not H or W = 3 If there is no code or blank = 1 Thanks

Hi all, I need to take the ID#, first, and last name of one table and the ID#, first, and last name of another table and create a query that will display/merge all the ID#'s, first, and last names of both tables. I can provide a sample database if needed. Thank you, Rinova

I'm working on a query the will produce counts for 4 different Tiers. Here is the following 4 Tiers. Employee (Member with no Child(ren) or Spouse): Member Status is Active, Member Group# is 205, Member Job Code is not an Admin, Health Coverage Type is Individual...

Greetings, I am new to Access. I started with Access 2003 and upgraded to Access 2007. I've seen many posts from this forum by using Google. It would be better to ask my own questions than try to get answers to my problems from other related questions. I'm impressed with the intelligent and...