Search results

Here's what I did instead: SELECT T.Lane, T.Carrier, T.Price, (SELECT COUNT(*) FROM [AllRates] T1 WHERE T1.Lane = T.Lane AND T1.Price <= T.Price) AS Rank FROM AllRates AS T WHERE ((((SELECT COUNT(*) FROM [AllRates] T1 WHERE T1.Lane = T.Lane AND...

I have a database with information on carriers, lanes, and prices. I need to choose the cheapest 3 carriers for each lane. The lanes are either 3-digit zip code to 3-digit zip code or state to state (410-300 or CA-GA, etc.) So for each of these lanes, I need to find the 3 cheapest carriers...

Does it help to say that there is a macro in the excel file i'm exporting to?

I have a TransferSpreadsheet macro that's supposed to overwrite an excel file with new data each time it is run (the access table is updated each time in a query). However, the data isn't being rewritten. I've checked the table and file names, and the query is correct. Any ideas?

Thank you much

There is already a form in the database I'm using that opens automatically when the database is opened. I do not want this form to auto open, but I want a different form that I have made to auto open. How do I turn this on/off?

I'm importing to a brand new table. The formats are consistent throughout all of my data, and throughout each column in each separate spreadsheet. It gets through each step (field titles, where to save it, etc.) but when it comes time to actually import the file, it gives me an error.

I'm trying to import about 18 excel spreadsheets into one database in Access. I've been using "get external data" to import the spreadsheets as tables, and the first 8 of them worked fine, but now I cannot import any more excel files. The only error message I'm getting is "An error occurred...

How do I define the column as autonumber?

How do I add a new column to an existing table, and fill it with number (starting at 1) so I can use that column as the PK? Step-by-step instructions would be great, I'm having a lot of trouble with this!

I've tried doing it manually one-at-a-time, but it didn't work.

I've been trying to load data from multiple excel worksheets in multiple workbooks into one table in Access. The first one loads fine, but after that I get errors and can't load anything else. All of the sheets are in the same format, so that shouldn't be the problem. Every solution I've...

Yes, but I need to put them into Excel so I can run a macro on them. The things I need to do are difficult/impossible in Access, but quite simple in Excel.

How do I export a table from Access into an already existing Excel workbook on a specific tab, without erasing what it written on the other tabs?

In the database I'm running, a record with a null value for anything I am pulling would be incomplete and would need to be cut out anyway. This query takes care of that for me. But I see what you're saying.

By the way, the WHERE statement I came up with for selecting one param or all is this code: WHERE ((([DataTable].[Division Name])=IIf([Division Name?] Is Null Or [Division Name?]="all",[Division Name],[Division Name?])) AND (([DataTable].Type)=IIf([Type?] Is Null Or...

I will work on both of these and see what I come up with. Thanks so much!

I was hoping there was some way to type in multiple constraints, like an AND statement or something. But so far I've found nothing of the sort, which makes sense. Thanks again for all your help.

Yes, I turned them into .xls files and then put them in the workbook. They're originally .csv output from another program, but it's fine for them to end up .xls Thanks!

That's pretty funny ;) Is there a way to modify this so the user can enter one thing, multiple things, or * to get all, without putting a constraint on the number of entries?