Search results
-
C
Fill multiple date fields in the form with the first value
Yep, that did the trick. Only needed to change the , in a: DatePart("q", [Field 1]) to a ; like a: DatePart("q"; [Field 1]) but that is probably because I'm using Access 2013. Ty for your help 2 thumbs up! -
C
Fill multiple date fields in the form with the first value
Why I need it hard-coded is because of the query I"m running. A total noob must click on a report and only has to awnser 2 questions from my query: what year, and what quarter they want the overview from. Now I don't know how to learn 12 people how to query and mess up or fix the database in a... -
C
Fill multiple date fields in the form with the first value
Ty so much! I tried, but its not working. I changed it in the table right away, with calculated fields. So I made a field for the quarter =([Data]) and changed the view to 'q' Same with Years (Renamed the column :p) and then in 'YYYY' Now that only masks the date, but I need it hard coded... -
C
Fill multiple date fields in the form with the first value
I have a table where I use 3 date fields in, all with different views. Field 1: Date as dd/mm/yyyy Field 2: Quarter: q (shows the same date, but then as quarter of the year. Field 3: Year: YYYY Now I have a form that fills all of my fields, but is there a simple way (:banghead:) to populate...