(This tip refers to Access 2000. It will work for most versions of Access, but some of the steps might not be the same for all versions.) Almost all objects...
This is how my query looks SELECT DISTINCTROW Format$([tblGAS].Date,'mm yyyy') AS [Date By Month] FROM tblMyTable GROUP BY Format$([tblMyTable].Datex,'mm...
Joe, That sort looks correct. Strings sort 0-9 for the first character, then the next character is sorted. If you want to sort by dates (probably the way you ...
If this is a report, set the report’s sorting by clicking on the Sorting/ Grouping icon. If this is a query only, add an Order by Clause. SELECT DISTINCTROW...
Hi All I am working on a client contact data base using one table dbtClient. I have also developed four other query tables based upon different data needs from...
Hi All As mentioned before I am working on a client contact data base using one table dbtClient. I have also developed four other query tables based upon...
1. I have a rather large Access XP table 2. First field is called "FilerName" 3. I would like to have a report telling me how many times each filername...
... Alvin, have you also found and tried the Switchboard? I have a tutorial about it if you want to go that way. Look it up in Help to see if that's what you...
Hi, You need freate a query with SQL like: SELECT Count(FilerName) AS CountOfFilerName, FilerName FROM [your_table_name] GROUP BY FilerName; You can then use...
Sorry Adrian, I did not realise that you had already replied to this problem. Now I know that the latest list has most recent at the top. Regards, Clive...
Can anyone here point me in the right direction? I originally posted this message back in November and am still looking for some help. If you or anyone you...
Many thanks to everyone for the help! Fortunately, my database appears to be fine. I think what happened was that a network-run backup was going on which...
That sounds about right. Backup processes normally lock all database files so the data can’t be changed. Regards, Bill Mosca Founder ... From: sjmagain...
To Clive Williams (C-Trek) Thats ok the more answers the better for all even though similar. Regards Adrian ... From: "horastacatto" <zctek@...> To:...
Hi Joe I down load your DB and found that part of yourt code had the reference to the same field in the form. But I did get this to work SELECT tblGAS.CusID,...
Hi Adrian, I appreciate your help. However, I have no problem with my first query. Please take a look at query "qryPreviousBalance" In this query I'm grouping...
SELECT tblGAS.Datex, tblGAS.Charge, tblGAS.Payment, tblGAS.CusID FROM tblGAS WHERE (((tblGAS.Datex) Between [Forms]![Select Date]![Starting Date] And ...
Chris, For navigating to the record (on subform) having its CustomerID matching the value selected in combo box named cboCustomerList (on the main form), code...
Joe Create alias fields called MyYear: Year([datex]) and MyMonth: Month(Datex). Sort on those, MyYear first. Regards, Bill Mosca Founder ... From: Joe...
The only way i could get it to work was to go by year then month as so; SELECT DISTINCTROW Format$(qryOnlyPreviousDates.Datex,' yyyy mm') AS [Date By Month],...
A.D. Thanks for that solution. It works well most of the time. I noticed two problems: First, I notice that if the user hides the CustomerID column in the ...
Chris, Your overall requirement is understood to be as follows (a) The subform is in datasheet view. (b) Column named CustomerID is hidden. (c) Matching record...
How are you all iam a new user of access and if any one can give me from where can i start to be professionals in access .....at the moment i know how to do a...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
