Monthsold
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 4 articles for 0.303 sec
If Evi's suggestion doesn't get you what you want, the I would suggest what I would call a normalization query. Generally, when you get a spreadsheet of data it is dorked up (data as column headers), for my example we will assume that the spreadsheet rows are Items, and the columns are months of the year (Jan, Feb, Mar, ...), and the cells of the spreadsheet are the numbers of items sold     

Group: microsoft.public.access.tablesdbdesign · Group Profile · Search for Monthsold in microsoft.public.access.tablesdbdesign
Author: Dale Fye
Date: May 1, 2008 16:49

Solved it. I used this if anybody else is looking SELECT Format([SQL_DELIVERY_DATE],"yyyy mm") AS MonthSold, Count(*) AS Total FROM tbl_sold GROUP BY Format([SQL_DELIVERY_DATE],"yyyy mm") ORDER BY Format([SQL_DELIVERY_DATE],"yyyy mm"); SQL_DELIVERY_DATE "Steve B" <meinthecorner@gmail.com> wrote in message news:C32FF4A9-443D-4FB7-9E1B-80B815FCCFAD@microsoft.com... Access2000
Show full article (2.25Kb) · Show article thread
That is a calculated field in the query. So you put that in a field "Cell" in the query. If you want the column that is created to have a name other than Expr1 you would enter the column name you want followed by a colon followed by the expression. The expression will generate values 0, 30, 60, 90, 120, etc. The expression is (DateDiff("d",[YourDateField],Date())\30) * 30 --     

Group: microsoft.public.access · Group Profile · Search for Monthsold in microsoft.public.access
Author: Steve B
Date: Jan 8, 2008 09:46

You could use a calculated field. Field: MonthsOld: (DateDiff("d",[YourDateField],Date())\30) * 30 That should --return the number of days between today and your date field --Integer divide the result by 30 giving you 0,1,2,etc --Multiply the result by 30 giving you 0, 30, 60, 90, etc. 0-29 would return 0 30-59 would return 30 60-89 would return 60 etc. If you want 0 to 30, 31 to
Show full article (0.80Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Monthsold in microsoft.public.access.queries
Author: John Spencer
Date: Sep 19, 2007 11:22

Show full article (2.20Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Monthsold in microsoft.public.access.queries
Author: John Spencer
Date: Sep 19, 2007 08:45

Show full article (1.11Kb) · Show article thread