ya5irha55an
Registered User.
- Local time
- Today, 11:30
- Joined
- Sep 20, 2005
- Messages
- 20
Hi, I hope someone can help me with this little problem:
I have a query which calculates the number of hours between 2 dates, which are stored in a separate table. The query works fine, and gives me number- the prblem is the table which is created by the query sets the fields to 'TEXT', hence the number is not recognised as a number. I then run a database query from excel to import the data, but as the field are text it recodnises the numbers as text as well.
What I need is to set the query to make the fields of the table 'number' instead of text- i have tried changing the property value of the fields in the query to 'general number;, but this has no effect. Any ideas?
I have a query which calculates the number of hours between 2 dates, which are stored in a separate table. The query works fine, and gives me number- the prblem is the table which is created by the query sets the fields to 'TEXT', hence the number is not recognised as a number. I then run a database query from excel to import the data, but as the field are text it recodnises the numbers as text as well.
What I need is to set the query to make the fields of the table 'number' instead of text- i have tried changing the property value of the fields in the query to 'general number;, but this has no effect. Any ideas?
