Search results

chergh: That appears to have done the trick with the values greater than 1. Thanks! I'm still having an issue with the times grouping together but now I suspect it's another matter altogether.

That one zeroed the entire SensorTime field. [EDIT] My mistake, it added a new field "Expr01" of all zeros. The time issue still remains though.

chergh: That one didn't work either. Thanks though for clarifying.

How would I use a boolean in this case? Or should I resort to a large nested IIF statement?

Guus2005: Not sure I'm clear on what you mean, but I did modify the argument slightly: SELECT Sensor3.SensorDate, Switch((Sensor3.SensorTime<=1),(Sensor3.SensorTime),(Sensor3.SensorTime<=2 AND Sensor3.SensorTime>1),(Sensor3.SensorTime-1),(Sensor3.SensorTime<=3 AND...

Do you mean replacing the [1,2,3,4] values with int(Sensor3.SensorTime)? If so, that didn't seem to work.

Nice crash course in SQL.

I have a query with data grouped by time, with the goal being to combine values for each 5-minute time interval over the course of several months into a single 24-hour period (resulting in 288 records). Most of the time values, when converted to decimals, are between 0 and 1. However, some of...

Excellent! I don't know why I didn't see that in the first place. Thanks.

OK, one last quick question as I am just one step away from ending this problem: I made a query to display all the original table data and round the times off to the 10th decimal, but I get the error message "Syntax error in FROM clause." Here's the query. SELECT xSensor1.* FROM xSensor1 ROUND...

Thanks neileg, I'll go with your suggestion of constructing a query that returns all the table data and round the times from there.

Excellent advice!

I've already constructed the second query and it works, but I was just curious whether my queries were simple enough to combine them into one "uber-query" of sorts. It isn't absolutely necessary to the database; just something that could streamline the process and save time on similar...

I am attempting to set up a query which will perform aggregate functions on records from two fields (Speed, Volume) and group them by a time field (SensorTime). This should essentially result in several months of data being combined into a succint 24-hr time period, divided into 288 five-minute...

I have two queries that I am interested in combining into one if possible. I'm trying to learn Access and SQL on-the-fly, so feel free to point out any noob mistakes I am making. The first query simply pulls certain records from a table: SELECT Sensor5.LaneName, Sensor5.SensorTime...

Problem solved! It was an error in the relationships of the original query causing problems displaying the data for the subquery. Thanks for the help though; I have cleaned up my object names now as well.

I am managing a traffic database and have currently constructed a series of queries that list average vehicle speed and total volume in five-minute intervals over the course of several months. From each of these queries, I need to create a subquery that, for each time interval, will simply...