database query

Hi. I'm having an intermittant problem with Excel 2010 which for some reason is pulling out a value of #n/a rather than the actual value in the field in the source data: Data Structure/Flow: ----------- Microsoft Access Table 1 -> SQL Database Query -> Excel Workbook A, Sheet 1 Excel Workbook...

I have recently upgraded my machine from Windows XP to Windows 7. I have DB2 and Microsoft 2003 installed in my system. I am trying to create a new database query using Microsoft Query. I have tried out following options so far: 1. Added a data source using Configuration Assistant. I am able to...

Good Morning, this is my first forum, so please bare with me. I am producing a tracker for some people so that we can track and update any training that we need to complete and know when we need to complete it. What i am looking for is as follows. I a to have a database (I have made already)...

Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’ll try to explain this as best I can… <o:p></o:p> I need to create a database of individuals and their associated team names, location, positions, contact details etc using Excel 2003. Unfortunately we...

I have a spreadsheet with following columns - User ID Age Height Body type Complexion Diet many other like this I want to create a database such that, For E.g. if someone selects age between 23 to 26 and height 5.6 to 5.9, body type as average, then it should pick all filtered data (as per...

Hi - hope someone can help..... I have made a database query to return data from another excel worksheet (all in excel 2003, and on Windows XP) It's fine EXCEPT that some of the columns in the external datasource worksheet contain text rather than numbers. The query returns these as blank while...