Query Formats

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

Guest

I am accessing a table with about 25 different fields. When I access a field
called "SOURCE", the output adds a "space" in front of the output. How do I
eliminate the space?

Thanks.


Dave
 
I am not sure if this is what you are looking for but I copied it from "SQL
View"

Thanks for your help.


SELECT MLD30_LMT_LBLHIST.CORP, MLD30_LMT_LBLHIST.ACCOUNT,
MLD30_LMT_LBLHIST.JRNLID, MLD30_LMT_LBLHIST.EFFDT, MLD30_LMT_LBLHIST.POLICY,
MLD30_LMT_LBLHIST.SOURCE, MLD30_LMT_LBLHIST.SLAC, MLD30_LMT_LBLHIST.AMTS1
FROM MLD30_LMT_LBLHIST
WHERE (((MLD30_LMT_LBLHIST.CORP)="LBL") AND
((MLD30_LMT_LBLHIST.ACCOUNT)="29406") AND ((MLD30_LMT_LBLHIST.EFFDT) Between
#1/1/2005# And #1/31/2005#));
 
Back
Top