Ask a Question related to Dreamweaver AppDev, Design and Development.
-
LKnomad #1
Query distinct month and date
ASP 3.0 VB - access
We are trying to take a date field and pull the month and year into a
drop down menu. I am using access and can format the query to show
only month and year instead of the full date but we need distinct
months and years.
The problem is that there are mulitiple month and year combos. we need
only one month and year combo for each set of months and years.
Example: if I query with the format in access set to mm-yyyy I might
get 7 different rows back displaying 02-07. I want only one row.
Using distinct doesn't work becuase the origional rows that the date is
being pulled from are all different.
Help?
Laura K
LKnomad Guest
-
Start and end date of month
I am trying to calculate the start and end dates for a month. I am using the formulas: <cfset first_of_month =... -
SQL: can a date ONLY contain month/year info?
When using a SQL datetime field, is there a way to store ONLY the month and year? I have a situation where I need to store both month/year and... -
Using DISTINCT for some but not others in 1 query
I feel really stupid. That doesn't happen too often.. but I feel really stupid. SQL is completely kicking my face in right now. So to get... -
2 digit Date and month format
Hi, select @month_part = datepart(mm,@mdate) select @year_part = datepart(yyyy,@mdate) How do I get '01' for January sqlserver returns 1 for... -
Last Date of previous month
List , I want to obtain the Last Date of previous Month ie 09/30/2003 ,if report is run in Oct . and 10/31/2003 when report is run in Nov. I...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
