Data Changing Issue

From: Karen <Karen@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 15 Oct 2007 09:50:00 -0700

Hi

I am running some queries using a form I created and for some strange reason
some people are falling off and coming back to the report when I run the
queries and then re-run them immidiately after. I am not changing any of my
parameters and the data is not changing in the tables I am linked to. Can
you help?

I am using Access 2003. I have several different queries running as make
table queries from Foxpro database linked tables. Within these queries I
have one query that has a parameter set for "Married Date" What this does is
prompt the user to enter a start date and then I have an expression that
calculates the number of months from that "start date" to an actual
"Marriage Date" field in one of the tables I am linking from foxpro. The
expression looks like this:

DateDiff("m",[smf]![smfwedding],[WEDDINGDATE])

** WEDDINGDATE is my "start date", SMF!SMFWEDDING is a field from table from
foxpro**

Would this be the reason data is changing like this?
Help.
Thanks

.

Follow-Ups:
- Re: Data Changing Issue
  - From: Michel Walsh

Prev by Date: RE: query to extract the portion of text of fields in a Table
Next by Date: Re: Nested Conditional Statements
Previous by thread: Re: Could not delete from specified tables problem
Next by thread: Re: Data Changing Issue
Index(es):
- Date
- Thread

Relevant Pages

Re: Data Changing Issue
... If inside a query, the table sm should be part of the FROM clause (or, ... I am running some queries using a form I created and for some strange ... "Marriage Date" field in one of the tables I am linking from foxpro. ... Would this be the reason data is changing like this? ...
(microsoft.public.access.queries)
Re: 2 forms for one table
... Steve Schapel, Microsoft Access MVP ... > For some strange reason, the forms aren't updating together. ...
(microsoft.public.access.forms)
Re: Slow queries between VB and VFP
... The FoxPro Rushmore data engine optimizes queries when the expression in a ... Where indexes are available FoxPro will read the ... however there are .cdx files for every database. ...
(microsoft.public.vb.database.ado)
sql using access
... I usually work with FoxPro using SQL. ... Now I have to use Access to make some queries. ...
(microsoft.public.access.queries)
Re: Database application
... the problem with foxpro is that it's a flat file database (at least it was ... when I last tried to run queries on it) and it is this really hard to so ... none of this complexity exists with foxpro for dos. ...
(rec.crafts.metalworking)