Search results

  1. F

    Query doesn't take records with the oldest Date

    Hello everyone, I am writing for show my issue with a query. I have two tables : "Order" & "Stock". Table Order have "Code Number" Table Stock have "Code Number", "Serial Number", "Date" I'd like to create a query that takes the serial number that belong to the Code Number, and...
  2. F

    DateDiff Error Why?

    Hi, I have two dates, Shipping Date and Delivery date... I wrote this on a query Select ID CoDe --> from Table1 --> where (DateDiff("d",[table1].[shipping Date],[table1].[Delivery date],2)>2) What's Wrong ? The Query doesn't work...:(:o:o:confused: Thank You
  3. F

    Calculations with Queries

    Hello everyone, I still need your help ... I have two tables "A" & "B" ... "B" is the result of a selection of "A ". I would like to count how many times is the name "Mickey Mouse" in the "B" and how many times has this in the "A" and then calculate the percentage of presence with the...
  4. F

    HELP for a Query check calendar

    Hi to all, I need to know, how can i have a control about a kind of a day (Work day or Holiday Day) I have to know if the day in a table "A" was Friday,Saturday or Sunday; if the day i check is like Friday, Saturday or Sunday, i don't want that day will be into my selection table "B". How...
  5. F

    Hi!! here i am!!!

    Hi to everybody, i am writing from Italy. i work with Access for hobby , i help some friends wich want have a control for their activities. Congrats for this forum is very rich of very precious information!!! :):)
Back
Top Bottom