Queries
in [Access]
|
ooops, Not Resolved I thought I had it solved and that it ran, but I am getting the error again. error 3155: ODBC--insert on a linked table 'Order Entry ST Products' failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Explicit value must be specified for identity column in table 'Order Entry ST Products' when IDENTITY_INSERT ... 17 Nov 2009 12:54
Can't insert record Hello, I'm trying to Insert a record from a table into itself. The problem is field [ordDetID] which is a Primary Key, autonumber field. If I leave it in the statement, I get a key violation error, because it is trying to copy the existing field values. If I remove the field, I get an SQL insert error (th... 17 Nov 2009 09:29
Type mismatch in JOIN expression. (Error 3615) Join data stored a On Nov 12, 12:14 pm, Jerry Whittle <JerryWhit...(a)discussions.microsoft.com> wrote: Unless it's just a typo below, you have Tables2 and Table2 in your SQL. That little s could make all the difference. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder... 12 Nov 2009 12:53
Inverted Query Can't seem to figure this one out...has to be simple though. I have a database of employee's training records. I need to find those employees who have not had the course "BPS". Right now I have a complex query: Table1 has the employee's personal info and Table 2 has all courses taken...They are left joined by... 9 Nov 2009 14:25
Query to Find Records with only 1 transaction All, I thought I posted this last week, but cannot fidn it. I am working on a table that has transactions for registering for events. So in my table, I have PersonIDNum and TransactionType. TransactionType will equal 1 (for a registration), 2 (for cancellation), etc. I want to find all of the people that reg... 8 Nov 2009 01:01
Custom Counter Question (Repost) Hello Everyone - I haven't received a response back to one of my posts so I am re-posting with the hope that someone will pick up the new post. I have created a field in a query to assign a sequence number to records. The code is below: Sequence_Number: SELECT Count (*) FROM [qryTotalDetail] AS [XX] WH... 9 Nov 2009 13:19
XIRR Calculation Hi, I am trying to calculate XIRR (excel function but not available in Access) using either Query or showing it directly on Report. How can I do it? Preferably I would rather not use VBA as I am not very familiar with it. Please assist, any help would be much appreciated. Regards, Valerie ... 22 Oct 2009 14:10
changing parameters on a stored procedure I have a stored procedure that does not return records but needs two parameters to run @ SAP_code & @Source @SAP_code = interger @source = varchar I can run the SP by inputting the parameters in the SQL view going into queries desgin view and clicking on "pass-through". I would like create a form with text... 5 Nov 2009 07:48 |