Query Returns Correct Number Of Records...Buy Empty

[hlint09]

I do have a query that search in just one table. It is a very simple query. Ocacionally it works ok if my source table just contains a few records but if I have lets say 40,000 records I get as a result a table with the correct amount of records but all of them...empty! I am using Access 2007. I ran on the network and I also tried running from my local drive with the same problem. Any idea? Thank you

The query is:

SELECT ToTranspose_Mid.[Bib #], ToTranspose_Mid.Session, ToTranspose_Mid.[Session Date], ToTranspose_Mid.[Laps Per Mile], ToTranspose_Mid.[Lap #], ToTranspose_Mid.[A1 (Lap Start)], ToTranspose_Mid.[B1 (Lap Start)], ToTranspose_Mid.[A2 (Lap End)], ToTranspose_Mid.[B2 (Lap End)], ToTranspose_Mid.[Elapsed Time] INTO 0001_Transpose_Source
FROM ToTranspose_Mid
ORDER BY ToTranspose_Mid.[Bib #], ToTranspose_Mid.Session, ToTranspose_Mid.[Session Date], ToTranspose_Mid.[Lap #];

 

[lameid]

The Red code below isn't valid syntax... Is that a field name that you didn't use a comma for and square brackets or what?

SELECT ToTranspose_Mid.[Bib #], ToTranspose_Mid.Session, ToTranspose_Mid.[Session Date], ToTranspose_Mid.[Laps Per Mile], ToTranspose_Mid.[Lap #], ToTranspose_Mid.[A1 (Lap Start)], ToTranspose_Mid.[B1 (Lap Start)], ToTranspose_Mid.[A2 (Lap End)], ToTranspose_Mid.[B2 (Lap End)], ToTranspose_Mid.[Elapsed Time] [red]INTO 0001_Transpose_Source[/red]
FROM ToTranspose_Mid
ORDER BY ToTranspose_Mid.[Bib #], ToTranspose_Mid.Session, ToTranspose_Mid.[Session Date], ToTranspose_Mid.[Lap #];

 

[hlint09]

Thank you,

I actually got this statement from the Access Query generator itself. Again that is just an example I am most interested in why when I have a few hundreed records it works and I can see my data but when I have thousands of records I still get my records but no visible data on them. I had compacted the database and I had tried running the query from my local hard drive instead of the network. I had even created a new database and imported the objects tehre but still the same problem. Any idea?

 

[PWise]

The Red code below isn't valid syntax... Is that a field name that you didn't use a comma for and square brackets or what?


/quote

 

[PWise]

The Red code below isn't valid syntax... Is that a field name that you didn't use a comma for and square brackets or what?

SELECT ToTranspose_Mid.[Bib #], ...... 
[COLOR=red]INTO 0001_Transpose_Source[/color]
FROM ToTranspose_Mid
ORDER BY ToTranspose_Mid.[Bib #], ToTranspose_Mid.Session, ToTranspose_Mid.[Session Date], ToTranspose_Mid.[Lap #];
[code][/quote]
is this not a valid make table query