Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Spydermine
- Content: Threads
- Order by date
-
Assign query result to a variable
Hey, I've tried searching for an answer to this but the words I have to use in the query are too generic, "query" "variable" etc. As the title says, I can't manage to assign the result of a query (query result is a numerical value from using COUNT). Ideally what I'm trying to do is perform...- Spydermine
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
SQL Queries Dissapearing
This one's a bit weird and hard to describe. On my forms (any form) when I select the criteria and click the button to perform this line: DoCmd.OutputTo acQuery, "ManOrVolQuery", "MicrosoftExcel(*.xls)", "\\fsss253001-w\ow\users\dsilva_k\KD LEAP Database\Test\SelectAllExcel.xls", True, "" Once...- Spydermine
- Thread
- Replies: 9
- Forum: Microsoft: Access Other topics
-
Setting a field's default value based on another field
Hi, I want to base the value of one field (PAReviewDate) from another field (AssessmentDate). Where PAReviewDate would be AssessmentDate + 3 months. AssessmentDate already has values in Date/Time Short Date format. I've tried tinkering with DefaultValue property for the PAReviewDate field but...- Spydermine
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
