Queries

D

DC Lady

I have mutiple queries set up to manipulate a single table different
ways.When I update my table it is not reflected when I run my query,why?
 
V

Vincent Johns

DC said:
I have mutiple queries set up to manipulate a single table different
ways.When I update my table it is not reflected when I run my query,why?
Click to expand...

There may be better ways to do this, but have you tried closing your
Query and re-opening it? Assuming you saved the changes in your Table,
they should be available right away.

It's possible that just choosing Records --> Refresh on first the Table,
then the Queries, would cause the Query in Datasheet View to display the
changed values.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
D

DC Lady

Yes,I tried this but it still won't refresh any data in the query.The query
criteria is set Like "11/*/2005".Could this be part of the problem
 
J

John Spencer

If you are using a DATE field then I suggest you change the criteria to
Between #11/1/2005# and #11/30/2005#

Using a wild card string on a date field can give you unexpected results.

An alternate solution would be to force a formatted string and set the criteria
against that.

Field: MonthYear: Format(YourDateField,"mm/dd/yyyy")
Criteria: Like "11/*/2005"
 
V

Vincent Johns

DC said:
Yes,I tried this but it still won't refresh any data in the query.The query
criteria is set Like "11/*/2005".Could this be part of the problem
Click to expand...

I don't know if it's part of the problem, but your string looks
suspiciously like a date value. If you (for example) are filtering the
dataset for dates in November 2005, you might do that more directly by
comparing the month with November and the year with 2005, or by setting
the criterion to "Between #11/1/2005# And #11/30/2005#". (You might
first have to convert the string to a date via the Datevalue() function.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
D

DC Lady

Yes thank you this works better for me.I also had a formatting issue on the
original table that I had inadvertantly changed from a date field to a text
field.
 
Top