Search results

  1. V

    Trying to set an iif condition in query criteria

    I have a query that I need to return results for the current fiscal year (runs 1 June to 31 May) for a database of events. I got code help from another forum that I thought would work, but it's returning a blank sheet and I can't figure out why. The sql for the entire query is: SELECT...
  2. V

    Making Normalization seem normal

    Help making Normalization seem normal? I'm really not trying to ask noob questions, I promise I'm trying, but there are just some things I can't get my head around. I've finally got an opportunity to make a database the way I want. The boss who demanded messy database structure is gone, the...
  3. V

    Access 97 won't play with .xls files

    My MS Office had been upgraded from Access 97 and Office 2k to Office 2k7. I had to get Access rolled back to 97, and that worked fine. When I try to import or link an .xls table (created in Excel 2007, but saved as an .xls file), the wizard itself gives me errors. First it says: There is...
Back
Top Bottom