Search results

Hi, can somebody recommend me a webiste to make PC to Phone Calls at a cheap rate. I was told to visist www.DistanceCall.com, has anyone ever used this site, i was told they have great rates!

Hi Alli, I have a database that has a comments field. The database has a status field: Plan Test and Run, in the comments field the user adds comments, i'm trying to updated the comments with the status, for example; the user added some comments like. "The test will begin next week" I want the...

Can I do a countif in the report. I want to show all record in the report but only count certain things. For example I have a cloumn that has more than one value, I want to show all records, but in the bottom of the report I want to count only one value.

OMG Man you're so good. I owe you big time!

Try this date if you don't mind, it should be 31 minutes, it's showing -439, the open date is 5/30/2007 4:29:21 PM the close date is 5/31/2007 1:10:00 AM results showing -439 resutls should be 31

Oh thanks a lot, I have one issue though, i'm trying to resolve it but not yet, take a look please, it's the minutes with the "minus" sign, this happens when the open date and close date are outside the business hours. see attachment.

Thanks man, you are a Genius.

it is working for some dates and not the others see bleow: Between 8:00:00 Am and 5:00:00 PM work days. Open Date........................Close Date .......................Min........Results 6/29/2007 4:59:00 PM........ 7/2/2007 8:00:00...

Can someone fiqure it out?

HI Guys, I came across an example from this forum, which I'm using but I think it got some bugs, I hope that someone can help. Attached is the file. There is a modual for this, i'm trying to calculate the time between the Open Date and Close Date columns, it works for some dates but not for...

can someone respond please!

HI All, I created a report that counts a group of description. In the description header i placed the decscription, and my other column I put a text box to count the description, the reports looks good but when I go to sort by the count, I can't find the textbox i placed for count, is there any...

:) thanks. it worked perfect.

here is a copy Here is a copy of my database, basically, I came up with another idea but i can't fiqure out how to do it, in the sample i have a how_to_do_it_qry, what i want to do is exclude any serial_num that has more than one record, the idea is to have " Having count(serial_num)<2; but...

how do i delete multiple records in a table, for example if i have a table that as serial_num 123 twice, how do i delete the two records, basically i don't want to delete one record, i want to delete the two records. Thanks.

Experts Please Help Experts Please Help.

thanks for the effort, but this didnt' work, for example serial_num: CNBM086433 should not be showing because there is another record for serial number CNBM086433 with a date that is bigger than the one showing in your query, that has a change_type "add", here is what i want to do. I want to...

yes one effective date per change_order, but you can have another change order for the same serial_num with different effective_date. If you look at the query I have, you will see that i have for example two serial_num with two effective_dates, i want to show the maximum effective date only if...

yes one effective date per change_order, but you can have another change order for the same serial_num with different effective_date. If you look at the query I have, you will see that i have for example two serial_num with two effective_dates, i want to show the maximum effective date only if...

did anyone fiqure out how to do this complicated query? thanks.