Search results

Happy Birthday RuralGuy, I, for one, have benefited a lot from your replies, in my learning of access, earlier at aspfree.com & now here. Let the flow never end. Thanks

You, Sir, are irrepressible.:D:D:D

Glad you got it working. Sorry, I gave you the SQL version of the query. Did not realise you were working in Design Mode. If you go to your query in sql mode, you should be able to see the underlying sql query code. Thanks :)

Just check out if below gives some guidelines : SELECT myTable.TheItem, Sum(myTable.TheAmount) AS SumOfTheAmount FROM myTable WHERE ( ( (myTable.TheDate)>=[BeginDate] And (myTable.TheDate)<=[EndDate] ) ) GROUP BY myTable.TheItem; Thanks

Usually, I would think Yes, but in this case, I would prefer them as separate tables with a 1-1 relationship, as they appear to me, 2 separate entities. Till someone comes along, just a few off the cuff thoughts (assuming - one quote is for one and only one PartID & one job is for single quote...

There is no need to have duplicate fields in both the tables or to automatically populate the JOB table information. Thanks

Not much in to forms, reports, all the same, 1) try changing the name of text box on the report, from Question to QuestionA. Keep the control source same as what you have shown. i.e. =IIf([Question]=1,"Yes","No") 2) Alternatively, explore "Yes/No" field type. Thanks

Should be able to do that. Can also be done in the query itself, however, I think, that is not advisable (kind of overloading the query when not needed). Hope, u r doing it in a copy of the db. Do not know if you have realized it, in the diagram that I have attached, TblProbabilityLU_1...

If that is the reason, then those tables are not required. You can display 1 or 2 as Yes or No, using for eg. IIf. IIf(Q1=1,"Yes", "No") I think, the tblMaster is not big. You can combine the one-to-one relationship tables in to one. I agree. I think, that can be done. At this stage, I am...

Till some one comes along, 1) Can you not save the db in .mdb format & then upload it. 2) The inner join could perhaps be the cause ( I think you have already thought about that). Assume, you must have tried changing the join & got a message on trying to run the query, ambiguos joins. a)...

@lagbolt, Thanks, it appears to work perfectly, the way I wanted. I am not facing the problem that mahenkj2 is facing (crashing sometimes). It could perhaps be my limited testing ability. Haven't got down to understanding the code. Only one question, is the code in "cNumber" the only thing or...

To all those who might be interested, my current thought status in crude pseudo-code ( real crude). a = input number to be compared; sqlAllchecknumbers = select testID, checknumbers from table1 where checknumbers <= a order by checknumbers; rst = sqlAllchecknumbers; b = rst!checknumbers; c...

Hi John & Pat, Thanks for replying. I too concluded that perhaps the solution would lie somewhere in the direction of what John has suggested, the keyword "combinations" of "Combinations & Permutations" & "arrays" as Pat has suggested. Get all the combinations possible in arrays. Then, loop...

till someone comes along, perhaps, tblEmployee EmpID_PK EmpName Position - FK .... tblPositions Position - PK (Values - Manager, Employee) tblPositionRates PositionRateID - PK Position - FK Rate DateOfModification tblProjects ProjectID - PK ..... PositionRateID_FK / Rate Thanks

Did not know where to post this, so ended up posting here. I have a set of numbers, say (these could also be values of a column in a table) FieldA = { 11, 16, 20, 23, 30, 37, 40, 50 } I have a number, say 196. I want {16,23,30,37,40,50} to be returned as these numbers add up to 196. Note ...

on the fly, just check if below gives some guidelines : SELECT Table1.TestID_PK, Table1.TestName, First(Table2.TestID1_PK) AS FirstOfTestID1, Table2.TestID_FK, First(Table2.TestField2) AS FirstOfTestField2 FROM Table1 INNER JOIN Table2 ON Table1.TestID_PK = Table2.TestID_FK...

perhaps SELECT DISTINCT ........ or GROUP BY query. Thanks

Till someone comes along, 1) Have you tried First: IIf(DateDiff("d",[refdate],Now()) Between 1 And 15,[amount],0) 2) Not sure, but, think, we should avoid using "First", try using TheFirst. Thanks

Guess, it's a typo in your reply. In instance ii) you are actually referring to CricketID 4. Till someone comes along, Just check out if below gives some guidelines : http://allenbrowne.com/appevent.html Thanks

1) Unable to see StartTime & EndTime fields. See only one Date field in the image attched. 2) Why do we have the Year field ? 3) Assuming data like below : CricketID BurrowID StartTime EndTime 1 A 10/1/12 5:00 10/1/12 7:00 2 A 10/1/12 4:00 10/1/12 6:00 3 B 10/1/12 5:00 10/1/12 9:00 4 A 10/1/12...