I’m always getting the “enter parameter value error” when I try to run this code. The error refers to idPat, idSP, idPar and measure_value. I have checked with the debug idPar, idPat, idSP and measure_value and they assume the correct value; the errors comes out when I run sql. Answer Your V…
Tag: ms-access
Microsoft Access can’t append all the records in the append query due to a type conversion failure
Why am I getting a type conversion error? Here is the insert query: Here is the query where I created the Products table: I tried inserting the BarcodeID with and without single quotation marks to no avail. Any idea what the problem is? Answer Posted from my comments above with code for table: You are using I…
MS Access query that includes a join to itself (using a subquery) and reports values that do not exist (null values)
I have the following table named PRICES: VERTEXID TIMEID PRICE 6001 20191231 104.3 6001 20181231 115.3 6001 20171231 138.3 6001 20161231 122.3 6002 20191231 102.3 6002 20190931 123.3 6002 …
MS Access SQL: Sum IIF for multiple Criteria, Format as Column instead of Row
I’m working in MS Access 365 and I have a table containing multiple status that I want to summarize in a Pie Chart. Sample Data: Sales Order# Status 1 New 2 Pending 3 Closed The Statuses are defined by human readable text in a separate table, but are linked in the master table before I run the query. I …
only displays the data contained in the list (is it possible to use the IN function or something)?
I have 4 tables. suppose the list table is a collection of unique data, then there are 3 other tables, each of which has data where not all of the values are in the list table. list aa bb cc dd ee ff gg hh ii jj group_1 aa cc ff hh group_2 aa bb cc ee jj group_3 aa
SQL Distinct on One Column with NO ID
I have a problem where I need to select three columns from a table in Access to populate another table but it needs to be distinct on one column ONLY. I tried the GROUP BY as follows But when I use above with a SELECT INTO and check for duplicates there are some. I have looking at this post –
Access VBA string to return a Min & Max date based on matching criteria
I am trying to use a string to get a minimum date from a field (ExpectedTaskStart) in a specified table (tblLiveTasks) using a match on two ID fields (CASEID) from (ExpectedTaskStart) the other (intCaseID) I either get no return or a return of 0. I have used various VBA outlined below but all with same outcom…
The Microsoft Access Database Engine Does not Recognize ‘[tbl_AssignmentDetails].[Position Name]’ as a valid field name or expression
I have created the below crosstab query off a find duplicates query. When I run it, I get the error message: “The Microsoft Access database engine does not recognize ‘[tbl_AssignmentDetails].[Position Name]’ as a valid field name or expression.” Any clues? Answer .. FROM [tbl_Assignmen…
Run-Time Error ’13’ Type Mismatch – ACCESS DATABASE
I am trying to compare two text fields txtTrailerNumber and txtSealNumber to the database table Tab_TrailerDetails. [TrailerNumber] and [SealNumber] as listed in the table. I am trying to get the …
Query ORDER with UNION
I have to do punt an “*” in a list of dates, like this: So, with my low knowledge, I created something like this code: where “*” is present in the table Union. But, the command ORDER doesn’t work and I’ve a sort system just by number, like the follow: How can avoid this? Th…