| Chat with a LIVE Microsoft
Access Expert! |
||||
|
|
|||
|
||||
|
||||
|
#1
07-13-2006, 04:05 AM
|
|||
|
|||
|
Setting query table to Number format
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? 
|
| Sponsored Links |
| Sponsored Links |
 |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| auto update field - form to table | Old Timer | Forms | 2 | 06-24-2009 08:58 PM |
| Creating table based on a query | JoshuaAnthony | Modules & VBA | 8 | 02-25-2004 11:20 AM |
| Setting Table Format Property | swbrodie | Tables | 2 | 05-15-2003 12:34 PM |
| Help - Make Table Query | petewood69 | Queries | 2 | 11-27-2002 09:43 AM |
| change to date format in Make Table Query | asp_learner | Queries | 1 | 04-16-2002 01:00 PM |
Linear Mode
