Search results

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...

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...

I have queries that i want to run against each other. they are differant days of the week m,t,w,t,f, I want to compare each day to the previous days to remove dupes IE: Tuesday to monday wednesday to tuesday and monday so on and so forth so that by friday it compairs to every previous day...

I have a mail list I want to pull daily play "I have an exctraction that shows it for everyone" I need to inner join against the mail list then dedupe it everyday against the prvious day so i only get the first day of play will i have to do this mauanlly everday or is there a way to...

I am using this statement SELECT player_id,SUM (Pointsearned) FROM vgttotals GROUP BY Player_id when i hit run it asks for a parameter value then i put in 1 and the query shows 1 row and 2 columns what am i doing wrong?

u have 6 colums player ID first name last name the other fiedls are numbers that i want to comebine is there a query that will add everything to one row for that player ID

it asked me to save my import steps so i could reuse them How do i do this i am importing CSV files all have the same colume names but i dont want to have to name all columes on each import But dont understand how to use the saved import steps

I have 10 tables with data they are all player session tables I have a list of games i want to compair against 144 games the 10 tables have multiple data entries for each game and player I need to get player data broken down by machine and points on the machine when i try this query it...

I have a table with 500+ records I want to add a colum of play but not every record will have play I just want those players to remain blank and i want it to enter play for the ones that have matches to the other table this is what i am using but it removes everyone without play SELECT...