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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ia3p
-
How do I add fields if dates are within 20days of each other
the only advise I can give you is select the table first by ship then in a loop order by shipdate and check the difference and add. This may help but I am not sure you can doit in a single query unless you play with aliases and that is a headache- ia3p
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
help to export query results into excel
i am not sure of the sintax but you can do it a) create a temp table in the order of your excel spred sheet and simply unload it to a text file and import it b) write a file to disk with a delimiter "," or "|" in the correct sequence for your spread sheet. Hope this...- ia3p
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
help to export query results into excel
i am not sure of the sintax but you cab do it a) create a temp table in the order of your excel spred sheet and simply unload it to a text file and import it b) write a file to disk with a delimiter "," or "|" in the correct sequence for your spread sheet. Hope this...- ia3p
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
