Online Database Query Issue

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

Guest

I have a functional online database that captures numerical data from about
300 users. The data is displayed on two different confirmation pages. The
first page is "detailed" data that shows all user input. The second
confirmation page is generated by running a query against the database
matching a specific user. The query provides subtotals of various data
points. Here's my problem. The query confirmation fields are automatically
rounding up to the nearest whole number though my confirmation fields are set
as numbers rather than integers. Can someone help me fix my summary
confirmation fields to reflect numbers rather than integers?
 
I actually can't find (although I've looked a lot) an exact piece of SQL code
that addresses the "numbers" conundrum. I've found all the info on time,
date, % etc. but nothing on numbers per se. Can you provide an example.
thanks, dab
 
Actually, I'm using the DBRW to display results on a confirmation page. I
need to format the results as you've pointed out but the Wizard doesn't seem
to have a place to put the correct SQL statement re: formatting. Any thoughts?

dab
 
You can do a custom query through the DBRW. Will that help you with the
correct formatting issue?
 
Back
Top