Recent content by shakey

Cheers Colin I believe this warrants more than 2 Cheers Thanks Frank I await your alternative with anticipation

Thats Great Thanks Many thanks for giving up your time on a Sunday If I could there would be a pint waiting for you at your local :)

Thanks for your perseverance in helping me on this but qryB returns the same results as qryA If you have time could you look at the thing I am completely Bamboozled by this cheers James

SELECT TOP 1 Max(tblresults.[Round No]) AS [MaxOfRound No], tblresults.Names, tblresults.[Round Points] FROM tblresults GROUP BY tblresults.Names, tblresults.[Round Points] ORDER BY Max(tblresults.[Round No]) DESC; Top man i think this is what you mean James

Hi Colin Thanks again The problem isnt that I cant send the report A dialogue box pops up asking me what format i would like the report to go as, my dilemma is the code is not picking up the email addresses from the email field. Am i pointing to the wrong table? James

Thanks for that I have managed to get a query that just shows the most recent round and when i update the results table to the next weeks set of results the query updates as well and shows the most current weeks scores (Hallelujah:)) Do you have any pointers to how i subtract 1 from the Max to...

Hi All I am Stuck!! I want to email a report using a button on the report to all the email addresses in a names query The email field is set to hyperlink so that it recognises email addresses but the code stops at the send object command Could anyone look at my code to see where i am wrong I...

Hi Colin sorry for the late reply have been too busy at work I think that you have misunderstood the gist of what i am wanting to do i have a similar application i produced in excel for a naps table leaderboard at the local which produced a ranking comparison table (please see Attachment) I...

Hi All I have a bit of a problem creating a report which will show the comparison of scores for players between for example "Round 1" and "Round 2" The table is populated with fields Round No,Name, Score eg Round Name Score Round 1, Jim, 24, Round 1,Nick, 25, Round 1, John,26, Round 2...

Solved: Problems with decimal places in a query took some figuring out and searching for the right thing but it is SOLVED thanks very much I can now progress Goodwod isless than a month away :):):banghead:

Ok but why doesnt it siply transfer one figure from the table into the query without changing it calculations are "sums" if i add 2.2 to 4,1 i get 6.3 not just 6 do i have to change something in the field itself so that it works shakey

Or this IIF([ColorType]="B/W" and[Machine]= "Ricoh 3510" or "Ricoh 8200-1" or "Ricoh 8220-1" or "Ricoh 8220-2", [UnitsRequested]*0.0039,0) This should do the calculation if conditions are met or return 0 for any other colour OR machine .....I think

Dont know all the facts but it seems arithmetically you have the Brackets in wrong place Try this IIF([ColorType]="B/W" and IIF([Machine]= "Ricoh 3510" or "Ricoh 8200-1" or "Ricoh 8220-1" or "Ricoh 8220-2" then [UnitsRequested]*0.0039),0)

Hi I am trying to build a Access data base which week by week will show a NAPS table leaderboard for my local pub competition My brick wall has come on producing a query which will show just the member and a total sum of points accumulated When i run the query the point total show whole...

Hi I am a lorry driver from Warwickshire trying to learn acces to complete a specific project At my local pub we run a naps table on Saturdays and for major racing festivals I produced an Excel table which with the help of a lot of VBA worked but was very complex I thought I would try to use...