Recent content by Mhypertext

We want to import the excel doc in to access after the pivot table updates daily. the problem is that at the top of the excel spread sheet we have all the filters instead of just the colum names when we hide them they show back up on the access import is there a way to get around this so that...

it looks like its keeping the 0.00 amounts now how ever when i i run the next query it dumps them SELECT [qRY_Comps4-1-9to6-31-9].IssuedTo AS [Player ID], dbo_Player.FirstName, dbo_Player.LastName, [HostPlay4-1-9to6-31-9].[Host Name], Sum([HostPlay4-1-9to6-31-9].TotalTheoWinSum) AS...

its still dumping the 0.00 amounts SELECT [qRY_AllComps04-01-09to06-31-09].IssuedTo, FORMAT(Sum([qRY_AllComps04-01-09to06-31-09].SumOfAmount), "###,###,##0.00") AS SumOfSumOfAmount FROM [qRY_AllComps04-01-09to06-31-09] GROUP BY [qRY_AllComps04-01-09to06-31-09].IssuedTo;

the below query keeps removing Issuedto Id if there is a 0 amount how do i get it to disply the results even if there is a 0 amount SELECT [qRY_AllComps04-01-09to06-31-09].IssuedTo, Sum([qRY_AllComps04-01-09to06-31-09].SumOfAmount) AS SumOfSumOfAmount FROM [qRY_AllComps04-01-09to06-31-09]...

I have a table of 2506 records and a table with 53754 records I need to join them together I have a primary key but some of the records from the 2506 table wont be in the 53754 table how do i merge the tables to together regardless if there is no match basically i need one table with all...

I have five tables each day of the week and they have 3 columns Player_ID|TheoWin|ActWin|PlayDate the problem is that each day has Player_IDs from the other days is there a Query that would allow me to only pull the first time a Player_id shows up in that week and ignore the rest of there...

Ok i added date fields to all my tables . now each table has a ply date

I know man i am very thankful for your help i just dont know where to look for this info I have searched all morning on changing the tables from text to dates and then the functions in access i cant seem to find anything on the web maybe i am looking for the wrong keywords?

I guess i am just lost here so if i run it for monday then run it for tuesday the person that played on monday will not show up in tuesdays query? how does access know i do not want there play only by pulling it by dates

yes it is the table name but still if the play on monday i dont want they play from anyother day of the week

that would work but i dont have the play dates could i just add that colum to the tables man there has got to be an easy way to do this I have to perform this every month so i should add the date to each table to tell me what day it was? then pull a union on all of it then just doa group...

all i want to do is filter out mutliple records in the week resulting in totals for that week with one Player_id per that week i thought doing it the way above would work but relized today after 2 days of data imput it does not work

SELECT FROM [50-99/12-14] INNER JOIN ([50-99/12-13] INNER JOIN ([50-99/12-12] INNER JOIN ([50-99/12-11] INNER JOIN [50-99/12-10] ON [50-99/12-11].[Player ID] = [50-99/12-10].[Player ID]) ON [50-99/12-12].[Player ID] = [50-99/12-11].[Player ID]) ON [50-99/12-13].[Player ID] =...

I may be over complicating it I have 5 ranges of play i work in a casino 50-199, 200-299 300-499 500+ and 5 days of the week I took the whole DB and ran the first query for each date of the promo against my mail list for the promo to only but i ran it per day so i have daily play for that...

Yeah inmport it all into access Then link it all in the relationships tab then click on design Query and put the files u imported into the design window and click away on what you want to show then hit run and boom your done click the x save it then over on the left right click and export it