Search results

In the code I ignored the year and took out only the day of the month =Day([startdate]) I have another field that calculates months. In the end it looks like this [paypermonth]+[paypearday]

First of all, thank you My code works if there is no 31 it refers to whatever is smaller But anyway I did use the code you suggested only I had to add fields because I have an entry date and an exit date so i add one more code =IIf([startdate]>=#01/04/2024#,[paypaerday],[amount]/30*[daypart])...

The students have an arrival date, from here it automatically calculates for them the amount according to what was agreed monthly and the days of the month according to the departure date, the default of which is the first of the current month, that way I know how much payment was received and...

Because from 02 to 14 nothing will happen as I understand the code And I will have to activate the code only from 01.04.2024

I didn't understand your solution

Hello I was asked to make a change in the code I am currently calculating how much a student should pay per day =IIf(IsNull([Form]![extday]),"0",[amount]/30*[Form]![extday]) where [extday] is the calculation of how many days the student was present in the month by the Diff2Dates function What...

I will explain more clearly. This table is a linked table in my database. The original table is replaced several times a month by the finance department. They simply delete the table and paste a new one. This is not in my hands, although I am working on a new financial system that will remove my...

You described it as clearly as possible, this is exactly my problem that 10 is called 01 and is therefore smaller than 9. I can't change the field, but I understood from your words what I can try to do. Thanks, I'll try it later

They set the field as a short text and set the months 1-12 in it. This information comes from the bank to another database. I just pull the data from the table. Group by MAX works from 1-9. What value does he see in 10-12? Which means I have to write code that makes the digits 10-12 bigger than...

its work fine from 1-9 but 10-12 are read as different values

what? Are you aware of what you are answering? The table is a linked table on a server on another database that I have no control over. I am only linked to the table and only now that I was asked for additions to my software I notice it

there is no code just a simple query with text field for the months and i can't change the field to number

A simple query is built from five fields with grouping by

Thanks I get a mismatch error where do I put the expression in the query

Hi I have a problem I am trying to filter a query using the MAX function I need to pull results of the latest month and year in the records the year field is the number the month field is text (problem I know) in months 10 11 12 I get one record of each year in all the other months I Gets full...

hi: i'm not an expert in excel more in access i build a worker howers report i build a month and year changing automatically A=Current date in the month B= Current day name work time are fixed value a cell that wan i enter the month number the day change according to the date first how do i...

thank you this is great

i did listened but sometimes you have to answer Q' that no one try to did before in access because that what the client ask for and client is always right .i can say no this forum help a lot before so i keep Ask here Q' And the form is for viewing only

ok I solved it in another method I put the original query as a subform and on Form_Load "If [sfQryrooms].Form!" place,room,bad=

label dont have Conditional Formatting i will have to do it on textbox