Recent content by iCarbon

Thanks for the responses. Here is the SQL view of the query. And yes, I forgot to say it was a cross-tab query. The function converts between the Unix Epoch time in the DB and MS Time format. Shouldn't be executing during a save operation though. @namliam: I'm not familiar with a "pass...

Ran into something with Access that is new to me. I have a DB with about 6 linked ODBC tables. I am writing a query that uses all of those tables and has about 10 result columns. Other than the table joins, the query is a fairly simple select query. My problem is that the query can take a...

Thanks for the suggestion. I may be doing something wrong, but could not get the left-join type query to work as desired. Ended up creating a table and an associated query to generate all possible range values. Then did a UNION query with the actual data query. I can then work on the...

I am using the partition function to generate data that I then use for a histogram chart. I am summing the quantity of parts and grouping by part size. Pretty much everything works, except for missing ranges in the partition output. If I have no data records within a partition range, then...