Search results

I am having an issue with a query. It is returning dates that have been formatted in mmm 'yy format, meaning Jan '11, Feb '11, and so on. For whatever reason when sorted it relies on A-Z instead of Newest to Oldest and so on. Jan '11 is being displayed first, then Jan '10, then Feb '11, Feb...

I have the following query that works perfectly: SELECT [Q02 AUSTELL L/E].[Report Dt], [Q02 AUSTELL L/E].Terminal, [Q02 AUSTELL L/E].[L/E], Count([Q02 AUSTELL L/E].[L/E]) AS [Total Onhand Units], [View All Allotments].Allowed, Forms!MAIN!STARTDATE AS [Min Report Dt], Forms!MAIN!ENDDATE AS...

I may be missing something simple, perhaps a fresh pair of eyes will help. I have the following code running a query in VBA Else strSQL = "SELECT [Q01 Generate Data with Duplicates].[Report Dt], [Q01 Generate Data with Duplicates].Controller, [Q01 Generate Data with Duplicates].Terminal, [Q01...

I am attempting to import an Excel file into SQL Server 08, by using an Access front-end. When I attempt to import the file, I recieve the following error: ODBC--insert on a linked table 'dbo_OLDDATA' failed. [Microsoft][SQL Server Native Client 10.0]Invalid character value for cast...

I noticed a strange problem with a query I am trying to contruct. I have a Union query that runs perfectly fine...however if I made a second query that uses it, everything returns a "Query too complex error". So let me try to explain... The first query is below. "Q01 Generate Data With...

While exporting my table in a comma delimited file, I noticed my date is re-formatting itself before export. It is currently set in the format of yyyy-mm-dd, but exports as mm/dd/yy 00:00:00. I thought I would outsmart it by creating a new column as text, and copying it over, then exporting...

I have a report I am opening in VBA, and the report happens to be based off of a query that has two parameters (Start Date, and End Date). I am attempting to open the report with two variables I am sending via VBA. So far I have attempted... strSDate = "Start Date = #" &...