Search results

Can anybody help me in getting the last 12 business days data excluding weekends. Also the results should be group by each business day I have a table with value field and date field How can I find previous 12 days(only weekdays) value group by each day

Thank you very much. It is working fine Also can you tell me how to find the previous 12 working days excluding weekends ?? I already posted this in forums but didnot get it work

I have been facing problems since started writing queries against previious months, years, days etc. I wrote the following query to get the previous 12 months which is working fine but the Order of months giving me problem Suppose if I run today the query I should get months from Oct 2008...

The query is not giving me previous 12 days data. Please find the attached Datevalues in table and query results. When I enter 11/7/2008, query should give me the previous 12 days data excluding weekends Results should include 11/3/2008, 11/4/2008 which are available in table The current...

Here is my query SELECT * FROM tbl_Log AS T1 INNER JOIN [SELECT TOP 12 tbl_Log.cdate FROM tbl_Log T2 WHERE Weekday(T2.cdate) NOT IN (1,7) ORDER BY T2.cdate DESC ]. AS T2 ON T1.cdate = T2.cdate;

I cannot use inline query in my situation. I need to write a single sql query as I need to display in Business Objects report

The above query is not showing correct results. Also I have date field in only one table. I need to get the previous 12 days excluding holidays I think we can use weekday function. But I am not getting the logic to use it

How to get the previous 12days (only weekdays.Exclude weekends) by selecting a date using query group by each day

Yes. 0.29 represents 29 sec and 1.34 represents 94 seconds

It is showing in 12:01 etc in format I have values entered into table like 0.29, 1.34 etc. I need to convert these values to mm:ss for few of the names where type is Time I tried to use both the formula above which didnot work and showing in 12:00 format

I am having difficulty in selecting crateria. I need to display last 12 moths, weeks, days, qts data for current year as well as prior year. Can anybody helps me on this ??

Thank you for your reply. I am able to display month values. But I am having problem in filtering between Current year and prior year. For Ex: If calculating Monthly values, Current year should give only upto 11months data where as prior should give for the entire previous year I am...

I have a table with date and amount values. We are running history reports. I need to calculate Daily, Weekly, Monthly, Quartely data for current year and prior year for last 12 days, weeks, months and quarters Please find the attachement Date Conversion to see my requirement How to...

I need to find mm:ss from a number..There are no hours..Time should be in mm:ss

I have a table with Product Name, Product ID, Product Type. Product Type is P(Percentage), T(Time). We have a form to enter data into this table. Few products are with type T. Time should be mm:ss format. We can enter the value only as number in Form. i.e if we enter 93 it should be converted...

I have date in mm/dd/yyyy format. Now I need to display this date into dd-mon format. How to do that ???

I need that for Reporting. I need to develop a Business Objects report

How to store that information in Ctime column ?? Can you send me the query

I need to find out the document's most recent status whether it is scheduled,approved or delivered. I can get the recent information based on the timestamp . So within 1/1000 sec also the status can be changed Does access can hold milli second information ?? If so, how can I define that ??