Access Macro Help

[gottimd]

I am trying to write a query to open up a table in Access, clear it, and import new data. I figured out how to import data in the actions menu, but I can't figure out how to clear the table before I import.

Anyone know how to do that in the design view for Microsoft Access Macros?

[Antmeister]

If you want to clear a table using a macro, create a new macro, select RunSQL. In the field that reads "SQL Statement", write "DELETE * FROM [Your Table Name]".

[gottimd]

Thanks Ant! That worked.

One last thing, is there a way to disable the "Are you sure you want to delete xxxxxx rows?" so that the macro seemlesly runs the routine without me having to wait around and click yes a bunch of times?

[henry296]

In your macro using the SetWarnings = No.
Make sure to turn them back on at the end with SetWarnings = Yes

[gottimd]

Thanks Henry, that worked!

[gottimd]

Quick additional question, in Microsoft Query, how do I get it to show only the Top 25 records? Do I write it in the SQL statement or is there somewhere this can be defined?

SELECT `Player Historical`.FirstName, `Player Historical`.LastName, Sum(`Player Game Stats`.TDPasses) AS 'Sum of TDPasses'
FROM `C:\NAFL Archive\Programs\NAFLDB\NAFLDB`.`Player Game Stats` `Player Game Stats`, `C:\NAFL Archive\Programs\NAFLDB\NAFLDB`.`Player Historical` `Player Historical`
WHERE `Player Game Stats`.PlayerID = `Player Historical`.PlayerID AND ((`Player Game Stats`.Week<23))

When I run the query it gives me too many results, and I just want it to return in excel the top 25.

[henry296]

You need to Use the TOP command right after Select. So Select Top 25 'Player...

[gottimd]

Thanks!

THe last problem I am having is combining the First and Last name. Right now, when I run my query:

SELECT TOP 25 `Player Historical`.FirstName, `Player Historical`.LastName, Sum(`Player Game Stats`.TDPasses) AS 'Sum of TDPasses'
FROM `C:\NAFL Archive\Programs\NAFLDB\NAFLDB`.`Player Game Stats` `Player Game Stats`, `C:\NAFL Archive\Programs\NAFLDB\NAFLDB`.`Player Historical` `Player Historical`
WHERE `Player Game Stats`.PlayerID = `Player Historical`.PlayerID AND ((`Player Game Stats`.Week<23))

So in excel this now returns the First Name in one column (A), the Last Name comes through in the second column (B) and the stat comes in Column C. Is there a way to have the First and Last name combined? I know how to do it in Access but I can't seem to get it to work in Microsoft Query.