Search results for query: *

I need to write a query that utilizes two tables, Table A and Table B. The column's that I need to query are Table A, SN and Table B SN2. I need to check table A, Column SN against, Table B, SN2 Column for the same information. Both column's might have Serial Numbers that have 13 digits, of...

I need to write a query that utilizes two tables, Table A and Table B. The column's that I need to query are Table A, SN and Table B SN2. I need to check table A, Column SN against, Table B, SN2 Column for the same information. Both column's have Serial Numbers that have 13 digits, of both...

In one table called NHSTAT, I need the total of a column called [GCFLAG] that has 'G's. In the other table called NASTAT, I need to check the column [SHIPDATE] against the Report Date or Date(). Basically, I need to check the Total of [GCFLAG] from NHSTAT and add the the total of [SHIPDATE]...

Once again OUTSTANDING!!!!! I sort of have one other question, it seems that when the math is complete I have one extra on the answer. For instance the formula should return a 2 and is returning a 3. Is that from using DCount? Thanks again if you were in CA I'd buy you a beer. Jim

I am trying to put an equation in the report section where: In one column [GCFLAG] there are G's and C's. In another column [ORDER] there are various items. I need to count the # of G's in [GCFLAG] and then compare the [ORDER] where ORDER is not equal to ' ' or spaces. In DB3 code the...

Outstanding !!!!! Thanks.

I am trying to put an equation in the report section where: In one column [GCFLAG] there are G's and C's. In another column [SHIPDATE] there are dates of order. And lastly I have a date of report Date() I need to count the # of G's in GCFLAG and then compare the order dates to see if they...

Jerby, Thanks for writing, I am still coming up with an answer of "0". If "GCFLAG" is a coluumn and "ORDER" is a column in the db, would both have to be in ""? I am just guessing at this point. Thanks in advance for any help, Jim

Cosmo, Thanks for your help, I have moved the footer section directly under the details section, and have moved the details section directly under the header section. The problem is that I am still left with about 15 blank lines in the report. Thanks for all your help, it is very much...

I have a report that is writeen in DB3, and I am converting it, I need help converting the following equation to Access count for gcflag = "G" .and. order ' ' to tempvarg I would take it that I should be able to utilize dcount or dsum to get the answer to this report, how about...

This seems to have worked. How can I write a report without a details section? I have tried everything to delete it but NOGO. Thanks, Jim Nelson

Beth, Thanks for your reply. I should have made this clear in the beginning. I am using Access 2000. I have a column that is labeled GCFLAG, in this column there are lets say 300 entries, 225 with the letter "G" and 75 with the letter "C". I am trying to print out a...

I am trying to make a output where (=-sum([GCFLAG]="C"). The answer to this is about 225. When I insert a Text box the answer is displayed on 76 pages. How can I get the answer to display on just 1 page? Thanks in advance. Jim Nelson .