Recent content by peace

I would strongly suggest Visual CE which synch with PC Access application easly. It is very visual to create great looking forms and easy to work with. It is as it can be understood from its title very visual application. I have been using it without a problem. Personal edition should run...

Yes, it is text and Number. It is like this.. December 2004 February 2005 January 2005 as you can see, the order is not chronological but alphabetical. The January should have been above the February in the crosstab query result, but it sorts it based on alpha order.

sorting in chronological order, not alphabetically This might be a simple problem for some of you but not for me.. I did search this forum for a solution but could not find one.. Cross-tab query takes mmm yyyy from one query, week numbers, and other stuff and calculates number of occurrences...

still problem.. Doc. Thanks for the fast response. :) I think I am as lost as it can get with SQL... However: I have the following (below) at the second query's SQL view, (same as the first count query). SELECT [qry WM7 only numbers count].CountOfRemarkMemo FROM [qry WM7 only numbers...

hello. This is my first post. :) I am not a SQL person. :( I know there is criteria solution for what I need but I cannot recall. I hope one of you nice friends will help me. I have a field ( title Remarkmemo) in my table. each record in that field is populated with a customer number...