Recent content by georg0307

  1. G

    EXACT NUMBER OF HOURS BETWEEN TWO DATES AND TIME

    Ciao, sorry I think, I don't understand.
  2. G

    EXACT NUMBER OF HOURS BETWEEN TWO DATES AND TIME

    Ciao, thanks a lot for help. but I have to add the number of Days because it doesn' calculate over 24 hours, or may be I am doing something wrong. Georg
  3. G

    EXACT NUMBER OF HOURS BETWEEN TWO DATES AND TIME

    Hi all, I have the following query/sql that unfortunately doesn't calculate the exact number of hours between "Date1 Hour1" and "Date2 Hour2". If the result is under 24 hours it works but if the time that pass is over 25 26 27 28 hours it says too long to be displayed. How can adjust thais...
  4. G

    MS ACCESS 365 AND ONE DRIVE

    Hi everyone, here at our company, we have several shared Access databases. At the same time, we are migrating all our files and folders to Onedrive. I have a few questions for you: What will change? Will they still function properly? Are there any precautions we need to take? Thank you in...
  5. G

    Solved SPECIAL TRANSPOSE DATA

    Something really great thanks a lot!!! PERFECT REALLY good -GREAT!!! Many thanks.
  6. G

    Solved SPECIAL TRANSPOSE DATA

    Dear All, is a way to obtain the result from a starting table, what I am showing in the attached file? EXAMPLE SIMPLE: STARTING TABLE: A 1 APPLE A 5 ORANGE B 2 TRUCKS B 5 CARS RESULT NEEDED: A 1 APPLE 5 ORANGE B 2 TRUCKS 5 CARS...
  7. G

    Need suggestion for layout input from barcode scanner

    Dear all, apologies for my lack of knowledge. I'm trying to create a form where hundreds of HUs can be input using a barcode reader and maintain focus and visibility on the new record, so it doesn't get hidden under the form (in the center of the screen). The database will be used on a 20"...
  8. G

    Solved Looking for advanced Vlookup

    Hi you are really fantastic!!! But I can try to use it in access with 2 different tables as Sheet?
  9. G

    Solved Looking for advanced Vlookup

    Dear All, I am trying to find a formula similar to vertical lookup that searches for partial text in column "A" of "Foglio2". The goal is to match the partial text in column "A" of "Foglio1". I tried using the formula =CERCA.VERT(""&A2&"";Foglio1!$A$1:$D$768;2;FALSO), but it doesn't seem to...
  10. G

    Solved QUERY - Data only from the last working week

    Hi, I used this: Between DateAdd("ww",-1,Date())-Weekday(Date(),2)+1 And DateAdd("ww",-1,Date())-Weekday(Date(),2)+7)) Thanks to All, it works!!!
  11. G

    Solved QUERY - Data only from the last working week

    I receive back this error
  12. G

    Solved QUERY - Data only from the last working week

    I receive this error
  13. G

    Solved QUERY - Data only from the last working week

    I receive back a message in Italian that the function is not defined what am i doing wrong?
  14. G

    Solved QUERY - Data only from the last working week

    Ciao, Fast & Furious (INCREDIBLE!), I will try.
  15. G

    Solved QUERY - Data only from the last working week

    Dear All, in a query how do I set data only from the last working week? i.e. Monday to Friday without putting dates. I have this SQL but it doesn't work: SELECT [2021].Date, [2021].ECO_LABEL, DatePart(weekday, [Date]) Between 2 And 6 AS Weekdays FROM 2021; Thanks in advance best regards Georg
Top Bottom