I have following data in SQL Need sql queue: I have 10 tags, it is continuously logging to SQl at every 10 Seconds of intervals. Now i want create report like…..User will provide time interval …
Tag: vba
Access 2010 Issues with “IS NULL” in Select statement [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 5 y…
Show all time stamps for a date in a list box
I have data entered in a table multiple times a day with a date stamp and a time stamp, along with other info. I have 2 fields to filter, primary is day and the other is time. I also have a form with …
Excel VBA SQL from Access no results
Using Excel 2010 to query an Access 2010 Database (via UserForms). When I execute the code, I get my Message Box “No Results” (called near the end of the sub). However, there should be 12 records …
How to SQL join tables, selecting the largest value in Access-VBA Function?
I currently have the following Access VBA function, which operates as explained in a previous question (very useful for understanding this question): However, instead of Field3 containing either yes or no, in my data it can contain one of several values. For simplicity, let’s say that these values can b…
How to maintain uniqueness during SQL Join within Access-VBA function?
I currently have the following Access VBA function: What this is doing is taking the tableName table and inner joining with the newTableName table’s Field1 to Field4 on commonField. Note that Field4 will be the same as commonField, since it needs to be selected to perform the join. In order to convey my…
Having trouble with IF condition using SQL
I cannot seem to get this IF statement to step into the Call Expiry part it goes to the else therefore I can only assume there is something wrong with my condition. I’m trying to fetch the contract status from an access table Investment Data WHERE Customer Number is the Customer Number on the current sp…
Get the lowest Score of each distinct Name and distinct Group
Need to get the lowest Score of each distinct Name and distinct Group. Thank you. Result: Answer
VBA Query based on multiple “multiple select list boxes” in Access when not selecting an item from one of the multiple select boxes
I have the following vba that creates a query in a test Access database. I have two multiple select list boxes. The issue is, i want to be able to select multiple items from “Me![State]” and none …
MS ACCESS SQL Join Subquery
I have two tables: newparts, storedparts I insert the parts of the newparts, which are not jet in the storedparts into the storedparts: This is working fine so far. Now the Problem: Table storedparts is getting so big that the programm is taking too Long for the join process. My solution: Just compare the new…