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

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

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

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

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

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

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

Q.1. I am trying to create a cross tab query that has more than one field as column. My goal is to have month and department specific columns. For ex.: Dept.1/March, Dept.2/March, Dept.1./April,.... (the rows contain projects) I know that department and month fields could be combined into one...

I am attempting to build a planning/staffing tool. Projects can be "Booked" or "Probable". Is it possible to specify color of a field, or background, in my CT queries (and reports) on whether the project is "Booked" or "Probable"? Any hints are highly appreciated. Thank you! GaborH

I am trying to create a combo box that lists employees by job title and last name within a job title. I know that queries can only sort on field, and I can achieve a virtual primary/secondary sort with a field that would combine title and last name. But I wonder if there a simpler way of doing...

I am attempting to get a dcount command to work, but despite all my research I do not see the problem. Can someone throw me a hint? Expr1: DCount("[ID_calendar]","tbl_calendar","[HolidayDate]<" & [wk_End]) HolidayDate and wk_End are dates. Anything is well appreciated! GaborH

Is these something simple that I am overlooking? I have DLookUp function working correctly in a Make tbl query; however, the data type on the resulting table changes from date to txt. I have tried to set the querey format via "format(DLookup(...),"dd/mm/yyyy") and made sure that field...

Can someone be kind enough to give me a hint as how I can incorporate an "and" statement withing the criteria of an "iif" statement? Thank you!

I can not use the function "networkdays" in a query. The result is "undefined function in expression." I did check and confirm that file Msowcf.dll is loaded. Any suggestions will be highly appreciated.