Search results for query: *

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

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

Thank you, that worked great!!!

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

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

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

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!

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

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

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

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.

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

Printer error. Some fonts are not loading correctly.

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

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

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

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

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

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

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