Search results

My table is called "table A". There is a date field in this table called "1st Date Issued". My Form accesses this table, and I would like to write an expression which looks at all the entries in my table, and if "1st Date Issued" is more than 14 days ago, then to bring up a MsgBox. I thought I...

thanks. I came up with =DateAdd("d",7,[Start Of Year]) which seems to work OK

thanks. I came up with =DateAdd("d",7,[Start Of Year]) which seems to work OK

My table has a {start of year} date in the format “dd/mm/yyyy”. I need to pick this up as ‘week1, and then add 7 days, for a whole year, so that I can display :- ‘week2’, ({start of year} + 7 days) ‘week3’, ({start of year} + 14 days) etc, etc, right up to ‘week52’. Is there an...

My table has a {start of year} date in the format “dd/mm/yyyy”. I need to pick this up as 'week1', and then add 7 days, for a whole year, so that I can display :- 'week2', ({start of year} + 7 days) 'week3', ({start of year} + 14 days) etc, etc, right up to 'week52', or 'week53' in a...

Hi I no longer need this level of access as the sources will now be held elsewhere. Thanks anyway for the advice, which may come in handy later. ;)

Is it possible in a Form for there to be a command button, or something similar, that, when clicked, sends the user directly to a unix session ? The table item being displayed in the Form matches a source file in a unix environment. By clicking the button, I want to be able to either navigate...

I have table 1 (t1) with 2 fields (f1) & (f2). I have table 2 (t2) with 2 fields (f1) & (f2). I have a one to many relationship set for t1.f1 and t2.f1. I need to design a form to show these records, with all occurrences of t2.f2 on the same screen as t1.f1 & t1.f2. I thought I could use a...

I am writing a report for Access using ACE reports. My final select looks like this :- Select A, B, count(*) as countx from {temp table} Group by A, B Order by A, B The rows look like : A1 b1 14 A1 b2 7 B1 b3 8 B1 b4 4 B1 b5 3 etc etc I would like the display below ...