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 Westi 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: newaccessuser4545
- Order by date
-
Format/Set up an Access query correctly
That helps, but I am unable to write functions against different columns this way. For example, if I build an "Iif" statement another way(which I think is the answer, I just don't know how to structure it), then I can write other expressions to calculate %growth, etc...any other thoughts...- newaccessuser4545
- Post #5
- Forum: Microsoft: Access Other topics
-
Format/Set up an Access query correctly
That is a little better, but still not really what I'm looking for...here is the output with a crosstab query: Company 1/15/05 2/08/05 2/15/05 1 1000 1 2000 2 5000 2 8000- newaccessuser4545
- Post #3
- Forum: Microsoft: Access Other topics
-
Format/Set up an Access query correctly
Hi, I am trying to set up a query in Access that will return data based on the date. For example, if I have the following table: Company Revenue Date Co 1 1000 1/15/06 Co 1 2000 2/15/06 Co 2 5000 1/15/06 Co 2 8000 2/08/06 I need a query that...- newaccessuser4545
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
