> Select keyfield1,excelnumber,productdesc,

> format(testtable1.usage,'nnn.nn') as usage,

> meastype,pressnumber

> from testtable1;

> Works fine in Access. Delphi can't handle it. Maybe I'll give it a try in
> VB.net

> There was some other product I worked with once that had some called a
> passthru query. Does Delphi have this?

> Perhaps Delphi is looking at my query. The problem is that format
statement.
> If I take that out everything is ok,

> except that my usage field comes out with something like 8 places after
the
> decimal point when I only want 2 places

> > Select keyfield1,excelnumber,productdesc,

> > format(testtable1.usage,'nnn.nn') as usage,

> > meastype,pressnumber

> > from testtable1;

> > Works fine in Access. Delphi can't handle it. Maybe I'll give it a try
in
> > VB.net

> > There was some other product I worked with once that had some called a
> > passthru query. Does Delphi have this?

> > Perhaps Delphi is looking at my query. The problem is that format
> statement.
> > If I take that out everything is ok,

> > except that my usage field comes out with something like 8 places after
> the
> > decimal point when I only want 2 places

> Tried it in VB.net. It wouldn't take that Format function either, but it
> didn't matter since
> I got the 2 decimal places like I wanted without any extra effort. Looks
> like I'll be
> converting the application to VB.net a bit sooner that I had figured on.