Search results

I've been asked to pull the last shipment from each location for December of 2012. I have my data by location and date, so how to I write a query that will show only the last shipment date for each location? :banghead: Thanks for all your help :)

I am an accountant in Nashville TN, and I've been working with access for about 8 years now. I've recently gotten a new job that requires me to develop my skill set and learn SQL and VBA, so I can create integrated reporting/analysis models for our department to improve efficiency and access to...

:banghead:Hello, I am new to VBA and I'm trying to write a VBA Module in Access that runs a SQL query and takes that result and appends it into an existing Excel report. Thus far I've been able to get it paste the data but it puts it in the wrong spot, the correct columns but wrong rows on Excel...

I am trying to write a function in an access 2007 query that will calculate the date range for each of my records based on the month-ending date and the In-transit days assigned to each record (excluding any weekend days) (i.e. if the in-transit days number is 5 & the month ending date is...