Thanks for the tip, but I tried using the TGML tags and I made sure it was checked and it doesn't seem I can get this to format correctly.
I don't need to sum any totals. The second record for "MIKE" the amount $7,000 is actually a WonAmt and that goes the same for the last record in the...
How would I do I group my records into one record for each month?
SELECT Montly_Rpt_Table.REPID, Montly_Rpt_Table.Rep, Montly_Rpt_Table.MonthAbb, Montly_Rpt_Table.LostAmt, Montly_Rpt_Table.WonAmt
FROM Montly_Rpt_Table
WHERE (((Montly_Rpt_Table.REPID)=2));
REPID REP MonthAbb LostAmt...
I dont why "..." kept showing up in the post. But this is what worked.
strBody = strBody & "<a href=http://wwwapps.ups.com/WebTracking/track?loc=" & TrackingNumber & ">TrackMe </a>"
I think before I had some spaces in where they shouldn't have been.
Again, Thank you.
And for SKIPVOUGHT...I...
Once I click on the button on the main form, it runs the code above and creates and displays the outlook email, it places the Link on the new email. When I click on the Link it does open the browser to USPS website but it is not displaying the tracking number on the website.
It should look...
Thanks for the reply!
I forgot to mention I had already declared the variable. The module is contained on the form itself. I tried placing the variable inside quotes but I receive compile error
Private Sub Command1752_Click()
Dim strBody As String
Dim Contact_Email As String
Dim OutlookApp...
Hello,
I'am hoping someone in this forum can help me. I having some trouble with the syntax below.
I am using MS Access 2010 and I have a form which generates an email through using Outlook.Application. When I outlook generates the email and I click on the Link the website indicates it cannot...
Hello,
I have an excel file which I have imported into an access table. There is a field Called Time_Lapsed which is in Text format. Is it possible to someway to sort (rank) these from oldest first? The fields look like this:
08 day(s), 2 hour(s), 39 minute(s).
04 day(s), 13 hour(s), 6...
Hello,
I need help with writing a script that will open a dat file in my temp directory and then check a specific column's field "USER_ID". if the column USER_ID field is more than 6 characters I would then need the script to trim from the RIGHT of the "USER_ID' column to be within the 6...
I need some help on ranking and hoping someone can assist. I have an EmployeeID field "EmpID" which is a number field and an Hours field which is a Text Field. I would like to create a ranking column to rank the the employee with the highest amount of hours. Is this possible to do in a query...
I am hoping this is the right forum for this question. We will be migrating to windows 7 with Office 2010 from Windows XP Office 2007 in the next few months. We have imaged one of our test machines and have found out that our MS Office products have had some restrictions placed on them through...
Duane,
Thank you for assisting!
It's the way jobs are billed here. If an employee performs a job and takes him 1.21 hrs the vendor is then billed for 1.5 hrs.
I have tried to run the query Billed: RoundIt([LinkTime]) but I am receiving the following error message:
"Wrong number of arguments...
Hello,
I need some assistance with rounding up.
I have a field in which the data type is a Number and the field size is set to double. I am look for a way round up to the nearest quarter.
Example:
1.32 round up 1.75
0.07 round up 0.25
48.54 round up 49.0
1.15 round up 1.25
2.21 round...
Can someone explain to me what this mean and how do correct the query?
"You tried to execute a query that does not include the specified expression "Barcode Assignment" as part of the aggregate function"
SELECT Test2.Barcode_Assignment, Format((Sum([...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.