Search results for query: *

The data type is date/time.

I am using client supplied data thru odbc in Access 2002 When I write a command it's doesn't select the right dates. In the arhdrh file and the invoice date fields. The command is: Between #1/1/2007# And #12/31/2009# It looks like it returns all the records. The data is from SagePFW and...

LB, Thanks for your help. I think I am okay for now.

Thanks for explaining the difference between record selection and group selection. I found that helpful. I am begining to understand it, but I think that is where my problem is. I have as record selection: {ARHDRH.Shipdate} = {?Date Range} I have group selection: {ARHDRH.Shipdate} = Maximum...

How do I create runnng totals across groups? I am only familiar with creating running totals within groups. When I select 2003 to 2007 the running total shows the correct last ship date. When I select 2003 it show the last ship date being in 2003.

This is working well. The situation changed some from when I originally posted here. I found that in the data there are no blank ship to's they default automatically from the customer key if nothing was entered. I had to suppress duplicates. I created a formula called ship dates: formula =...

if isnull({table.shiptokey}) then {table.customerkey} else {table.shiptokey} When I create a formula for this I get "a statement is expected here" and it highlights {table.customerkey} Is there something else I need to do?

I am trying to create a report that will list the date of the last order placed by a customer, by ship to address. I have 3 columns: Customer Key, Ship To Key, and Ship Date. Sometimes the ship to key will be blank, meaning we need to default to the Customer Key because the ship to is the same...

The user is just writing in the checkoff cell. Also, we don't care about a history. Tell me more how creating column headers conditionally would work. I need it to create the number of columns required for this report. Each time the report is ran it will be a different number of columns. I'm...

Thanks for your reply. None of the columns are populated. The rows are populated. It's a check list. When the first item in the row is accomplished column 1 get a check mark, when it happens again column2 gets a check mark. Each report has a different number of columns. They are at random...

I have created a formula that asks how many columns do you want to see. Next I need to put that formula somewhere into the cross tab so that it will create the number of blank columns I specify. Also I would like it to number the columns across the top. Such as column 1, column 2 etc...

How do I tell whether I am using ole db or Oracle Native? Crystal 9 and Oracle 8i.

module id tablename row_id userfieldprofile_id tab_id type_cd parent -not used description required datatype fieldposition usereditmask lookupcategory userfieldvalue numberfield stringfield bytefield datefield logicalfield comment_id constraintvalue changeby lastchange type_cat Let me know if...

Here are the available field details for userfield file. It stores user field values and other information for user defined fields. I linked (inner join) USERFIELD.ROW_ID to matter.matternumber_id. And I linked (inner join)matterlitigation.matternumber_id to matter.matternumber_id. See...

if {USERFIELD.FIELDPOSITION} = 1200 and {USERFIELD.NUMBERFIELD} = 1 then Userfield.fieldposition is the 1200th line (record selection), and userfield.numberfield is the value in that fieldposition. I need to go to that 1200 line and evaluate the value there and print other records based on...

I am trying to print certain records based on the value of one line. For example if userfield.fieldposition=1200 and userfield.numberfield= 1 then print certain lines. {USERFIELD.FIELDPOSITION} in [1000.00, 1100.00, 1200.00, 1600.00, 1800.00, 1850.00, 100.00, 2000.00, 2100.00, 2200.00...

The fields have data, they are just not showing when a field from a different file is dragged into the preview screen.

I have added several fields to the report from the invoice.detail file and the data shown when I do a preview. As soon as I add a new field from another file such as matter, the existing data shown in preview disappears. When I undo this insert the data shows again. This is happening on many if...

I have changed my direction some. I want to be able to select records by matter.number. The row.id and the matter.number.id are both number data type. Examples of both would be from 10,019.00 to 16,693.00. I need to select records based on the matter number which is a string, for example...

That seems to be working when I use the matter.number for my main record selection. However, in 3 subreports the exact data I need is not showing up. I need to use matter.number.id (which is different from matter.number) on some subreports. Also, I need to use row.id which is linked to...