All, thanks for the advice to get me this far. previously i had asked about a 12 month rolling total, below is the SQl but for Decembers the total is wrong,...

Can an expression in a column be used to generate line numbers? 1, 2, 3, etc. Thanks David

Hello, I am using the date serial function in a query to pull data that is reported 2 months after the fact. I can get the start date to work...

I am trying to build a query that sorts data ascending order by date, so that when I select "Last" in the Total row for other fields in the query I will get...

I have a ODBC query built to pull data from a table in Access and linked to another database table. The query seems to work fine to compare data from the...

I need to write a query which will make one table’s worth of information (Labour Hours Table) look up its corresponding fields in another table (Rates of...

I have looked thru the forum to find this answer and all I can see is how to pull more that one amount of max values to be displayed in a report. I need to...

I'm getting some very strange results from a query I'm running. I've boiled it down to a problem when using a Group By query when joining tables on two or...

Hi, I keep running into this same problem when I’m building my query and I’ve tried several different approaches. It could be that it is beyond my...

Hi and TIA! I posted this to another grroup but then saw this one and it looks more suited to my question. I've researched and tried many many conversion...

How do you do a sum on top of a group by or how do you combine an if statement with a group by? My code looks like this: SELECT t_Starts_AppFlow.,...

I have to create MANY forms with MANY combo boxes. The strSQL behind the scenes is going to be tedious enough, but... Is there a way to name the boxes in a...

I am a flight instructor with a flightschool in California. I am trying to set up a database for the school to help track when our instructors need to...

Never used to get this error msg till now. I suck t VBA any help PLEASE!!! Public Function ArchiveResults() Dim historical As DAO.Recordset Set historical =...

pictures of pictures pictures of gas picture pictures of

picture pictures of best pictures pictures picture

Suppose I have two tables: Table 1: ID a b c 1 1 2 2 3 4 3 5 6 4 7 8 9

I have a date field that I want to filter based on a date. However the date contains the date and time. I want to allow the user to enter the date to filter...

I have a querie and I can get any date criteria report except for the year 2010. Any suggestions? Thanks

Good Afternoon, I have a query set up and I would like to do the following: Group numbers 100 thru 199 in group 100 200 thru 299 in group 200 300 thru 399 in...