Try expressions like these in the Field row in query design: Year([ReceiptDetails].[CDate]) Month([ReceiptDetails].[CDate]) Day([ReceiptDetails].[CDate]) < 16 The 3rd one returns True if the day-of-the-month is before the 16th. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne
Subtract 1 from the month number, and then perform integer division by 2. This will give you a value from 0 to 5 representing the pairs of months in the year. So, something like this: PARAMETERS [Forms]![OpeningPage]![List21] DateTime, [Forms]![OpeningPage]![EndDate] DateTime; SELECT Year([ReceiptDetails].[CDate]) AS TheYear, (Month([ReceiptDetails].[CDate])-1) \ 2 AS TheBiMonth, Sum
"Young 8" <zoro771@tin.it> ha scritto nel messaggio news:42f4a8ae-0aaa-46a7-be83-3b2ad1519bfd@m73g2000hsh.googlegroups.com... 4-0 DEMOLIZIONE Grande Djokovic bisogna riconoscerlo, oggi tutto perfetto, si è preso la rivincita dell'umiliazione di Parigi, Nadal manca il numero uno non entrando in finale o sbaglio? c'è da aggiungere che nadal sentiva la pressione e probabilmente sentiva
In message <2bf3adfe-0aaa-4cef-aab9-63fd79958944@j22g2000hsf.googlegroups.com>, GM <g-mc@hotmail.co.uk> writes As you don't have a working life, Rabbie, you are hardly in a position to know if someone is "projecting" theirs. When did you last do a day's work? That's because I am retired. Next! RH Eh? Q - "When did you last do a day's work?" A -
On 20 Mar, 16:50, "LaStampa B&W" <lasta...@interfree.it> wrote: "Dark Schneider" <dark.schneide...@gmail.com> ha scritto nel messaggionews:778fffb4-0aaa-4813-aeaf-ff093a7d4da4@b1g2000hsg.googlegroups.com... tra l'altro frega na cippa ma è la seconda volta che in annusamento nazionale sereni si fa male e dark fa la rima Dici che è l'azzurro a portare sfiga...? No, perchè ho
