Search results

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

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

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...

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...

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

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...

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"...

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

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...

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!!!

I receive back this error

I receive this error

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

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

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

Ciao, ok I understood my error thank you very much!!! SOLVED

hHi, sure I am wrong, at this point I give you my DB because it doesn't work well. it give me back in the textbox 2 numbers... 13 and 14.

Dear all, I have a table with filed "Shipments", with i.e. the following records: 1234567 5432188 2345678 5555555 in need in a textbox in the report that shows the data concatenated: 1234567_5432188_2345678_5555555 And in second moment name a PDF output with this text...

Thanks, to all, solved:

Dear All, from this simple access DB I need a way to remove duplicates, I mean the value must be unique. So if a value is present several times, must be only one value, not deleting all of them. Is it possible to create a button that performs this operation? Thanks in advance.