Data appears mixed up when queries are performed.

[RoadVette1999]

Hello everyone,

I have exhausted my attempts to figure out the problem with my database.
First, this is the first database I have created. All was going well until my
admin assistant reported that when she conducts a query, information will
show up in the wrong fields. The database tracks incoming departmental mail.
When she runs a query based on the log number, some of the responses will
have the due date in the "To:" field and names in the due date field. This
does not happen on every single record, and occurs sporadically. I have
looked over my forms and ensured that the control source for the form leads
back to the table. I am confused as to why it would only be happening to only
a couple of fields rather the whole table. Any help would be appreciated.

 

[Jeff Boyce]

If this were happening in one of my databases, I'd probably go back to the
source, the actual tables, and verify whether the correct data was showing
up in the correct fields.

If it is, there's something hinky about the query.

If it isn't, maybe the query is actually returning what's there, but what's
there is wrong!


Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[KARL DEWEY]

You will need to post sample data with table and field names plus their
datatype, and SQL of the query in question.

 

[John W. Vinson]

Hello everyone,

I have exhausted my attempts to figure out the problem with my database.
First, this is the first database I have created. All was going well until my
admin assistant reported that when she conducts a query, information will
show up in the wrong fields. The database tracks incoming departmental mail.
When she runs a query based on the log number, some of the responses will
have the due date in the "To:" field and names in the due date field. This
does not happen on every single record, and occurs sporadically. I have
looked over my forms and ensured that the control source for the form leads
back to the table. I am confused as to why it would only be happening to only
a couple of fields rather the whole table. Any help would be appreciated.

It's concievable that you have some corruption in the table or the indexes. As
suggested, check the table itself and the query! Have you Compacted the
database?

If the table looks OK but the queries are returning wrong data, try creating a
new database; create the table, in design view. Link to the old table and run
an Append query to populate it. Import the other objects except for the query.
Recreate the query from scratch. Post back if this is still happening!