Search results

  1. M

    Should I use Calculated Fields in Access 2010?

    Hello All, My question is, should I be using calculated fields in my database tables in Access 2010 or will it come back and bite me somewhere down the road? My assumptions are: I don't need my database to be backward compatible so I don't care if it wont run in Access 2007 or earlier. I...
  2. M

    Form with multi field primary Key table not working

    Hello All, I have a form which reads from two tables linked with multiple keys in a one-to-one relationship. Primary Key is based on four fields as follows: ID Year Submission Version On the form I only show (use) ID, since the users don't need to see the other Primary Fields. The form...
  3. M

    Run Access Query from Excel

    Hi All, Im trying to run an access query from excel which takes parameter inputs. I'm using the code from this link modified for my DB http://www.ozgrid.com/forum/showthread.php?t=76848 My problem is the query pulls data from an SQL server connection which prompts for User ID and password...
  4. M

    Query to find the n highest records

    Hello, I have a table which stores information weekly. I have a field called weekly which increments 1, 2,3 ...etc. Id like to query the table for the most recent (highest) 4 weeks. Can anyone help with the sql?
Back
Top Bottom