 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005Queries
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? > 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? 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 <vjohns@alumni.caltech.edu> Please feel free to quote anything I say here. 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 > > 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? [quoted text clipped - 9 lines] > -- Vincent Johns <vjohns@alumni.caltech.edu> > Please feel free to quote anything I say here. 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" > 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 [quoted text clipped - 12 lines] > > -- Vincent Johns <vjohns@alumni.caltech.edu> > > Please feel free to quote anything I say here. 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. > If you are using a DATE field then I suggest you change the criteria to > Between #11/1/2005# and #11/30/2005# [quoted text clipped - 23 lines] > > > -- Vincent Johns <vjohns@alumni.caltech.edu> > > > Please feel free to quote anything I say here. > 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 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 <vjohns@alumni.caltech.edu> Please feel free to quote anything I say here. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.