Results 1 to 2 of 2
  1. #1
    saffar is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    5

    Query error date are mixed up

    Hi everyone




    I am getting error while running the query


    It have two tables the table for attendance data from Microsoft Teams table name meetingAttendanceList
    The other table is student master table st_mstr ,
    I am unable to eliminate the duplicate when i run query because of multiple records for a student joined and left
    and other problem when i run the same query (qry group and date) there is a formula to extract date from text field also not able to get the correct report for a particular date and group dates are mixed up
    attached sample file

    Attached Files Attached Files

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Tried to D\L you file but get error trying to unzip saying it is empty or corrupted.
    Try uploading it again
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

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

Similar Threads

  1. Replies: 4
    Last Post: 04-21-2015, 07:12 PM
  2. Getting mixed up with nested If statements
    By tonygg in forum Access
    Replies: 3
    Last Post: 03-28-2015, 08:53 PM
  3. Replies: 4
    Last Post: 11-11-2013, 01:42 PM
  4. Replies: 5
    Last Post: 12-15-2011, 11:16 AM
  5. Data mixed up
    By neo651 in forum Access
    Replies: 3
    Last Post: 09-28-2011, 04:05 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