Query info from a form

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

Guest

Hello:

I am creating a query in which some of the data will come from tables and
other data will come from a form. It works to a point. When I select text
info from the form it comes up in the query without a problem. When I select
Date and Yes/No data nothing shows up for the Date feilds and the Yes/No data
shows up as a small square. I've been trying to change formats to make this
work without success. Any ideas.

Thank you,

Robert
 
Robert,
Are you making the query using the standard FP database results or
hand-coding it? Also, which server-side technology are you using, classic
ASP or ASP.Net? Something to keep in mind is that you may have to perform an
extra operation to get the data out correctly. For example, Yes/No data is
stored as a binary bit with only two states, On or Off. If you're getting a
funky square that usually means a bit of binary data. It could be that you
are getting a binary 1 or 0 instead of it translating into something
meaninful. Which database are you using as that may also help in figuring
out a good way to help you out here.
 
Back
Top