Well I learned some things too - glad you were able to work it out and thanks for sharing.

OK, that clarifies things. Here is the SQL for doing what you want:SELECT CDate(Int([measure_time])) AS [Date Measured], Min(My_Table.fAtmPM) AS [Min], Max(My_Table.fAtmPM) AS [Max], Avg(My_Table.fAtmPM) AS [Avg]

FROM My_Table

GROUP BY...

As this is a forum for Microsoft Access, I think you will have better luck using an Excel forum. One that comes to mind is Windows Secrets, and the...

I think I missed something here - are you saying that you want to pull all records from a specific date, and then get the min, max and avg for...

It appears that Access refuses to let you update views, whether they are indexed or not. We use views extensively as ODBC linked tables and as long as they...

Try the following:

SELECT Min(My_Table.fAtmPM) AS Min, Max(My_Table.fAtmPM) AS Max, CDate(Avg([fAtmPM])) AS Average

FROM My_Table;

Note that DATE is a reserved word in Access because there is a Date() function that returns the...

You are spot on in terms of the complexity of trying to do this in an ADP - it is much simpler if you use the .mdb/accdb approach and link...

Some questions:

1) Is this all in one table or are multiple tables involved?

2) What version of Access are you using?

You should be aware that "" is looking for an empty...

In 2010 you use the Import tab of the ribbon and choose ODBC. You then specify the DSN which points to the SQL Server database and indicate you want...

We typically name views vwXXXXX so they show up after tables, which we prefix with t so they look like tXXXXXX and then the views show up at the bottom...

The simplest way to achieve that is to create a view, and give it a unique index. Access will see that as a primary key when you link to...

There is a function in Access that does a reverse search on a string - it is InstrRev(). Doing that will let you determine the position of the last...

What version of Access are you using? And is this an app you are trying to publish to the web that uses a SharePoint back-end?

I'm not sure there is a question in your post, but it seems that some clarification is needed. First, the major strength of Access is the ability to bind...

It appears that you have successfully recovered your database, or at least the tables and queries. From what I can tell, that tool doesn't recover forms, reports, macros or...