Search results

Hi, I have an update query whereby if it matches criteria it updates a date using dateadd which looks like the following: DateAdd("m",1,[ReportDate]) Now for some reason it updates it to 01/07/2013 (ReportDate was set as 01/12/2011) - I have no idea why because the criteria for the update...

Hi, So what I'm looking at doing is getting dates for the current weeks Monday and Saturday. I think what I'd need to do is look at todays date say that came back as Thursday 19/1/2012, I then would want it to get me Monday's date and Saturday's date and put them in the necessary field for...

Hey, So basically I have a update query whereby I have a stored date that I want to compare against today's date and if it's smaller, then update some fields. Now I want it to actually be a month later than the stored date so something like this: [StoredDate]+31 < Date() then... blabla. For...

Give up, formatting won't stick it and it makes it incredibly difficult to explain. Please delete.

So basically I've got a couple of tables setup like so: tblGroup: GroupID Group tblStudent: Student Number Usual stuff, firstname, lastname etc. tblGroupLink: StudentNumber GroupID Primary Group What I want to do is setup a form that has a list box containing the groups and then select one...

Hey, So I'm basically creating a query that I want to do a Date Add function in. I'm trying to calculate a date based on a field in the query, while using another field that contains the amount of years that I want to increase it by. Brief description being: Warranty: e.g. 4 InstallDate: e.g...

So I'm trying to compare some days of the week. Basically I have a table that has a field called "DayRan" and this contains a day of the week monday, tuesday etc. Then what I'm trying to do is compare it in a query against todays date using Date() formatted as "dddd" so that I can see what runs...

Hi Guys, So basically I'm trying to create an update query and for the life of me can't workout why it's not working. Basically I have two tables Asset and IP. Asset uses a lookup to lookup the values from the IP table for IPs. Now in the IP table I have a yes/no field named "In Use". What I...