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

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...

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

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 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 ???

My table has a data field from where I am getting data by month Now my users need to see the data for current month only next month 1st i.e currently we are in August month. When they run report they should see only Jan till July data August comes into picture only on Sep1st when they run...

I have a date in my access table as yyyymmdd whose datatype is text I am using format([date], "mm/dd/yyyy") to convert to date in mm/dd/yyyy It is throwing error #Error Can anybody help me on this

I have date coming from AS400 date. Statedt is in yyyymmdd format Statetm is in hhmmss000 (millis sec format) For ex: Statedt is 20080521 Statetm is 12300905 Here is the attached file I have with date and time I need to find the most recent State by using date and time Can anybody help...

I have a date field in my table in format m/dd/yyyy hh:mm:ss AM. Depending the date selected by user, I need to display the corresponding month's data like previous 4 weeks If the month begining falls in weekday other than Monday, It should give the whole month begining week's data For Ex...

I have a table with Time column which has values like A, B, C, D until J. I need to hard code them if Time is A then 8-9 and if time is B then 9-10 etc I tried both iif and switch functions which are not working Please advise me on how to write ?? Am I missing any syntax ??

I have a table with Invoice Number, State, State dt, State tmstp State has 5 values like Delivered, spooled, prepared etc. I need to get the the state of a invoice number with most recent date and time tmstp. For ex: if I have 4 states for a invoice with different dates and time, I need to...

I have a Datetime field in my table in format m/dd/yyyy hh:mm:ss AM How to get only date from this datetime field ?? I need to display the field only for Date like 'MM/DD/YYYY' Thanks for your help

I have a table which has Date, Total Invoice, Customer region etc I need to calculate total invoices generated for each month in a year Out put should be displayed group by each month name Ex: Total Jan Feb Mar Apr May etc 100 30 40 50 80 200 etc Please let me...

I am using MS Access 2003 and Excel. I created a table in access db by importing data from Excel sheet. I get excel file everyday with current or history data. What are the best ways to load data everyday to the existing table and how to automate it ?? Table should append data everyday. It...

I have a table which has fieldname called Name. I need to create another table which should have only names which starts with alphabet A by taking Name values from old table Can anybody tell me how to write a query for this What is the process to achieve this. I am new to Access database

Hello everybody.. I am using Access database to pull data from Excel sheet and produce out put to another Excel sheet using VBA modules The database table has data from May 01 2008 till Jul 15 2008. Output table has five columns for each day MON, TUE, WED, THU, FRI. If I run the code on...