Search results

I am so confused. If I understood correctly, instead of having 2 fields of StartDate and EndDate on the form, I should have 12 fields for each month?

The entry is from an order form that specifies deliveries from start date to end date. I need a query/report with details of all outstanding orders sorted by month and thought that by expanding the delivery dates by month is the way to do it. Wrong approach? Paul - thanks. Will try that out.

I thought the conversion is done thru a query:D... Attached is another db with the tbl_ship. As for the other posting, no offense intended Paul. Just a bit anxious to see the results. I have gained tremendous knowledge and help from this forum. Thanks.

Attached is a sample db. Thank you!

Thanks Paul. I am lost as to where to begin. Is there a sample database that I can download?

I have a table with the following fields and data: ID, DateFrom, DateTo, Qty 5, 1/1/08, 6/1/08, 3000 Can I convert the above to this: ID, ShipDate, Qty 5, 1/1/08, 3000 5, 2/1/08, 3000 5, 3/1/08, 3000 5, 4/1/08, 3000 5, 5/1/08, 3000 5, 6/1/08, 3000 Thanks!

I have a query with the following columns: ID, Customer, MthQty, BeginDate, EndDate, Jan,Feb,Mar....up to Dec If MthQty is 1000 and BeginDate is 1/1/08 and EndDate is 6/30/08, columns Jan to Jun will contain 1000. I need to run a query that will pull up sales for a particular month only...

The code works fine but it runs real slow. Could you please take look at the attached sample db and advise how I can speed it up? I deleted a lot of records to go under the attachment limit. Thanks!

Thank you!

I have a stock price database with the following fields: Code Date Close WAG 5/16/2008 $36.55 WAG 5/19/2008 $36.48 WAG 5/20/2008 $36.18 WAG 5/21/2008 $36.19 WAG 5/22/2008 $35.39 WB 5/16/2008 $27.65 WB 5/19/2008 $27.40 WB 5/20/2008 $27.20 WB 5/21/2008 $26.73 WB 5/22/2008 $25.49 WMT...

Stucko is not good... :( Thanks guys.

If I import it, the data is fine. Its the linking that troubling. Assuming no changes made to the Excel file, is there a way to solve this error?

I am trying to link Access to an Excel sheet on the server and I only have Read access to the Excel file. When I open up the linked table, there are some #NUM! errors on a column with dates formatted as 6/1-6/30. Single dates like 6/1/08 have no errors. How can I solve this? Thanks.

I think I got it. I made 3 queries: one with the original settings, the second with an added month, and then the third to link the two together. Attached is the DB. Thanks to all!

I need help on a query. There are 3 columns in the table: Month, Company, Amount. I need to add the amount of every 2 months to find the highest 2 month average. Example: Date Company Amount 2-Month Jan 07 AAA $100 $100 Feb 07 AAA $200 $300 Mar 07 AAA...

Mile-O: I'm in the US. 7/1-7/5 is July 1 to July 5. Brian: Thanks for the code. I will try that out first thing tomorrow. Thank you guys!

I imported an large Excel file with a date column consisting of 3 different date formats and need help on a query to extract the number of days. Examples of the date on that column: 7/6/2006 7/1/06-7/31/06 7/1-7/5 Appreciate any advise.

It's working now. Thank you very much. So, it's the quotation that is causing the problem?

Here is the db.

I changed the control for number to number1 and have a "Data Type Mismatch in criteria expression."