Recent content by Scrye

I have been working on an Invoice report that I have working up to a point. This last little bit is keeping me from releasing it. I am using MS SQL Report Builder 3 to create the report. The data is laid out using a Table with 2 Groups (Customer and Invoice). I have reviewed multiple forums...

I am revamping an old report that someone else wrote and I have had to clean up a lot areas that was pulling too much data or not enough. There were 3 subreports on this report to begin with and I have narrowed them to one. I thought maybe that it was due to the size of the dbf file I am...

I am working with a report that is to produce a customer's billing statement. Within the statement I have a subreport in group header 1a. This subreport is needed to gather a total dollars owed so it can be placed in the header (the footer total is calculated from the main report detail). The...

George, I searched for threads on left outer joins and did not see your thread but if I did I would not have needed to post. Thanks for the link to the thread. I understand completely what RiverGuy did and how it works, I just did not realize that you could continue a selection criteria within...

Thank you! That was perfect. I have not worked very long with SQL and was not sure why it wasn't pulling correctly.

The query below works correctly if I do not add a where clause for date in the history table but once I add it records are skipped from the customer table which is set to a left outer join. My record custnums are sequential so I know that some are being skipped. I am trying to pull a customers...

I tried it an it worked both time entries. Thanks!!!! I didn't realize you could apply a function to a criteria. Chris

This seems so trivial but I am having such a time with it. I am working on an Access selection query that someone else wrote and I need to add a time value as part of the selection criteria. I have added a >=[start time] criteria prompt in the query. The problem I am having is that if I have...

Thanks for the quick response and the help. GHolden - I had not removed the error checking on any of my tries but I did this time and realized that I had not added the field SigLocation to the Report. Once added it printed perfectly. Thanks!!!!!!! PHV - This is the first I have seen this...

I am relatively new to Access and I have been given the task of creating a DB that holds product information along with printing a report to use as an approval for production. I have tried everything I could find for displaying an image onto a report and nothing has worked. For the last 2 days...

No command line operations for email only end user (Windows) software. Our Unix box is used to only send, receive, and house mail until retrieved. This is not happening to one user it is happening to all users (randomly). Nothing has changed on the end users side for sending and receiving...

Over the past week or 2 I have been getting the following return messages from the mailer deamon: --- The following addresses had permanent fatal errors ----- <someone@someaddress.com> (reason: 354 Enter mail, end with &quot;.&quot; on a line by itself) ----- Transcript of session follows...

masmith22 - I did get my connection working yesterday (finally after about 2 months of turning the router access list on and off). Your configuration is a little different than mine but I will let you know what I did to fix the problem. Below is the original access list: access-list 100...

Try this: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/columns/profwin/DEFAULT.asp Hope it helps!

The damn firewall!!!! I had this network setup before with computer2 using win98se and I had several problems with it not wanting to communicate on any given day. It would work great for 2-3 weeks and then just not work at all. Well I had configured my firewall to accept from a range of ip...