Search results for query: *

Thank You that worked perfectly!![bigsmile]

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...

Got it to work! thank you both for all your help.

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...

Sorry posted in wrong forum. I want to do this in MS Access query. Thank you thought I would give it try!

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...

Thank You PHV. Let me give this a try.

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, I got it to work! Thanks again for your assistance!

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...

Doing a little research...I understand. Problem solved.

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([...

Pure Genius! That was it "Auto Hide". Dhookom, Thank You!