Search results

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 created a query in design view. Now everything is working fine..But we have data only for Jun, Jul, Aug. But I need the output should show for thre rest of months total invoice as zero. Bcoz the output file is used by another application where they want to see all months How can I do this ??

Notworking I am using the following formula to get all data by each month in a year SELECT Sum(X.Totalinvoice) AS [total], X.Month FROM [select idate, Totalinvoice, switch(Month(vDate)=1,Jan, Month(vDate)=2,Feb, Month(vDate)=3,Mar, Month(vDate)=4,Apr, Month(vDate)=5,May...

I need to create a query. But how to get all months for a year where I have only date column in my table Can you send me the syntax or formula which gives me the desired result I am new to Access db.

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

Bob, Can you also let me know how to get monthly data by week which is also posted in another thread

How to calculate values for Monthly ?? For Ex: If I run on Jun 30th, it should give me results asof each week of that month excludes Saturday and Sunday 06-June-0813-June-0820-June-0827-June-08

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

Automate query results Bob, Is there is anyway I can automate this query to run everyday and place output file in a network drive ??

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

Giving me error Bob, Thank you very much for the query. But I am getting error when doing this. So here I am attaching both ExcelInput (Access table has data from this file), and required Output file. The output file is created using VBA Modules written in Access. Now using queries, I need to...

It gives me only one date which is 3 days prior to the current system date. How to find out, if I run on every monday it should give me last whole weeks count in different columns ?? Also If I run on Tue it should give me Monday count and other columns should be zero and Wed should give me...

I am getting the following error when writing formula using Connect Date - weekday(Connect Date(),2)+1 - iif(weekday(Connect Date(),2) = 1, 7,0) Getting Syntax Error

Condolance I am very sorry to know that she passed away. I can understand your pain.

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