Recent content by rfear

Re: How do you convert week # back to date? I see. ... so I can't just use a year and a week then ? ... will have to give this some thought, because the week number keeps resetting itself each year ( 2006, 1-52 : 2007, 1-52 : 2008, 1-52 etc ). It's not as easy as putting a stick in the ground...

Re: How do you convert week # back to date? I'm confused :confused: ( it happens quite often :) ). I don't see how the syntax converts a year number ( e.g. 2009 ) and a week number ( e.g. 12 ) into a date, for example the Monday of the week ( 16/03/09 ) ? I've tried various formulae but they...

Re: How do you convert week # back to date? Was this ever solved ? I have year and week number that I want to convert to Monday of said week/year. For example, year = 2009 week = 13 date = 23/03/09. Rich.

Cool, worked a treat. Thanks.

I want to merge two queries into one ( see attachment ). I've unioned queries before but only when one field has matched. This problem needs to match 2 fields. Basically I want all the fields in NEWQRY_SUMRATES but only the fields Resource Whole and Availability from NEWQRY_DAYSBOOKED where Yr...

Week Ending: DateValue(Format((Right([Ident],Len([Ident])-3)),"dd/mm/yyyy")) Sorted :)

Week Ending: Format((Right([Ident],Len([Ident])-3)),"dd/mm/yy") OK, the obvious attempt has not worked. Ident : Week Ending JJ1-12-2007 : 01/12/07 JJ2-9-2006 : 02/09/06 JJ1-11-2006 : 04/11/06 When I sort in ascending order it is putting all the 1st...

(Thanks. I'll give this a go when I get into work tomorrow.) 09/01/09 - Almost working. The expression does as expected but I suspect the answer it gives is not in date format as when I go to sort the field in ascending order, it doesn't. I'll have a play around and see what I can do.

I am linking to another database and want to convert this field JJ3-1-2009 into a date field 03/01/09 by losing the first 2 characters. Any ideas on how to do this ?

Huuummmm, sounds interesting, also sounds complicated. I've gone for the cheats ( swift ) option and redesigned the form to fit on A4. Thanks.

I have designed a report to fit on A3 paper. That was fine until the database was housed on a PC with only an A4 printer. Printing is irrelevant as the database actually distributes the reports as a snapshot by e-mail, nothing is actually printed. So how come MSAccess has no intrinsic idea of...

Re: Union Query and Count At Same Time ( Solved ) Last piece of the puzzle ( modification to qry4 using SUM instead of COUNT ), SELECT Year([JOBDATE]) AS Yr, Val(Format([JOBDATE],"ww")) AS Wk, Sum(qry3.[Arrival Rate]) AS [SumOfArrival Rate], Sum(qry3.[Departure Rate]) AS [SumOfDeparture Rate]...

I will take a look later at your attached database, thanks, work can get funny about downloading stuff off the net. In the meantime I have had a blinding flash as to how to merge the two tables. I can set up a query that changes the field names to common names and at the same time populate the...

Huummmm.... I tried 'DISTINCT' but I lost one of my records, mind you the original approach is not correct. Close but no cigar.

Righty o. I'll keep playing then and post the answer I come up with for future posterity. Thanks.