Results 1 to 2 of 2
  1. #1
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47

    i want to type the moon phase percentage first in the box


    I have this code below that when I enter the 3 digit number when the pop up box comes up. Now I know want to change the code below to enter the moon percentage from the moon percentage table

    when the pop up box comes up. Please help me I want to change the code below so that the pop up box will ask me to input the MoonPhase Number first. Thank you

    SELECT T1.YourNumber AS [Operative Number], T1.YourDate AS [Operative Date], T2.YourNumber AS [Related Number], T2.YourDate AS [Related Date], M1.YourNumber AS [Moon Phase Number]
    FROM YourTable AS T1, YourTable AS T2, MoonPhaseTable AS M1
    WHERE T1.YourNumber = [Enter Number:]
    AND T2.YourDate >= T1.YourDate-2
    AND T2.YourDate <= T1.YourDate+2
    AND T2.YourDate <> T1.YourDate
    AND M1.YourDate = T2.YourDate
    ORDER BY T1.YourDate, T2.YourDate;

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the criteria under [Moon Phase Number]
    add
    [Enter Moon Phase#]

    (I think that's where you want it)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2015, 09:25 PM
  2. Percentage
    By azhar2006 in forum Queries
    Replies: 3
    Last Post: 11-15-2014, 02:22 PM
  3. design phase ... question on multiple entries from same table
    By sbrockett751 in forum Database Design
    Replies: 2
    Last Post: 03-13-2013, 03:13 PM
  4. Change Percentage Data Type
    By jo8701 in forum Access
    Replies: 1
    Last Post: 02-08-2012, 07:15 AM
  5. Replies: 2
    Last Post: 03-18-2010, 08:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums