Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GaborH

    how to total positive and negative #s separately?

    On an access report, I am trying to total a column that has negative and positive numbers in such a way that I have separate totals for negatives and for positives. I can not seem to do it without adding a couple of extra fields to my query. Is there a neat way that I can do this on a report...
  2. GaborH

    How to add reference no to items on the report?

    I am trying to add reference numbers (1,2,3,etd.) to items listed on a report. The numbers can not be ID numbers, because the report is a result of a query and not every item with the oridinal ID is listed. The reference numbers are only for people to coordinate their reading. So how can I go...
  3. GaborH

    Overflow error?

    Thank you, that worked great!!!
  4. GaborH

    Overflow error?

    I am getting an overlow error, and have no idea what starts this problem, or how to go about solving this. My data is simple, 1) table with three fields prod_no txt qty number/double lcm_cost number/double 2) Query1 that groups prod_no, and sums qty and lcm_cost 3) Query2 divides...
  5. GaborH

    Source for historical memory prices?

    Can anyone suggest sources for locating historical memory prices? I am looking at a ton of old memory, and trying to figure out what they paid for it in 2000 and 2001, and wonder what would it be worth today. Any suggestions highly appreciated! GaborH
  6. GaborH

    DOS reports cut-off within XP...

    Please help… I cannot seem to set a printer to properly print DOS based Fox-Pro report within XP. The reports get cut off. Would the fix be changing a setting within XP or perhaps the HP Laserjet 1200? I am new to XP, but in Win’98 when I added a printer, I could specify that I the printer...
  7. GaborH

    conditional count, count iif or iif count?

    Thank you both for the quick replies. I wanted to total up the weekly list by this txt field, without regard to customerID, and you both have set me on the right track. Thank you!
  8. GaborH

    conditional count, count iif or iif count?

    Forgive the basic question, but this is really driving me nuts. I have a db that tracks payments. The txt field Initial_or_FollowOn designates if a payment is the first on a contract or not. I would like to Count the number of times a payment is flagged as “Initial” or “Follow-On” with...
  9. GaborH

    link queries from different databases?

    Thank you for the hint. Forgive my confusion, but I presume you mean query design view. In that case the Show Table window only lists tables and queries in my currently open database. There seems to be no option for selecting another database. The same goes for the Expression builder. Am I...
  10. GaborH

    link queries from different databases?

    I presume that TransferDatabase function is the best way. However, I am not sure if it is the only way.
  11. GaborH

    link queries from different databases?

    Basic question from a newbie: How would I go about linking queries from different databases? I have linked tables, but have not idea how to go about the same process for queries. Any hints highly appreciated.
  12. GaborH

    Combo box error with unusual name

    This is likely a simple problem, but this novice is clueless. I have a drop down box, whereby an employee is selected by last name, and all associated projects are listed in the resulting query. All seemed to work well, until an employee with the name D’souza was selected. I checked, and...
  13. GaborH

    Printed Report differs from preview version

    Printer error. Some fonts are not loading correctly.
  14. GaborH

    Printed Report differs from preview version

    Sounds basic, but please read on. Has anyone seen anything like this? I have a number of reports drafted several weeks ago. Now, when I preview the reports, everything looks fine. However, the printed copy is without title, or on some reports, the details are missing and only the total...
  15. GaborH

    Select query can not add up output of 2 crosstab queries

    Please help. This is likely something very basic, but I can’t see past it. Three separate cross tab queries list allocate revenues to different departments. A separate query is used for each month. Ideally, I am trying to combine all three queries via a select query. What is stumping me, is...
  16. GaborH

    How does Requery cmd change from form to subform?

    I have a text box with Dlookup on a continuous subfrom. The text box updates by click event, specifically a macro with Select Object and Requery command. While the subform is used alone, the textbox updates properly. However, when used with the main form, I get a Failed Action error...
  17. GaborH

    Subform with Dlookup, almost works...

    Sorry about the rambling explanation. I have no idea what I doing wrong. Any help, or hints are highly appreciated. Thank you, GaborH
  18. GaborH

    Subform with Dlookup, almost works...

    I have a continuous form tbl_Projects_resources, that operates as a subform. User selects a project to staff, then on the subform, selects a ResourceNo via a combo box. The next field over from resource box is Name of the employee associated with the ResourceNo. The field Name does not exist...
  19. GaborH

    dynamic date specific CTquery, static report

    Thank you dhookum! I am also trying to total my columns by month, but I have 3 months of department specific columns. The columns are Dept1/June, Dept2/June, June total, Dept1/July, Dept2/July, July total, etc. Q. Is it possible to have several total columns in a CT query that total on...
  20. GaborH

    dynamic date specific CTquery, static report

    I am not sure if this question is really appropriate in this group. It has to do with the mechanics of a cross tab query and associated report. Specifically, I have a cross tab query with columns that are department and month specific. ( Dept.1/June, Dept.2/June, etc.) The associated report...

Part and Inventory Search

Back
Top