Recent content by dobosm1421

That was my starting experience with Access but the more I work with it, I find it is a great data management tool. We had 30 years worth of data in excel workbooks and we created a database to organize and manage the information. The forms are nice for technicians to enter the data. You can...

I work with fish as well, mainly anadromous and native salmonids. My disadvantage is that most of the folks around me are not familiar with Access and GIS so I am having to pick up information through forums and self teaching. I haven't done too bad for myself but I would like to be more...

Yes! Thank you! I thought that I extracted the time from the date when I imported the file but it was still embedded in there. The expression worked and I did get the values I needed!

SELECT Mainstem.Event_date, Max(Mainstem.Crooked) AS MaxOfCrooked FROM Mainstem GROUP BY Mainstem.Event_date; Here is the SQL with the stand alone table (mainstem). I was trying the extra table because I could not get it to work by sorting what I needed in the "Mainstem" table so disregard the...

This is the SQL: SELECT Date.Date, Max(Mainstem.Crooked) AS MaxOfCrooked FROM [Date] RIGHT JOIN Mainstem ON Date.Date = Mainstem.Date GROUP BY Date.Date;

The SQL statement for the query that I am trying to build? I have not really used the SQL to communicate my data before so I am unsure how it works and what I need to provide.

I am working with some temperature data and trying to extrapolate information for a summary. I have tables that include the location of where temperature is taken, and measurements taken each hour for each station everyday for a year. I would like to extract daily maximum and minimum...

HI, my name is Marika and I work in the natural resource area. I am a fairly novice operator of Access but have been working with the rogram for a good number of years. I am hoping this forum will help with developing my skills and answering questions that I am unable to figure out on my own.