Search results

Well, never noticed that :) I used strWhere = strWhere & "[BadgeNum] ='" & Me.cboBadge & "' AND " instead of the original line due to the data type

Hi, I have almost completed creating a continuous form which I want users to be able to filter though the records based on to/from date, badgenum and a response string. I then want to have a button, btnSelect, that will select the remaining records and open a report based off only the...

Thanks. After after looking at it, Instead of just top 1, I am going to need the running difference. So i tried removing the Top 1 statement and just a select but its telling me "At most one record can be returned by this subquery"

Well, that looks almost exactly like what i need. but when I edit the sample to match my table and fields, im pulling nad data adter so many records for each vehicle. see the text doc attached. SELECT tblOdometer.ID, tblOdometer.ODate, tblOdometer.Odometer, (SELECT TOP 1 Dupe.Odometer...

I have a table where there are multiple vehicles, each identified by their vehiclenumber. Each record holds the vehiclenumber, date and odometer reading. I need to figure out how to calculate records in this table per each vehiclenumber. Below is a code that works, but only when i have each...

Hi again. I just posted something similar, but after some work,this may not have been what I needed. http://www.access-programmers.co.uk/forums/showthread.php?t=261158 Please see database I uploaded. I have a form, "frmBlotter" and am using "tblBlotter" as a subform. My ultimate goal is to have...

Awesome, thanks that works And thanks for the links

Ah ha! Thanks, that was it. I think what I was trying to say was make a form that mimics the split form option that Access lets you create. When I used their template, I could not view it in the navigation menu. This was the answer Not sure why the DB wouldn't open though.. Thanks again!

Thanks - This was actually a sample code I picked up after much research on the internet, so I'm not much into programming. Can you elaborate please? I think I get some of what you say - I'm also not sure if Dim MyApp As New Object needs to include the "New" when setting it as an object. (I...

Hi, This is probably an easy fix... I created a split form. My main form is just a form, based off of tblBlotter. The subform is based off a query, which is the based off the same tblBlotter. (Not sure if this is proper - maybe I just need the table?) I have a link master and link child field...

If someone could help, I need the following code changed to late binding. My database worked great until a 32 bit machine tried to open it. I had the outlook reference set in Access for this to work. I Currently trying to compare what I have with the following link, but looks like he has extra...

http://www.access-programmers.co.uk/forums/showpost.php?p=1330347&postcount=22 thanks for your help!

Perfect. I see what you mean now. flawless. thanks so much! ill update other link here too - was t sure if i needed a new thread for the last question. thanks agin!

Im sorry, I just dont see how to put this together. i see what you meant about the calculation fields.. This is what i keep wanting to do based on the field names of the 3 queries.. expr1: ([TotalChecks] - [qryBlotter2]![TotalChecks] ) But it keeps prompting me for the qryblotter2 totalchecks...

So given this, I think the query should be something like (([qryBlotter1]![Month] - [qryBlotter1]![PrevMonth] )/ [qryBlotter1]![PrevMonth] *100) But thats not right. And further, I just dont get how I would use both the year and month to be sure the correct information correlates.. :(

Oops. I did, just forgot I had another query there bc I had it named "qryBlotterTotals" (My naming conventions are weak) This is the one you are referring to. SELECT qryBlotter1.*, qryBlotter2.* FROM qryBlotter1 LEFT JOIN qryBlotter2 ON (qryBlotter1.PrevYear = qryBlotter2.Year) AND...

Please help. I have the following: tblBlotter qryBlotter1 qryBlotter2 qryBlotterCounts (UNION query) Two of the queries are alike - this way I can get the data I need for past months history. The third query just UNIONs the other two together. I just wanted to add one more expression at the...

lol. Sorry thats not what I meant. The months calculate correctly. I just wanted to add one more expression at the end of this query to complete it. So in effect, if this is Month2, I need MonthlyChange=((Month2-Month1)/Month1*100) and MonthlyChange=((Month3-Month2)/Month2*100) Always... No...

The Grouping/Counts are great! Thanks! My formula could stand a bit of help if you can though. It keeps prompting me to enter the values when I run the report. Expr1: (([Month]-[qryBlotter1]![PrevMonth])/[qryBlotter1]![PrevMonth]*100)

Looks good.. Thanks. How do you suppose I can get the final calculation I need