Search results for query: *

If I wanted to sum all of those up in at the end of the report how would i do that for each one

I have never seen a way where you can have a prefix and then have it generate an automatic #. You would have to imput the invoice #'s yourself but in the Input Mask you can add this "DL"0000;; and that will allow you to have the DL infront of your invoices. The zeros after the DL...

Hmm....not quite sure I understood that. Maybe i didnt ask my question right. This =DCount ("*", "Tablename", "type='dogs'") counts all of the records in the table. But when I open my report I have to input a location "LA" or "CV" then it...

How about if im running a query in my report .... its a parameter query. I select between to locations and I only wanted to count the ones for each location

Thanks.... that was a lot of help! If I wanted to sum all of those up in at the end of the report how would i do that for each one

File sent!

Did that work?

Hmm...that didnt work?

Report includes field called "TYPE" when a report is shown the "TYPE" field has many records ex:(pc, monitor, printers, etc.) If I wanted to only count dogs how would I go about doing that in a report. This will be done in the section footer of the report??? so that it...

since your using novell...did the network admin create a print queue

If it is local. Why would you use TCP/IP? or is it installed using a jet direct card?

HMMM.....is the printer local or on the network?

You might be able to use the computer management in the administrative folder Check the SYSTEM INFORMATION section

Make sure you install netbeui on ur xp machine. http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b301041

I have a couple questions: Do you have administrative rights to the local machine? Are you logged on to a domain? Do other users login to that pc user there own login created in windows or is there a standard user?

Ok...what you can do is create a query with all the information thats going to be on the report. Then when you have the query in design view. In the "CRITERIA" section for your INVOICE # put in the following .... [Invoice #] That will allow you to enter the Invoice # you want to print.

Are you going to know the Invoice #'s when printing a report or will you be searching for them by a customer #??

Yes you can in ur query in the "CRITERIA" section enter the following [Please enter date] or u can enter anything u want in between the brackets... or if u want to select between a starting date and an end date add this in the "CRITERIA" Between [Starting Date] And [Ending Date]

Thanks I did that and it worked...now only thing is that i added the laptop and not every dept has one etc... now when i run the report and if it doesnt have a laptop in that dept it doesnt count the pc or monitor

Thanks for the help! If I want to do the same for Laptops, monitors etc.. Can I Just copy the code and make the changes needed?