Search results

the 'Set dbs = CurrentDb 'Set tdf = dbs.TableDefs("DOG") should not be commented out but it doesnt work either way!

im using following code I got from the web im using access 2000 im just running this from a command button on a blank form with a table called "DOG" im just trying to loop through the table so I can try to get round another problem I have its coming up with error on the DAO bits?? Private Sub...

I have two querys which I then put in another query but all the times dont come through correct one is from a nismatch query and the other is calculated of the same one time - 15 minutes. Each query works but not when they are in same query together

Yes but this is just an example so is this not possible?

I have a mismatch Query that shows time slots available during day that have not been booked (15 minute intervals) the problem I have i want to just show the time slots that are available depending on what treatment has been chosen so if it was a one hour appointment then it checks that 4 slots...

My partner has started working for a new salon and they have asked me to do a database of clients ETC that's the easy bit im also trying to do an appointment diary so you can select free available time slots and im struggling with this any help or references to look at would be very much appreciated

Positions_Table Race_Link,Position,Member,Flytime,Ringnumber 64,1,Fred,00:56:53,GB34 64,2,Fred,00:57:34,GB35 64,4,Fred,00:58:53,GB89 64,5,Fred,01:00:23,GB12 64,3,Alf,00:57:50,Gf1234 64,6,Alf,01:57:50,Gf1234 65,1,Fred,00:56:53,GB34 65,2,Fred,00:57:34,GB35 65,4,Fred,00:58:53,GB89...

I have a table POSITIONS which has (position,time,club,race_link,name) i have managed to get the fastest time for each club in each race using the Min in a query the problem is i have another query that then adds up the times and works out the fastest club from that query but it includes all...

I dont think im explainging my self very well yes that gives me the values i want but not the way i want to display them think i will just leave thanks for everyones help

well i dont know how to do it it and i dont have a function called min but in a query when you summarise you can have the min value im wondering if it possible to say Min(3) or Min offset(3) to show the 3rd Min i need it to be in a summary otherwise its not what im looking for

1 2 2 3 but if i say min(4) or whatever function it would say 3

smallest but in the summary if you put Min now then it shows the Min so I was wondering if you can stipulate 2nd lowest 3rd lowest etc

Sorry its been a while before post but on the Min one in a query says the lowest one but im wanting to say min(2) which is 2nd lowest or even equal to first if there is two of them and min(3) min(4) I always find it hard to describe exactly what i mean lol

thanks for that but doesnt quite do what im looking for

Im looking to display the 4 lowest figuers obviously Min is the lowest but how would you dind the 2nd 3rd and 4th Min or is not possible?

thanks just tried now im home and works think i must have been over complicating it before will get them all in and see if it works!

I have a form with a subform (in continuous) I have on the main form a few unbound text boxes which once im happy with the results i press a command button on mainform which adds the unbound text boxes to a new record on subform im struggling with this one. I have done similar before but that...

sorry the first way i did it it worked was as easy as i thought lol. i just messed something else up making me think it was that was error.

i have a unbound text box in the form header and have a command button in form im wanting to put the unbound textbox value into a bound textbox on form

well i havent actually tried on database at work but one at home which actually wasnt a date field but i get what you mean now as in all the ones with dates in will sort first then sort on another field after. again many thanks