Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

We are trying to have a filing system where we can put away files by Funding
Date and last three digits of the Loan Number.

For example:
FundDate = 04/05/2005
Loan_Number = 0011111030
BorrowerName = Randall Clemson

Filing Label should look like the following:
Apr-05-030
RANDALL CLEMSON

How can I make the Date format this way on a query? If possible, how can I
combine both fields?

Here is what I have which we tested and work fine but we want it better.

SELECT tblLoans.FundDate, Right([tblLoans].[Loan_Number],3) AS TriDigits
FROM tblLoans;

Jose Aleman
 
there's probably a cleaner way to do this but:

Format ([Fund Date], "mmm-dd") & "-" & right([Loan Number], 3)
 
Thank you very much Chaim. I came close :-)

You saved me a few hrs of hammering my head on the desk LOL

SELECT [FundDate] & " " & Right([Loan_Number],3) AS TriDigits,
tblLoans.BorrowerName
FROM tblLoans;

Chaim said:
there's probably a cleaner way to do this but:

Format ([Fund Date], "mmm-dd") & "-" & right([Loan Number], 3)

--

Chaim


Jose Aleman said:
Hi,

We are trying to have a filing system where we can put away files by Funding
Date and last three digits of the Loan Number.

For example:
FundDate = 04/05/2005
Loan_Number = 0011111030
BorrowerName = Randall Clemson

Filing Label should look like the following:
Apr-05-030
RANDALL CLEMSON

How can I make the Date format this way on a query? If possible, how can I
combine both fields?

Here is what I have which we tested and work fine but we want it better.

SELECT tblLoans.FundDate, Right([tblLoans].[Loan_Number],3) AS TriDigits
FROM tblLoans;

Jose Aleman
Click to expand...
Click to expand...
 
Back
Top