Search results

  1. C

    Filtering

    To bring back both Maximum and Minimum values in the same query you may consider using a Union; like: SELECT Table1.Name, Max(Table1.Number) FROM Table1 UNION SELECT Table1.Name, Min(Table1.Number) FROM Table1 GROUP BY Table1.Name; Chris
  2. C

    Union into Join? How to combine?

    Why can you not create a table structure as follows: unless I have the wrong end of the stick? LevelID Dad_ID Son_ID 1 11 22 2 22 33 3 33 44 4 44 55 You could then run relevant queries against that table. Obviously you would first need...
  3. C

    Crosstab query with dynamic headings

    You could try: TRANSFORM Sum(dbo_PSALES.PeriodSales) AS SumOfPeriodSales SELECT dbo_PSALES.UniqueID FROM dbo_PSALES GROUP BY dbo_PSALES.UniqueID PIVOT BOTTOM (6) dbo_PSALES.PeriodNo; I dont know if this will work or not. Please let me know if it does. Chris. :)
  4. C

    Union Queries

    If you decide to stick with the IIF statement: I noticed there was a missing comma; as below. Change this: to this: CY: IIf([Pay Period End]<=#10/25/2008#,"CY08",IIf([Pay Period End]<=#10/24/2009#,"CY09",IIf([Pay Period End]<=#10/23/2011#,"CY10",IIf([Pay Period End]<=#4/23/2011#,"CY11"))))...
  5. C

    User Login form and session

    You could create a Module that declares global variables. Then use these variables to store Username and various Authorisations. You would use the OnLoad event with in the first form that opens in your database. Your Global variables would then be available throughout your database project.
  6. C

    Quit/Close External Database..

    Must admit, did have a look. But, I am unable to create and run batch files do to system restrictions. Pesky critters. :)
  7. C

    Quit/Close External Database..

    No worries. Once I had passed that part evreything else fell into place. I can now automatically update out versioned MDE files. Just need to implement it into the correct database now. Again, cheers. One happy chappy sat here. :D
  8. C

    Quit/Close External Database..

    DJKarl and JohnLee, cheers for the hint and for the slight change in direction required. Unfortunately, the 'Shell' command was blocked on my system but using the API version worked. Here is the code I used: Option Compare Database Private Declare Function ShellExecute Lib "shell32.dll"...
  9. C

    Quit/Close External Database..

    Hello all, :) I'm having an issue with quitting/closing an external database. Scenario: DB1 goes through some version checking DB1 is the wrong version DB1 calls DB2 DB2 tries to Quit/Close DB1 <-- Fails here DB2 Deletes DB1 DB2 Copies new version DB2 opens new version DB1(new version)...
  10. C

    Hello to all.. :-)

    Hello all, Through-out my time using Access databases, I've often come across this site for getting myself out of sticky situations. Over time, I hope I can help those in need; in effect give something back from what I have gained. Cheers all. :)
Top Bottom