Query doesnt pick up all records, please help!

[enrajack]

I have a query which picks picks up all records from a table. One field however seems to randomly not pick up data from certain records even though the data is in the table.

This has been puzzling me for some time now, does anyone have any ideas / suggestions?

 

[muttsylove]

I'm not sure how your query (and your table structure(s)) look like but for example, if your query has some join to another table, check to make sure your datatypes are the same for your columns. Otherwise, it might not return properly (as I've run into something similiar to that myself).

If you have ur database to post up, that would probably help to see ur problem too.

 

[The_Doc_Man]

OK, in your query, you have three views. Datasheet view shows you what a query picked up. Design view gives you a query design grid. SQL view gives you the equivalent query in SQL format.

For whatever fields you are having trouble seeing, look at the design grid contents for that field or the SQL excerpt from the SELECT clause for that field. If there is an expression or function involved, look at it closely. Be sure that all function/expression arguments make sense.

Next, look at the table to see the record that is the recordsource for the query row giving you trouble.

Finally, if this is a single-table query, you are stuck. If this is a JOIN-based query, check that the joined elements are valid and that you are pulling the fields from the proper sides of the joins.

If you can't spot the problem, post the query here and tell us which field is the one that is eating your lunch. When you post the query, tell us a little bit about the fields that are giving you trouble. At least enough so that we know the format and what we might see in the field.