Search results for query: *

Thanks for the heads up PHV! Was not aware of this 'Nz'

Thanks PH for the advice. I tried using the Nz function, but perhaps I did not configure it correctly. In any case, I was successful this morning in acheiving my desired result by using a complex IIF statement...

Thanks spizotfl. Here is my SQL. Perhaps I need an 'if' statement? SELECT [Orders In WMS Not Shipped Status1].STATUS1, [Orders In WMS Not Shipped Status1].CountOfINTERNAL_SHIPMENT_LINE_NUM, [Orders In WMS Not Shipped Status1].SumOfQUANTITY_AT_STS1, [Orders In WMS Not Shipped...

Greetings. I am using statuses to track the 'state' of inventory in my warehouse, related to specific shipments. For example: If I have a shipment calling for Qty 10 of item 'widget', and 4 of those widgets are picked and packed(Status 400), yet the remaining 6 have not yet been picked (Status...

Tony, Thanks for the info. I'm using 'next if', and I'm getting the desired results for each row, until the row is blank - then it's repeating this last column that contains my formula. Sorry if I'm sounding like an idiot, but how do I use the 'bookmarks' to get around this problem? Thanks...

Greetings, I am using Word and mailmerge to create documents for picking of items in a warehouse environment. My template is working fine with the exception of my last column in which I am using a formula. The problem is that the last result returned in this column repeats down the column...

Greetings! I have an extensive email contact list that is stored as a .dbx file, where I used to use Outlook Express. I want to convert that file into a .pst file that I can use with Outlook. I have the .dbx file, but I am not running Outlook express anymore. Is there an easy way to convert...

PHV, BadaBing! That did it! Thanks, Drew

PHV, thanks. I plugged this in as suggested, but it still seemed to return results that include the hour. Any idea why? Here are the results: LOGON Last Time 8:06 14:47 6:40 8:11 14:47 6:36 8:05 14:50 6:45 7:58 14:38 6:40 8:04 14:44 6:40 8:04 14:50 6:45 13:25 13:48 0:22 8:03 14:37 6:33...

PHV, Your response looks to me like it would acheive the results I need. Forgive me, but I cannot figure how to incorporate this into my statement. Can you show me where to plug this in? Here's my complete SQL: SELECT [OPP-User First Activity Logged Today Summary].USER_NAME, [OPP-User First...

Thanks for the help guys! Skip - 1 hour lunch is mandator for my guys, so I don't think this will be a problem.

Greetings, I am using a query which captures 'logon' time for each user and then 'Time of last activity'. I'm then doing simple subtraction to return 'Actual hours worked'. However, I need to skip the lunch hour in my calculation because no work is being performed. Here's the portion of my...

Thanks Everyone! PH - Wow...that's some interesting stuff. Your ammended query seems to work most of the time, but I noticed that sometimes the results are not always totally correct. Could be something I'm doing wrong.... I'll keep plugging away here. Thanks again.

Thanks Bob! I tried the 'TOP1' filter and also 'descending'. It appears as though this may work, but I think my date format is skewing the results. It appears to be choosing the last date/time record based on the month value which is first in the data. Does this sound correct? Or am I...

Greetings, Sorry...this is a repost - I originally posted it under Forms by mistake. I have a locations in my warehouse defined in the database and also transactions that are logged each time an item is 'picked' from one of those locations. I'm trying to create a query that will return ONLY...

Greetings, I have a locations in my warehouse defined in the database and also transactions that are logged each time an item is 'picked' from one of those locations. I'm trying to create a query that will return ONLY the last 'pick' or transaction from each location. I tried using 'Last'...

Problem solved! As it turns out, I actually did not have SP1 downloaded on my XP Home OS. As soon as I downloaded the patch, this slave HD showed 153GB. Appreciate your help and advice! Drew

Thanks Island Custom. Yes, I'm using XP, but I've already downloaded SP1. However, someone else said that I needed SP2 to see the complete drive. ???

Greetings! I just built my first custom PC and everything is fine with the exception of one problem. I have a 60GB Master HD (Disk 0)that shows 57.2 GB once installed. No problem. However, my 160GB Slave HD (Disk 1)when installed, shows 128GB Unallocated. I realize that formatting uses some...

Turns out my XP Home CD was defective! Installed from a new CD and it worked! Thanks for all the help. Drew