Search results

Can someone please give me the equivalent VBA code to opening a table, placing the cursor on the down arrow in the field header, and sorting A-Z? I know sorting tables isn't the right thing to do (use queries instead), but I'd like to know the code. I've located code to create the query to...

Thank you again for your time. I revised my SQL to better reflect what I am trying to do and to use your suggestion. Here it is: Now I am getting these errors: Note I changed 'A' to 'P' to try to fix but no go. Thanks again.

Access has no problem with following 'From' clause but SQL Server gives syntax error: Any help would be appreciated. Thanks.

Thanks for quick reply. I can see what your suggestion is trying to do. 'Name' is generic in my example. I've plugged in actual table names and field names but get a syntax error on the 'A'. Here is what I've tried:

Hello. I need some help with joins and using subqueries, and will appreciate any help. To make it as simple as possible, let's say I have four tables, call them T1 (large), T2 (small), T3 (large) and T4 (small). T1 has fields ID and ZIP. T2 has fields ZIP...

Created the query I suggested above and it solves my problem. There are, in fact, employees with multiple ID's, even with identical first name, address, zip, etc. Thanks for your help and suggestions.

Thanks again. To answer your questions: a) Already verified there are no duplicate Emp-ID's. That's what we want and that's good. b) We do not want any employee to have more than one Emp-ID. c) Sloppy data enter or not verifying that employee already had an ID under a different first or middle...

Getting 'Data type mismatch on criteria' with first query.

Thanks for your help. Emp-ID is a 10 character text field, assigned to new employees as they come on board. They are not reused. Primary key is system generated 'ID'. If there are no duplicate Emp-ID's in database, wouldn't your query always return nothing? I'm trying to find all cases where a...

Hello all. We have a huge personnel database that needs to be checked for integrity and cleaned up. One table lists all employees, including Emp-ID, Emp-Acct, FName, LName, MName, Addr, City, St, Zip. First question is how can I make sure there are no duplicate Emp-ID's in the table? Second...

Thank you.

Sorry. I wasn't clear. I have an SQL database with table with field named 'ID', primary key, clustered. When the table is loaded, the records are loaded in physical order: ID = 1,2,3, etc. Hence, when I do the query mentioned above within the SQL database, I get records with ID = 1,2,3. etc...

Hello, can someone please explain why the following SQL query might give different results if executed within Access and executed within SQL Server? SELECT top 200 * from [table name] Thanks.

I know I'm drifting away from my OP but just one more question, please. I'm new to SQL Server so where is a good place to start my learning and what's a good forum (as good as this one)?

Thanks. Appreciate the advice. Would SQL Server Express be a good place to start?

Static database against which queries would be used to extract data for reports, either Access or Excel.

Probably. But Access has been good enough for all our needs to this point, and this is the first time so much data has been made available. I was only asking to see if there was a way to stay with Access, even if it meant multiple linked databases. This data is loaded only once every year.

Thanks for reply. The data will be a 9GB (after decompression) pipe delimited text file. It will be loaded once per year.

Hello all. I know there is a max database size of 2GB. Outside of upsizing to SQL server, is there a way to import 9GB of data into Access? Thanks.

Thanks. That worked a little better. There's one more thing about the bigTab. The f1's are clustered, meaning that all of the unique f1 values are loaded at the same time; e.g., if the first f1 = 1 , then subsequent records are 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, and so on. So, once the query...