Search results

plog, thank you for your answer! Your way is actually what I was looking for, as you can create all these queries by just using the GUI and not write any sql, which is a secondary but no less important objective of my exercise :-) ADDITIONALLY, by using this group of sub-queries, the result...

Hi and thank you for the quick reply. This works, though require some tweaking in the SQL language box. Is there any way I can obtain this result through the MS Access GUI interface? I am currently on Access 11. -abq-

Hello, I was trying to get only the TOP RANKED rows from a table like this, using a query. Here is my data: The result would be a table showing only the yellow shaded rows, which are those where the "fruit count" is the highest. I tried with a "group by max", but as expected I do not get what...

If you don't want to use VBA and just a formula, here is what you need: Assuming "YETI" is the name of your field mid(YETI,(instr((instr(YETI,"|")+1),YETI,"|")+1),(instr(instr((instr(YETI,"|")+1),YETI,"|")+1,YETI,"|")-instr((instr(YETI,"|")+1),YETI,"|")-1)) This will only work if you do not...

I am seriously considering to replace the Memo field with a set of 255 chars fields... Until now, the only way to make it work is: 1) insert a new record (I must open a recordset in VB code, just because an update query will never work) 2) "move" (change indexes to) the related records in the...

OK, I tried many things right now, to get the Memo Field working, and I came across various things. I tried to play with data type in SQL server between vnarchar(max) and ntext, and I get the same problems (so the data type is not the problem): I open the linked table (from the access table...

Hello, and thanks for the reply. I checked the definition, and the field was already correctly translated as nvarchar(max) by the migration assistant. The problem comes out also if I simply open the linked table using the Access tables view, and I try to insert more than 255 digits in the...

If you read a previos post of mine, I am working on an application, trying to move the back-end part to an SQL Database. What I am starting from, is a "classic" Access 2003 application splitted in 2 parts: the front end with the application consisting of "fixed data" tables, queries, forms...

Thank you again for the support :) I was watching my code and I wanted to give a try to a different approach: as you can see, the second part of the code uses an append query to add a record, but in the first part, it uses the same recordset used to find the record as a base to start an edit -...

Thanks for your suggestions about the transact-sql commands. Then, I will have to manage the transaction using sql code or workspaces depending on the type of connection, because my application can connect and work on either an .mdb file (as done until now) or an SQL database. About the other...

Hello everyone. After some years using just Access for my application (everithing going fine), I am now testing the switch to SQL server 2005. I already have an application divided in two parts (Data and Program), so I used the "Microsoft SQL Server Migration Assistant for Access" to port my...

Following your link and browsing for help in the sites suggested in the discussion, I found the answer to my problem, thank you. Just to add a small contribution (and make things clear, where normally you would get crazy guessing what is the right command) i will write here the correct sintax...

I think this is a common issue for all those people who are upgrading from access to SQL server (as database), so i'm asking where i can find some resource to accomplish the following "basic" task. The following command is used to attach an Access Table contained in an .mdb file...