Search results

@plog I'm not sure what logic the client is using, what I noticed is: Each week starts with Sunday and ends with Saturday. There are never incomplete weeks. All weeks have 7 days The year preceding a leap year is always 53 weeks long. The remaining years are 52 weeks long. Periods: Week 1-4...

Hi all, I'm not trying to create my own function :). I would like the function to be able to calculate the weeks as in the attached calendar. This is only the part of the calendar that includes only customer's weeks & periods. The second part is to include my employer's weeks and periods. If I...

Thanks again to everyone for your help. Sorry to reply so late but I have been given other high priority tasks to do... So far I am in the process of building an Excel formula that will be able to convert dates into weeks. Creating such a formula in excel / access function isn't so easy because...

@MajP , @theDBguy Thank you both for your very quick reply. In Excel, I had everything in one table and I was hoping that I will do the same in MS Access, but since I'm using Access, I'll have to start thinking a little differently. Due to fact we have introduced the dates, I will probably...

Hello, Some time ago I started building a database in Access. It was supposed to replace the spreadsheet that is currently in use. The data database will have various projects listed and savings reported weekly for each project. Each project is usually reported over 52 weeks period, i.e. if the...

A few days ago I was looking for the SQL query with distinct to remove duplicates. I don't know why I didn't manage to do it correctly. Today I have created the query using "Query Builder" I just replaced "select" with "select distinct" and it works. :) I still have to learn a lot. Thank you...

I managed to create Cascading Combo boxes in a new database but I can't run it in my current database :( All this works but only partially. I get a list of departments for a particular site, but the same values appear many times (about 16 times :eek:). Does anyone know what I'm doing wrong...

Hi, I'm sure of it. Access already gives me a headache, but I know that if I overcome some difficulties and learn the basics, then it will be like driving downhill. I'm sure that I found the best forum that will help me in all this.

Hi Colin :), My current way of working that is my first step for my own Brexit. From the New Year I should be working only from Poland but I'm afraid that it starts to look like UK (T. May) Brexit ;) I'm keep to come back to England like a boomerang.... The dates of my final Brexit are starting...

Thank you for the very quick reply. I will try to solve this problem again tomorrow morning or tonight. At the moment my head needs some rest because all these problems are arising from nowhere. As soon as I will test it, I'll let you know if it worked for me. Thank you again and best...

Hi all, I need support from access experts as I am trying to build Access Database and at the beginning I have a problem with building the table correctly. I have to tables: tblDepartment and tblDataEntry with columns as below: tblDepartment ID Site Dept 1 London...

PL means Poland. "Poland officially the Republic of Poland is a country located in Central Europe" ;) PL / UK because I am currently working between these two countries and I spent half my life in each of them. So in this case it's not a post code. :)

Hi to all, My name is Lucas. I joined this forum because I would like to learn how to create advanced databases in Access. Unfortunately, I'm just starting my adventure with this program but I believe that with your help I will be able to quickly spread my wings. I already have experience in...