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

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

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

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

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 .