Sabtu, 31 Januari 2015

RE: [MS_AccessPros] Consolidated multiple records into 1 field

 

Jim,
 
You can use the generic Concatenate() function at http://www.tek-tips.com/faqs.cfm?fid=4233. This one function can be used for concatenating as well as domain aggregate functions like DMax(), DSum(), DLookup(), etc.
 
You can supply any delimiter you desire. The comma is the default.
 
Duane Hookom, MVP
MS Access
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sat, 31 Jan 2015 22:18:30 +0000
Subject: Re: [MS_AccessPros] Consolidated multiple records into 1 field



sean48,

I put the email addresses in a table with the Department as part of the record such as


Then have the email part of the code do a dlookup based on the department.


Jim Wagner


On Saturday, January 31, 2015 8:51 AM, "sean48_48@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
I am writing the e-mail in outlook and then want to copy in the e-mail addresses that are stored in access based on those that meet a certain criteria.  I have 400 records in Access and might need 300 e-mail addresses and am looking for a easy way to consolidate them systemically.




__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Re: [MS_AccessPros] Consolidated multiple records into 1 field

 

sean48,

I put the email addresses in a table with the Department as part of the record such as


Then have the email part of the code do a dlookup based on the department.


Jim Wagner


On Saturday, January 31, 2015 8:51 AM, "sean48_48@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
I am writing the e-mail in outlook and then want to copy in the e-mail addresses that are stored in access based on those that meet a certain criteria.  I have 400 records in Access and might need 300 e-mail addresses and am looking for a easy way to consolidate them systemically.


__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Re: [MS_AccessPros] Re: Counting patients with 3 or more hospitalizations in query

 

HAHAHHA 
thank you for the humor in all this I needed a laugh. will give it a shot, thought there was an issue in the number of something. will try out on Monday otherwise I will work all weekend
Appreciate both the help and the humor!



---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Patty-

Close, but no cigar.  There needs to be only one WHERE clause, so try this:

SELECT ER_Hosp_visits_6mos.person_nbr, ER_Hosp_visits_6mos.last_name, ER_Hosp_visits_6mos.first_name, ER_Hosp_visits_6mos.date_of_birth, ER_Hosp_visits_6mos.encounterDate, ER_Hosp_visits_6mos.encounterType, ER_Hosp_visits_6mos.hospitalAdmitDate, ER_Hosp_visits_6mos.sx_procedure2, ER_Hosp_visits_6mos.year_dx, ER_Hosp_visits_6mos.year_px, ER_Hosp_visits_6mos.disease, ER_Hosp_visits_6mos.disease2, ER_Hosp_visits_6mos.create_timestamp, ER_Hosp_visits_6mos.modify_timestamp
FROM ER_Hosp_visits_6mos
WHERE (((ER_Hosp_visits_6mos.encounterType)="Emergency Room")) OR (((ER_Hosp_visits_6mos.encounterType)="Urgent Care"))
 AND (Person_nbr IN 
 (SELECT Person_nbr 
  FROM ER_Hosp_visits_6mos 
  WHERE (((ER_Hosp_visits_6mos.encounterType)="Emergency Room")) OR (((ER_Hosp_visits_6mos.encounterType)="Urgent Care"))
  GROUP BY Person_nbr HAVING Count(*) > 3));
ORDER BY ER_Hosp_visits_6mos.encounterType;

Note that I also added the filter for encounterType to the subquery so that you're only counting those types of visits.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 7:14 PM, pattykf@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Ok didn't wait until monday, tried this one, but not working

here is the sql query for this one, I am thinking I am trying to do to many things or something in the sorting is wrong.
basically using a prior query that pulls in the visit types of hosp, urgent and ER, this query limits the types to the er and urgent care, then I want to have it return those with 3 or more in a 6 month period. (tried to get the 6 month period to return on the prior query and having difficulties with those crazy dates- so no worrries right now for that), so using the fields that I have that would result in what data is needed this is the sql for this query
SELECT ER_Hosp_visits_6mos.person_nbr, ER_Hosp_visits_6mos.last_name, ER_Hosp_visits_6mos.first_name, ER_Hosp_visits_6mos.date_of_birth, ER_Hosp_visits_6mos.encounterDate, ER_Hosp_visits_6mos.encounterType, ER_Hosp_visits_6mos.hospitalAdmitDate, ER_Hosp_visits_6mos.sx_procedure2, ER_Hosp_visits_6mos.year_dx, ER_Hosp_visits_6mos.year_px, ER_Hosp_visits_6mos.disease, ER_Hosp_visits_6mos.disease2, ER_Hosp_visits_6mos.create_timestamp, ER_Hosp_visits_6mos.modify_timestamp
FROM ER_Hosp_visits_6mos
WHERE (((ER_Hosp_visits_6mos.encounterType)="Emergency Room")) OR (((ER_Hosp_visits_6mos.encounterType)="Urgent Care"))
ORDER BY ER_Hosp_visits_6mos.encounterType;
WHERE (Person_nbr IN (SELECT Person_nbr FROM ER_Hosp_visits_6mos GROUP BY Person_nbr HAVING Count(*) > 3));


it is returning an error that characters found at the end of the SQL statement and it goes to the WHERE prior to the person nbr info in the second to the bottom line of the query

I am going to now give up until Monday :)
Patty


---In MS_Access_Professionals@yahoogroups.com, <pattykf@...> wrote :

changed the subject but kept the old message to have hx.
yes there is a unique ID for the patient so I will look at doing this. I really appreciate your help. You are a great resource, I will give it a shot on Monday, and let you know how it goes.
thankx
Patty
Director of Quality
WellOne Primary Medical and Dental Care
Rhode Island, USA


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Patty-

You should start a new thread for a new problem.

What is the SQL of the other query?  What are the fields in the hospital encounters table?  If there is a unique ID for PatientID, then you could do something like:

SELECT PatientID
FROM Hospital_Encounters
GROUP BY PatientID
HAVING Count(*) > 3;

If you want patient details, perhaps something like:

SELECT Patients.PatientID, Patients.LastName, Patients.FirstName, 
   Hospital_Encounters.TreatDate
FROM Patients INNER JOIN Hospital_Encounters
ON Patients.PatientID = Hospital_Encounters.PatientID
WHERE PatientID IN 
  (SELECT PatientID FROM Hospital_Encounters
   GROUP BY PatientID HAVING Count(*) > 3);


John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 5:28 PM, pattykf@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

THANK YOU!!!!!
there was a space that caused the error, it now works
YOU ALL ARE WONDERFUL, thank you so much!!

are you up for another challenge?
I have a query where i would like it to tell me who has had 3  hospital encounters,
the table is only hospital encounters, it would have a unique number for each patient, I am guessing that there is a way to show those with 3 or more with some type of formula, just not sure what that would be
Ideas?



__._,_.___

Posted by: pattykf@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (30)

.

__,_._,___

Re: [MS_AccessPros] Re: Counting patients with 3 or more hospitalizations in query

 

Patty-


Close, but no cigar.  There needs to be only one WHERE clause, so try this:

SELECT ER_Hosp_visits_6mos.person_nbr, ER_Hosp_visits_6mos.last_name, ER_Hosp_visits_6mos.first_name, ER_Hosp_visits_6mos.date_of_birth, ER_Hosp_visits_6mos.encounterDate, ER_Hosp_visits_6mos.encounterType, ER_Hosp_visits_6mos.hospitalAdmitDate, ER_Hosp_visits_6mos.sx_procedure2, ER_Hosp_visits_6mos.year_dx, ER_Hosp_visits_6mos.year_px, ER_Hosp_visits_6mos.disease, ER_Hosp_visits_6mos.disease2, ER_Hosp_visits_6mos.create_timestamp, ER_Hosp_visits_6mos.modify_timestamp
FROM ER_Hosp_visits_6mos
WHERE (((ER_Hosp_visits_6mos.encounterType)="Emergency Room")) OR (((ER_Hosp_visits_6mos.encounterType)="Urgent Care"))
 AND (Person_nbr IN 
 (SELECT Person_nbr 
  FROM ER_Hosp_visits_6mos 
  WHERE (((ER_Hosp_visits_6mos.encounterType)="Emergency Room")) OR (((ER_Hosp_visits_6mos.encounterType)="Urgent Care"))
  GROUP BY Person_nbr HAVING Count(*) > 3));
ORDER BY ER_Hosp_visits_6mos.encounterType;

Note that I also added the filter for encounterType to the subquery so that you're only counting those types of visits.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 7:14 PM, pattykf@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Ok didn't wait until monday, tried this one, but not working

here is the sql query for this one, I am thinking I am trying to do to many things or something in the sorting is wrong.
basically using a prior query that pulls in the visit types of hosp, urgent and ER, this query limits the types to the er and urgent care, then I want to have it return those with 3 or more in a 6 month period. (tried to get the 6 month period to return on the prior query and having difficulties with those crazy dates- so no worrries right now for that), so using the fields that I have that would result in what data is needed this is the sql for this query
SELECT ER_Hosp_visits_6mos.person_nbr, ER_Hosp_visits_6mos.last_name, ER_Hosp_visits_6mos.first_name, ER_Hosp_visits_6mos.date_of_birth, ER_Hosp_visits_6mos.encounterDate, ER_Hosp_visits_6mos.encounterType, ER_Hosp_visits_6mos.hospitalAdmitDate, ER_Hosp_visits_6mos.sx_procedure2, ER_Hosp_visits_6mos.year_dx, ER_Hosp_visits_6mos.year_px, ER_Hosp_visits_6mos.disease, ER_Hosp_visits_6mos.disease2, ER_Hosp_visits_6mos.create_timestamp, ER_Hosp_visits_6mos.modify_timestamp
FROM ER_Hosp_visits_6mos
WHERE (((ER_Hosp_visits_6mos.encounterType)="Emergency Room")) OR (((ER_Hosp_visits_6mos.encounterType)="Urgent Care"))
ORDER BY ER_Hosp_visits_6mos.encounterType;
WHERE (Person_nbr IN (SELECT Person_nbr FROM ER_Hosp_visits_6mos GROUP BY Person_nbr HAVING Count(*) > 3));


it is returning an error that characters found at the end of the SQL statement and it goes to the WHERE prior to the person nbr info in the second to the bottom line of the query

I am going to now give up until Monday :)
Patty


---In MS_Access_Professionals@yahoogroups.com, <pattykf@...> wrote :

changed the subject but kept the old message to have hx.
yes there is a unique ID for the patient so I will look at doing this. I really appreciate your help. You are a great resource, I will give it a shot on Monday, and let you know how it goes.
thankx
Patty
Director of Quality
WellOne Primary Medical and Dental Care
Rhode Island, USA


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Patty-

You should start a new thread for a new problem.

What is the SQL of the other query?  What are the fields in the hospital encounters table?  If there is a unique ID for PatientID, then you could do something like:

SELECT PatientID
FROM Hospital_Encounters
GROUP BY PatientID
HAVING Count(*) > 3;

If you want patient details, perhaps something like:

SELECT Patients.PatientID, Patients.LastName, Patients.FirstName, 
   Hospital_Encounters.TreatDate
FROM Patients INNER JOIN Hospital_Encounters
ON Patients.PatientID = Hospital_Encounters.PatientID
WHERE PatientID IN 
  (SELECT PatientID FROM Hospital_Encounters
   GROUP BY PatientID HAVING Count(*) > 3);


John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 5:28 PM, pattykf@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

THANK YOU!!!!!
there was a space that caused the error, it now works
YOU ALL ARE WONDERFUL, thank you so much!!

are you up for another challenge?
I have a query where i would like it to tell me who has had 3  hospital encounters,
the table is only hospital encounters, it would have a unique number for each patient, I am guessing that there is a way to show those with 3 or more with some type of formula, just not sure what that would be
Ideas?



__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (29)

.

__,_._,___

[MS_AccessPros] Re: Counting patients with 3 or more hospitalizations in query

 

Ok didn't wait until monday, tried this one, but not working

here is the sql query for this one, I am thinking I am trying to do to many things or something in the sorting is wrong.
basically using a prior query that pulls in the visit types of hosp, urgent and ER, this query limits the types to the er and urgent care, then I want to have it return those with 3 or more in a 6 month period. (tried to get the 6 month period to return on the prior query and having difficulties with those crazy dates- so no worrries right now for that), so using the fields that I have that would result in what data is needed this is the sql for this query
SELECT ER_Hosp_visits_6mos.person_nbr, ER_Hosp_visits_6mos.last_name, ER_Hosp_visits_6mos.first_name, ER_Hosp_visits_6mos.date_of_birth, ER_Hosp_visits_6mos.encounterDate, ER_Hosp_visits_6mos.encounterType, ER_Hosp_visits_6mos.hospitalAdmitDate, ER_Hosp_visits_6mos.sx_procedure2, ER_Hosp_visits_6mos.year_dx, ER_Hosp_visits_6mos.year_px, ER_Hosp_visits_6mos.disease, ER_Hosp_visits_6mos.disease2, ER_Hosp_visits_6mos.create_timestamp, ER_Hosp_visits_6mos.modify_timestamp
FROM ER_Hosp_visits_6mos
WHERE (((ER_Hosp_visits_6mos.encounterType)="Emergency Room")) OR (((ER_Hosp_visits_6mos.encounterType)="Urgent Care"))
ORDER BY ER_Hosp_visits_6mos.encounterType;
WHERE (Person_nbr IN (SELECT Person_nbr FROM ER_Hosp_visits_6mos GROUP BY Person_nbr HAVING Count(*) > 3));


it is returning an error that characters found at the end of the SQL statement and it goes to the WHERE prior to the person nbr info in the second to the bottom line of the query

I am going to now give up until Monday :)
Patty



---In MS_Access_Professionals@yahoogroups.com, <pattykf@...> wrote :

changed the subject but kept the old message to have hx.
yes there is a unique ID for the patient so I will look at doing this. I really appreciate your help. You are a great resource, I will give it a shot on Monday, and let you know how it goes.
thankx
Patty
Director of Quality
WellOne Primary Medical and Dental Care
Rhode Island, USA


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Patty-

You should start a new thread for a new problem.

What is the SQL of the other query?  What are the fields in the hospital encounters table?  If there is a unique ID for PatientID, then you could do something like:

SELECT PatientID
FROM Hospital_Encounters
GROUP BY PatientID
HAVING Count(*) > 3;

If you want patient details, perhaps something like:

SELECT Patients.PatientID, Patients.LastName, Patients.FirstName, 
   Hospital_Encounters.TreatDate
FROM Patients INNER JOIN Hospital_Encounters
ON Patients.PatientID = Hospital_Encounters.PatientID
WHERE PatientID IN 
  (SELECT PatientID FROM Hospital_Encounters
   GROUP BY PatientID HAVING Count(*) > 3);


John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 5:28 PM, pattykf@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

THANK YOU!!!!!
there was a space that caused the error, it now works
YOU ALL ARE WONDERFUL, thank you so much!!

are you up for another challenge?
I have a query where i would like it to tell me who has had 3  hospital encounters,
the table is only hospital encounters, it would have a unique number for each patient, I am guessing that there is a way to show those with 3 or more with some type of formula, just not sure what that would be
Ideas?


__._,_.___

Posted by: pattykf@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (28)

.

__,_._,___

Re: [MS_AccessPros] Date question

 

We had a dusting of snow yesterday afternoon, but nothing stuck.  Supposed to bet another dusting tonight, but no accumulation.  Typical gray winter in Paris, but we do get bits of sun every once in a while.  Temp hovering around 32F.


John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 5:46 PM, pattykf@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

for your question on the Where last modify timestamp- the field where the last modify stamp is a date and time field, so I found a way to have that one only return the patients seen after jan 1 2013 at 12:01:01 AM, I really wish these electronic health record companies could use one or similiar date formats in their tables, but got to work with what we get.
thank you on this, really helpful, sorry it too so many replies to get to the bottom of it.
Have a wonderful weekend.
We are due for another big storm in my neck of the woods, 8-12 inches snow again in less than a week. oh fun.


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Patty-

Try this:

SELECT dbo_person.person_id, dbo_person.person_nbr, dbo_person.last_name, dbo_person.first_name, dbo_person.date_of_birth, CDate(Left([dbo_person].[date_of_birth], 4), & "-" & Mid([dbo_person].[date_of_birth],5,2) & "-" & Right([dbo_person].[date_of_birth],2)) AS DOB, dbo_person.sex, dbo_person.expired_date, dbo_person.expired_ind, Chart1_filter_24_mos.LastOfmodify_timestamp, Chart1_filter_24_mos.LastOfinsurance1, Chart1_filter_24_mos.LastOfinsurance2, Chart1_filter_24_mos.LastOfPCP_DBP, Chart1_filter_24_mos.LastOfexclude_from_reporting, Pt_Status.description
FROM Pt_Status RIGHT JOIN (dbo_person INNER JOIN Chart1_filter_24_mos ON dbo_person.person_id = Chart1_filter_24_mos.person_id) ON Pt_Status.person_id = Chart1_filter_24_mos.person_id
WHERE (((Chart1_filter_24_mos.LastOfmodify_timestamp)>#1/1/2013 0:1:1#));

I'm not sure what you're trying to accomplish with:

WHERE (((Chart1_filter_24_mos.LastOfmodify_timestamp)>#1/1/2013 0:1:1#));

Is LastOfmodify_timestamp a Date/Time field, or is it a string?  Also, I'm not sure how Access will interpret #1/1/2013 0:1:1# - I'm assuming you want any records later than 1:01 AM on January 1, 2013.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 5:14 PM, pattykf@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

SELECT dbo_person.person_id, dbo_person.person_nbr, dbo_person.last_name, dbo_person.first_name, dbo_person.date_of_birth, dbo_person.sex, dbo_person.expired_date, dbo_person.expired_ind, Chart1_filter_24_mos.LastOfmodify_timestamp, Chart1_filter_24_mos.LastOfinsurance1, Chart1_filter_24_mos.LastOfinsurance2, Chart1_filter_24_mos.LastOfPCP_DBP, Chart1_filter_24_mos.LastOfexclude_from_reporting, Pt_Status.description
FROM Pt_Status RIGHT JOIN (dbo_person INNER JOIN Chart1_filter_24_mos ON dbo_person.person_id = Chart1_filter_24_mos.person_id) ON Pt_Status.person_id = Chart1_filter_24_mos.person_id
WHERE (((Chart1_filter_24_mos.LastOfmodify_timestamp)>#1/1/2013 0:1:1#));

this is the sql query as it stands without the string, it would not let me go to sql with it in the criteria
thank you




---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Patty-

Version shouldn't matter.

With your query in Design view, click the Drop-down under the View button on the far left and choose SQL.  Copy and paste the text you see into a reply.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 4:58 PM, pattykf@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Thank you for the information on replying with the messages,
I actually copied and pasted your string right into my query so as to not put in extra spaces etc, but still get an error it goes to the L in left again. I am in Access 2007 would that make a difference?


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Patty-

If you're replying on the web, be sure to click Show Message History after you click the Reply button.  That will include previous replies so we can keep track of what has been recommended before without having to go searching on the website.

It looks like you have extra spaces in your expression.  Try this:

RecDate: CDate(Left([dbo_person].[date_of_birth], 4), & "-" & Mid([dbo_person].[date_of_birth],5,2) & "-" & Right([dbo_person].[date_of_birth],2))

The arguments for the Mid function are:

1: String source
2: Offset into the string source to start  (in this case, the 5th character (was an error using 3))
3: Length of the string to extract

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 31, 2015, at 4:26 PM, pattykf@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am sorry but for whatever reason this is not working. the error message (invalid dot or expression clicks to the parentesis before the Left word.

Just to give the info on the situation for those that tried to help but I did not give enough information
I have an access database that pulls in data from our electronic health record, The date fields in the tables are all different and one is a text field that I need to convert to a date field in a query. 
the table is dbo_person and the field is date_of_birth  the dates look like 20150101 in the source table

I have the query set up to pull this field, I entered the following in the criteria field (maybe that is the problem still learning)

RecDate: CDate(Left ([dbo_person].[date_of_birth], 4), & "-" & Mid ([dbo_person].[date_of_birth],3,2) & "-" & Right([dbo_person].[date_of_birth],2))

For my understanding since I am still learning this stuff, what this is basically saying is convert the date, starting at the left of the particular field, take the first 4 numbers and then put in a -, take the 2 middle number and then put a - and then put in the last numbers to get the following 2015-01-01 for example. (not sure what the 3 means in the mid part of the formula)

If there is a good resource that I could go to learn more of this I would be glad to read up more on this. I really want to learn as much as I can about this.
thank you for your patience and assistance.




__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (27)

.

__,_._,___