Welcome to the brand new Therapy? message boards! Find out what’s new or give us your feedback.

Gav Help!!!

#

Started by mrs h in Chit-Chat

Hiya - sorry but I couldn’t bank on you reading GM!

I need to turn 3 numbers back into a short date in Access and I can’t find a function to do it - can you help?

Or any other WoMbles?

It is an emergency :(

Posted on Mon, 26 March 2007 at 11:56

You’re viewing replies 1–18 of 18 by 5 people

·

Page: First | Previous | Next | Last

#1

mrs h wrote:

It’s ok now - I sussed it :)

Posted on Mon, 26 March 2007 at 13:33

#2

hoochalobster (Sarah) Super Moderator wrote:

Smart-arse :p

Posted on Mon, 26 March 2007 at 14:54

#3

deadsetgav wrote:

Ah - you’ll be needing my new email address so you can get on the spot tech help ;)

Posted on Mon, 26 March 2007 at 17:25

#4

Gimme Back My Brainsaw wrote:

i thought for a second the title of this thread was Gay help

:p

Posted on Sat, 31 March 2007 at 17:21

#5

mrs h wrote:

Gav is the great lord of all of WoM, and can help you with anything

What was your question? :)

Posted on Sat, 31 March 2007 at 19:28

#6

Gimme Back My Brainsaw wrote:

GAV, iF you wake up to find a man sucking you off would you let him finish? and if so does that make you gay

Posted on Sat, 31 March 2007 at 19:35

#7

mrs h wrote:

Well I’m sure Gav will be able to offer his divine opinion sooner or later, but if he doesn’t show how about I kill the guy for you in true Toolbox style? (for life on Mars fans)…

*gets ferrets and tools out*

And yes, it does :)

Posted on Sat, 31 March 2007 at 19:47

#8

Gimme Back My Brainsaw wrote:

you big sissy girly nancy man united fan you, hooch’s mum

Posted on Sat, 31 March 2007 at 19:50

#9

mrs h wrote:

It’s true :(

*strokes ferrets and puts beautician tools back in the box*

Well at least I tried …

Posted on Sat, 31 March 2007 at 19:58

#10

deadsetgav wrote:

gimmie wrote:

GAV, iF you wake up to find a man sucking you off would you let him finish? and if so does that make you gay

You should probably stop going to those kinds of parties.

If you wake up and its your dog doing it but you are pretending its a man then yes, probably.

Posted on Mon, 2 April 2007 at 07:33

#11

mrs h wrote:

@ Gav - I have just discovered that attempting to embed an object as described can take up to 200 times more storage than the actual object occupies. It’s not worth the bother, I’ll leave it as hyperlinks - cheers anyhow :)

Posted on Mon, 2 April 2007 at 18:36

#12

mrs h wrote:

What the bl00dy hell is up with this?

It keeps telling me there is a syntax error but I have gone through it a thousand times!

(Excuse the white space - it’s supposed to be for clarity :))

SELECT
Day([last_test]) AS Last_Test_Day,
Month([Last_Test]) AS Last_Test_Month,
Year([Last_Test]) AS Last_Test_Year,
Tests.Last_Test,
Tests.Test_frequency,

/* It’s here that the bother starts …*/

IIF(([Last_Test_Month]+[Test_Frequency]) <=12, ([Last_Test_Month]+[Test_Frequency]),

IIF(AND([(Last_Test_Month]+[Test_Frequency])>12, ([Last_Test_Month]+[Test_Frequency])<=24), ([Last_Test_Month]+[Test_Frequency])-12),

IIF(AND(([Last_Test_Month]+[Test_Frequency])>24, [(Last_Test_Month]+[Test_Frequency])<=36), ([Last_Test_Month]+[Test_Frequency])-24,

IIF(AND(([Last_Test_Month]+[Test_Frequency])>36, ([Last_Test_Month]+[Test_Frequency])<=48), ([Last_Test_Month]+[Test_Frequency])-36), 0)))) AS AddMonths,

FROM Tests;

Please someone find what’s up with it it is doing my f***ing head in!!!!!!

Posted on Wed, 11 April 2007 at 11:05

#13

mrs h wrote:

It’s ok now. I deleted it all in a childish rage and then started from scratch.

*finally remembers to breathe*

Posted on Wed, 11 April 2007 at 12:25

#14

deadsetgav wrote:

What is it you are mixing your SQL with?

SQL should read

SELECT [columns]
FROM [table]
WHERE [condition]
ORDER BY [column]

I dont know where your IIF’s come in?

Posted on Wed, 11 April 2007 at 16:50

#15

mrs h wrote:

Sorry - that was a bit harsh wasn’t it? “Look at this and sort it out” with no explanation at all! :D I tried to email you first but you were obviously lazing about in the sunshine :p

It’s sorted out now, but the IIFs were for calculated fields. Basically the query had to take a given date ([Last_Test])and a number of months ([Test_Frequency]), then add the months to the date and return the resulting date, so they know when the equipment needs testing next.

Does that make sense? Say the last test was 01/04/2006 and the number of months was 12 it was supposed to return 01/04/07. Then it stores it back to the table and flags it when that date comes along.

I’ve snazzed it up a bit too now, it returns the ‘week beginning’ date of the next test, so I’m feeling pretty chuffed with it now! It would be better if I didn’t have only 2 days left to finish the damn project and do loads of other jobs too, though :(

Posted on Wed, 11 April 2007 at 17:03

#16

Gimme Back My Brainsaw wrote:

mrs H, do you by any chance work for the exam board?

Posted on Wed, 11 April 2007 at 21:24

#17

andys gibson sg (James Harris) wrote:

yea i thought it said ‘gay help’ too.
i wonder what that means?! lol

Posted on Wed, 11 April 2007 at 21:31

#18

deadsetgav wrote:

mrs h wrote:

Sorry - that was a bit harsh wasn’t it? “Look at this and sort it out” with no explanation at all! :D I tried to email you first but you were obviously lazing about in the sunshine :p

Close - I’m on holiday this week ;)

Posted on Thu, 12 April 2007 at 07:36

There are no more replies in this discussion. (Go to the homepage)

to post a reply. Sign in if you’re already a member.

You’re viewing replies 1–18 of 18 by 5 people

·

Page: First | Previous | Next | Last

Other discussions started by mrs h

Title Replies Started Last post
Another weirdy game in Other Bands & Artists 1,307 19 Jun 2007
by mrs h		 Yesterday, 22:15
by Gimme Back My Brainsaw
Vent your spleen! :mad: in Chit-Chat 1,508 30 Aug 2006
by mrs h		 Yesterday, 18:51
by deadsetgav
General Celebration and Announcement Topic in Chit-Chat 104 17 Sep 2007
by mrs h		 17 Aug 2008
by marja
hotmail crap in Chit-Chat 20 3 Aug 2008
by mrs h		 8 Aug 2008
by mrs h
Caption Competition :D in Chit-Chat 261 27 Sep 2007
by mrs h		 30 Jun 2008
by Divers

View all 23 discussions started by mrs h.