Thank you very much.

compile error: User-defined type not defined

Sue_H (12/12/2016)

---

Is this just tables or what else do they need to change?

If you want them to be able to execute any DDL in the database then you would...

Thank you , btw. sometimes has column2 value = NULL and result is also NULL. I this case I want to put date from column1.

WendellB (11/16/2016)

---

Is there a reason you posted this in the Microsoft Access forum? The responses deal with dates the way SQL Server handles them. Access does things a...

Hi, thank you for your thoughts, the second diagram is more interesting for me.

okay but what is better? to have 3 tables separated or create one table... but, than I must create 3 relationship from...

Thank you Martin.

Thank you very much !!!

Thank you Luis, I would need something on Access, some tips how to do it, I hope I will find something.

Response to your first questions:

1. I don't know how the first week of the year is calculated.

2. I understand that the result is 49

Sorry 🙂 , I just wanted to find some solution (example!) how to do it, I expected solution from your side, but you are always writing about first week.

Week...

Let me explain what I need.

Based on last day in month I found week number via function DatePart("ww", 30.11.2016) result is 40 or other. It does not matter.

The task is...

I dont need to define week 1. I know week, year, day and I need to get back date.

ok done, I just created copy of the field I wanted to have for barcode, set font, and source as before.

Fortunately everything works.