Search results for query: *

Hello good people, Have a small problem with a formula totaling shared numbervars from a subreport. CR10 from Pervasive SQL DB. Here is a formula from one of my subreports whileprintingrecords; if isnull({#RTotal0}) then shared numbervar Glulam_Total := 0 else shared numbervar...

Hello, I have a question about arrays and I am not sure that it has been addressed exactly. My apologies if it has. Using CR 10 and Pervasive SQL Backend I have 2 Groups on the report Category and Item. My goal is to make multiple item's quantities on a single line. I think I need to...

Hello again, CR10 & Access 2003 I want use a conditional group count in my report for several formulas but I am having issues creating the running total field that will count only the instances of a group not the actual records themselves. I want to get a count of the groups (GP3) within...

Hello all, Client has a data page from external source in an excel format for weekly data. The weekly data is placed into columns for each week. There are 3 sections that get added to each week ( a new column is added for each section each week, see Gross, Cans, Traffic below). I am...

Hello all, Client has a data page from external source in an excel format for weekly data. The weekly data is placed into columns for each week. There are 3 sections that get added to each week ( a new column is added for each section each week, see Gross, Cans, Traffic below). I am...

Hello everybody, I am attempting to create several formulas that summarize parts of my report (avg). I have one formula that seems to be working averaging over all of group1. The second formula does not seem to work that is the same formula with an additional criteria limiting the average to...

Hello All, CR10 and Access, Trying to post this again. lost the last one due to a server error. Here goes... Got a report with 3 Groups, 3 Columns (groups included), a page header with Group1 summary fields on it. I cannot use a group for the header due to the fact I have my groups set to...

Hello All, CR 10 / Access 2003 I have four groups: Group1: DivisionID Group2: SQFT Group3: Plan_Number Group4: Community_Number Is it possible to sort on Group3 Prior to Group2 without re-arranging the grouping? I need the order of the groups to stay intact, but the data is all jumbled...

Hello I have a little problem getting a crystal report to launch from Access. The error I get is marked with a ====>. One one computer I get "There was a Hardware Error" on another I get a dao.workspace error. I have tested and checked the code up until the point of the error and everything...

Hello, I have 3 tables with 3 linked fields. Actually there is only one "table" the other 2 are views of the same table. Here they are: Datelog:(table) (PK)JobID (PK)LotID (PK)TaskID TaskDate r_LathAll (query) JobID LotID TaskID=1 TaskDate r_SheetrockAll (query) JobID LotID TaskID=22...

Hello all, I have a scheduling database that I am only using one table "DateLog" It contains these fields: * JobID Int-PK * LotID Txt-PK * TaskID Int-PK - List from TaskList Table * TripID Int-PK * TaskDate Date * ForemanID Int - List from Foreman Table * TaskQty...

Hello all, I would love some guidance on how to structure my reports within my new "normalized" Access DB. Most of my reporting will be based from a single table "DateLog". This table contains the following fields: PK: JobID, LotID, TaskID, TripID Other: TaskDate, ForemanID, TaskQty Each...

Hello, I am trying to create a spreadsheet view in a query that will allow edits. I was starting to build a query using dlookup but that will not allow edits. Is there any way to achive this? It is a useful view that I hopefully will not have to abandon, due to normalization. Any help would...

Hello, I need to know if a special query can be created to properly format my data for a XY Scatter chart. I am afraid to say that word "chart" as no one will take on anything related to them in any forum across the Internet. Anyways, I wnat to take my data that looks like this: DivisionID...

Hello Here is an example of my data DivisionID,DrywallMBF,Cost LSC,10095,6000 BAH,12095,7300 LSC,11095,6500 This data is pulled from a query in Access. I need to plot it on a Scatter Graph. X Axis is DrywallMBF and Cost is Y Axis. I got to this point in MS Graph, it shows every point...

Hello, I have a table (in the midst of several one to many relationships. The primary key is a combo of: JobID LotID TaskID TripID The only one that will not be driven from the parent will be TripID. When the user creates a new record, the first three fields will be combo boxes, and the...

Hello, I want to give my users a warning when moving to the next record if certain fields or procedures are not entered properly. Where can I postpone the record change on a bound form to allow an OK/Cancel Message box to popup and ask the user to continue or remain at that record? Much...

Hello all nice to see you again, I am having a problem creating an append query to populate multiple records from input on a form. The field on the form is a date field. To sum it up, the user will type in the date and click the commit button that runs the query. The query will take that...

Hello All, I am creating a db for tracking dates of tasks completed per date. The users create a job and then log in each task per job. All of the tasks will be entered at the same time per job. As I have it set up right now, the user must create each task one at a time and is very...

Hello all, I have a table that I want to report on. It contains several date fields (Tasks Completed). I want to write a report that will have the dates consolidated into one master field that will be the first group on the report. Any suggestions on how to do this? I tried an append query...