Search results for query: *

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

Ok massive brain fart. I finally figured it out. Thank you for your suggestions they did help me finally open my eyes to something I was missing. After posting the above I took a break from this &quot;thorn in my side&quot; and had a chance to relax. It came to me what I was missing. Thank...

Thanks for the help but both PCs have the same Workgroup, there are no bridges, I re-ran the wizard several times last night (even shutdown both PCs after each run), and I am not using the XP firewall (I am using an outside firewall vendor and have allowed all access for the computer2 ip...

I have tried the &quot;access-list 100 permit ip any any established&quot; and I get &quot;Invalid input detected&quot; for established. If I use &quot;?&quot; to see the usable commands and established is not there. It will except established at the end of &quot;access-list 100 permit tpc...

I have 2 XP Home PCs networked sharing one internet connection. I can ping from both PCs to each other and I can telnet to an outside ip address from computer2 but I cannot connect to a web site from computer2. I still have full internet connection from computer1 (main PC using cable modem...

Here is the config for my router. 1.2.3.4 is the outside ip for my machine and 5.6.7.8 is the starting ip for the network my customer's vpn is on. I know the router is the first ip and the vpn is the next. I have opened 32 ip address for access from their network for other reasons. My...