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.
 

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.

"RoadVette1999" <RoadVette1999@discussions.microsoft.com> wrote in message 
news:E18E6F70-EE6A-4FAA-8881-47B032782FD3@microsoft.com...
> 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.
> 

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


"RoadVette1999" wrote:

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

On Mon, 25 Jan 2010 15:45:01 -0800, RoadVette1999
<RoadVette1999@discussions.microsoft.com> wrote:

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

             John W. Vinson [MVP]