Select only negative numbered query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, just hoping for a bit of help on this one:

I have built a query which is linked via an ODBC database connection. I have
added 3 linked tables to my query. In my query I have a field called "NET
AVAIL". This field is a calculated field based upon the following expression:

Field Input is NET AVAIL: [ON HAND] - [REQRD]
Table Input is -- Blank --
Total Input is Expression

The way I have this written now it querys and displays all of my records
accurately, but it displays all my numbers which result in a positive "NET
AVAIL" as well as a negative. I would like to filter this calculation to
display on the results of this calculation which are negative.

I've tried many, many different things and just can't get it.
Any help is greatly appreciated! Thanks.
 
You didn't post a copy of the SQL of your query. I suspect what you are
looking for is a selection criterion. If you are working in query design
mode, just add "<0" (without the quotes) in the selection under that field.

If you are working against a SQL statement in code, you'll need to look into
using a WHERE clause.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I am using the Query Design Mode to enter fields, table, input, etc... And I
have tried the "<0" without the quotes for criteria and when I Run the query
it pops up with an Input Data Paramater" box. Which I'm not sure what that is
for. I just want to weed out the positives.

Here's the SQL: (I also have many other columns as you will notice)

SELECT V_INVENTORY_MSTR.PRODUCT_LINE AS [PR LINE], V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE AS [PREV YTD],
V_INVENTORY_MSTR.QTY_CURRENT_USAGE AS [QTY YTD], V_INVENTORY_MSTR.QTY_ONHAND
AS [ON HAND], V_INVENTORY_MSTR.QTY_REQUIRED AS REQRD, [ON HAND]-[REQRD] AS
[NET AVAIL], Sum(V_ORDER_LINES.QTY_ORDERED) AS [SO QTY],
V_INVENTORY_MSTR.QTY_ONORDER_WO AS [WO QTY],
First(V_ORDER_LINES.DATE_ITEM_PROM) AS [SHIP DUE],
First(V_JOB_HEADER.DATE_DUE) AS [WO DATE], V_JOB_HEADER.DATE_START AS [WO
START], V_JOB_HEADER.QTY_COMPLETED AS [QTY DONE], Sum(V_ORDER_LINES.QTY_BO)
AS [BACK ORD]
FROM (V_INVENTORY_MSTR LEFT JOIN V_ORDER_LINES ON V_INVENTORY_MSTR.PART =
V_ORDER_LINES.PART) LEFT JOIN V_JOB_HEADER ON V_INVENTORY_MSTR.PART =
V_JOB_HEADER.PART
GROUP BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE, V_INVENTORY_MSTR.QTY_CURRENT_USAGE,
V_INVENTORY_MSTR.QTY_ONHAND, V_INVENTORY_MSTR.QTY_REQUIRED,
V_INVENTORY_MSTR.QTY_ONORDER_WO, V_JOB_HEADER.DATE_START,
V_JOB_HEADER.QTY_COMPLETED
HAVING (((V_INVENTORY_MSTR.PRODUCT_LINE)="20" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="17" Or (V_INVENTORY_MSTR.PRODUCT_LINE)="19"
Or (V_INVENTORY_MSTR.PRODUCT_LINE)="50" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="52") AND
((First(V_ORDER_LINES.DATE_ITEM_PROM))<>#1/1/1900#))
ORDER BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART;


Jeff Boyce said:
You didn't post a copy of the SQL of your query. I suspect what you are
looking for is a selection criterion. If you are working in query design
mode, just add "<0" (without the quotes) in the selection under that field.

If you are working against a SQL statement in code, you'll need to look into
using a WHERE clause.

Regards

Jeff Boyce
Microsoft Office/Access MVP

la knight said:
Hello, just hoping for a bit of help on this one:

I have built a query which is linked via an ODBC database connection. I
have
added 3 linked tables to my query. In my query I have a field called "NET
AVAIL". This field is a calculated field based upon the following
expression:

Field Input is NET AVAIL: [ON HAND] - [REQRD]
Table Input is -- Blank --
Total Input is Expression

The way I have this written now it querys and displays all of my records
accurately, but it displays all my numbers which result in a positive "NET
AVAIL" as well as a negative. I would like to filter this calculation to
display on the results of this calculation which are negative.

I've tried many, many different things and just can't get it.
Any help is greatly appreciated! Thanks.
Click to expand...
Click to expand...
 
I may have missed it, but I didn't see a clause in your SQL statement that
looks like:

WHERE xxxx < 0

(where xxxx is the calculated value you first mentioned).

Where exactly are you putting the selection criterion?

Regards

Jeff Boyce
Microsoft Office/Access MVP


la knight said:
I am using the Query Design Mode to enter fields, table, input, etc... And
I
have tried the "<0" without the quotes for criteria and when I Run the
query
it pops up with an Input Data Paramater" box. Which I'm not sure what that
is
for. I just want to weed out the positives.

Here's the SQL: (I also have many other columns as you will notice)

SELECT V_INVENTORY_MSTR.PRODUCT_LINE AS [PR LINE], V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE AS [PREV YTD],
V_INVENTORY_MSTR.QTY_CURRENT_USAGE AS [QTY YTD],
V_INVENTORY_MSTR.QTY_ONHAND
AS [ON HAND], V_INVENTORY_MSTR.QTY_REQUIRED AS REQRD, [ON HAND]-[REQRD] AS
[NET AVAIL], Sum(V_ORDER_LINES.QTY_ORDERED) AS [SO QTY],
V_INVENTORY_MSTR.QTY_ONORDER_WO AS [WO QTY],
First(V_ORDER_LINES.DATE_ITEM_PROM) AS [SHIP DUE],
First(V_JOB_HEADER.DATE_DUE) AS [WO DATE], V_JOB_HEADER.DATE_START AS [WO
START], V_JOB_HEADER.QTY_COMPLETED AS [QTY DONE],
Sum(V_ORDER_LINES.QTY_BO)
AS [BACK ORD]
FROM (V_INVENTORY_MSTR LEFT JOIN V_ORDER_LINES ON V_INVENTORY_MSTR.PART =
V_ORDER_LINES.PART) LEFT JOIN V_JOB_HEADER ON V_INVENTORY_MSTR.PART =
V_JOB_HEADER.PART
GROUP BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE, V_INVENTORY_MSTR.QTY_CURRENT_USAGE,
V_INVENTORY_MSTR.QTY_ONHAND, V_INVENTORY_MSTR.QTY_REQUIRED,
V_INVENTORY_MSTR.QTY_ONORDER_WO, V_JOB_HEADER.DATE_START,
V_JOB_HEADER.QTY_COMPLETED
HAVING (((V_INVENTORY_MSTR.PRODUCT_LINE)="20" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="17" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="19"
Or (V_INVENTORY_MSTR.PRODUCT_LINE)="50" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="52") AND
((First(V_ORDER_LINES.DATE_ITEM_PROM))<>#1/1/1900#))
ORDER BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART;


Jeff Boyce said:
You didn't post a copy of the SQL of your query. I suspect what you are
looking for is a selection criterion. If you are working in query design
mode, just add "<0" (without the quotes) in the selection under that
field.

If you are working against a SQL statement in code, you'll need to look
into
using a WHERE clause.

Regards

Jeff Boyce
Microsoft Office/Access MVP

la knight said:
Hello, just hoping for a bit of help on this one:

I have built a query which is linked via an ODBC database connection. I
have
added 3 linked tables to my query. In my query I have a field called
"NET
AVAIL". This field is a calculated field based upon the following
expression:

Field Input is NET AVAIL: [ON HAND] - [REQRD]
Table Input is -- Blank --
Total Input is Expression

The way I have this written now it querys and displays all of my
records
accurately, but it displays all my numbers which result in a positive
"NET
AVAIL" as well as a negative. I would like to filter this calculation
to
display on the results of this calculation which are negative.

I've tried many, many different things and just can't get it.
Any help is greatly appreciated! Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Here's the SQL again with a Where clause for the criteria. I kept taking out
all the ones I tried because I kept getting error messages or pop up windows
asking for paramter input. The code this way gives me a error message which
says "Data type mismatch". I've also received syntax errors too for other
configurations.

SQL:

SELECT V_INVENTORY_MSTR.PRODUCT_LINE AS [PR LINE], V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE AS [PREV YTD],
V_INVENTORY_MSTR.QTY_CURRENT_USAGE AS [QTY YTD], V_INVENTORY_MSTR.QTY_ONHAND
AS [ON HAND], V_INVENTORY_MSTR.QTY_REQUIRED AS REQRD,
Sum(V_ORDER_LINES.QTY_ORDERED) AS [SO QTY], V_INVENTORY_MSTR.QTY_ONORDER_WO
AS [WO QTY], First(V_ORDER_LINES.DATE_ITEM_PROM) AS [SHIP DUE],
First(V_JOB_HEADER.DATE_DUE) AS [WO DATE], V_JOB_HEADER.DATE_START AS [WO
START], V_JOB_HEADER.QTY_COMPLETED AS [QTY DONE], Sum(V_ORDER_LINES.QTY_BO)
AS [BACK ORD]
FROM (V_INVENTORY_MSTR LEFT JOIN V_ORDER_LINES ON V_INVENTORY_MSTR.PART =
V_ORDER_LINES.PART) LEFT JOIN V_JOB_HEADER ON V_INVENTORY_MSTR.PART =
V_JOB_HEADER.PART
GROUP BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE, V_INVENTORY_MSTR.QTY_CURRENT_USAGE,
V_INVENTORY_MSTR.QTY_ONHAND, V_INVENTORY_MSTR.QTY_REQUIRED,
V_INVENTORY_MSTR.QTY_ONORDER_WO, V_JOB_HEADER.DATE_START,
V_JOB_HEADER.QTY_COMPLETED
HAVING (((V_INVENTORY_MSTR.PRODUCT_LINE)="20" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="17" Or (V_INVENTORY_MSTR.PRODUCT_LINE)="19"
Or (V_INVENTORY_MSTR.PRODUCT_LINE)="50" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="52") AND ("«Expr» Where [NET AVAIL]"<0) AND
((First(V_ORDER_LINES.DATE_ITEM_PROM))<>#1/1/1900#))
ORDER BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART;


Jeff Boyce said:
I may have missed it, but I didn't see a clause in your SQL statement that
looks like:

WHERE xxxx < 0

(where xxxx is the calculated value you first mentioned).

Where exactly are you putting the selection criterion?

Regards

Jeff Boyce
Microsoft Office/Access MVP


la knight said:
I am using the Query Design Mode to enter fields, table, input, etc... And
I
have tried the "<0" without the quotes for criteria and when I Run the
query
it pops up with an Input Data Paramater" box. Which I'm not sure what that
is
for. I just want to weed out the positives.

Here's the SQL: (I also have many other columns as you will notice)

SELECT V_INVENTORY_MSTR.PRODUCT_LINE AS [PR LINE], V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE AS [PREV YTD],
V_INVENTORY_MSTR.QTY_CURRENT_USAGE AS [QTY YTD],
V_INVENTORY_MSTR.QTY_ONHAND
AS [ON HAND], V_INVENTORY_MSTR.QTY_REQUIRED AS REQRD, [ON HAND]-[REQRD] AS
[NET AVAIL], Sum(V_ORDER_LINES.QTY_ORDERED) AS [SO QTY],
V_INVENTORY_MSTR.QTY_ONORDER_WO AS [WO QTY],
First(V_ORDER_LINES.DATE_ITEM_PROM) AS [SHIP DUE],
First(V_JOB_HEADER.DATE_DUE) AS [WO DATE], V_JOB_HEADER.DATE_START AS [WO
START], V_JOB_HEADER.QTY_COMPLETED AS [QTY DONE],
Sum(V_ORDER_LINES.QTY_BO)
AS [BACK ORD]
FROM (V_INVENTORY_MSTR LEFT JOIN V_ORDER_LINES ON V_INVENTORY_MSTR.PART =
V_ORDER_LINES.PART) LEFT JOIN V_JOB_HEADER ON V_INVENTORY_MSTR.PART =
V_JOB_HEADER.PART
GROUP BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE, V_INVENTORY_MSTR.QTY_CURRENT_USAGE,
V_INVENTORY_MSTR.QTY_ONHAND, V_INVENTORY_MSTR.QTY_REQUIRED,
V_INVENTORY_MSTR.QTY_ONORDER_WO, V_JOB_HEADER.DATE_START,
V_JOB_HEADER.QTY_COMPLETED
HAVING (((V_INVENTORY_MSTR.PRODUCT_LINE)="20" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="17" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="19"
Or (V_INVENTORY_MSTR.PRODUCT_LINE)="50" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="52") AND
((First(V_ORDER_LINES.DATE_ITEM_PROM))<>#1/1/1900#))
ORDER BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART;


Jeff Boyce said:
You didn't post a copy of the SQL of your query. I suspect what you are
looking for is a selection criterion. If you are working in query design
mode, just add "<0" (without the quotes) in the selection under that
field.

If you are working against a SQL statement in code, you'll need to look
into
using a WHERE clause.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello, just hoping for a bit of help on this one:

I have built a query which is linked via an ODBC database connection. I
have
added 3 linked tables to my query. In my query I have a field called
"NET
AVAIL". This field is a calculated field based upon the following
expression:

Field Input is NET AVAIL: [ON HAND] - [REQRD]
Table Input is -- Blank --
Total Input is Expression

The way I have this written now it querys and displays all of my
records
accurately, but it displays all my numbers which result in a positive
"NET
AVAIL" as well as a negative. I would like to filter this calculation
to
display on the results of this calculation which are negative.

I've tried many, many different things and just can't get it.
Any help is greatly appreciated! Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Your SQL statement includes something extra, the "<<Expr>>".

Try this ...

Start with a new (empty) query in design mode. Add the (?single) table that
has the data you need to use to calculate the value you mentioned. Add a
new field that calculates that value. In the Selection Criterion "cell",
type in your criterion (i.e., <0).

Run the query. Does it return a list of negative numbers?

Open the query in design mode and add some more pieces. Does it still run?

Keep building up until your query has all the pieces you have now, in your
SQL statement. Does it still run? If you need to use the SQL statement
rather than the query, change the view in design mode to SQL and copy the
SQL Access generates from what you've built in design mode.

Regards

Jeff Boyce
Microsoft Office/Access MVP

la knight said:
Here's the SQL again with a Where clause for the criteria. I kept taking
out
all the ones I tried because I kept getting error messages or pop up
windows
asking for paramter input. The code this way gives me a error message
which
says "Data type mismatch". I've also received syntax errors too for other
configurations.

SQL:

SELECT V_INVENTORY_MSTR.PRODUCT_LINE AS [PR LINE], V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE AS [PREV YTD],
V_INVENTORY_MSTR.QTY_CURRENT_USAGE AS [QTY YTD],
V_INVENTORY_MSTR.QTY_ONHAND
AS [ON HAND], V_INVENTORY_MSTR.QTY_REQUIRED AS REQRD,
Sum(V_ORDER_LINES.QTY_ORDERED) AS [SO QTY],
V_INVENTORY_MSTR.QTY_ONORDER_WO
AS [WO QTY], First(V_ORDER_LINES.DATE_ITEM_PROM) AS [SHIP DUE],
First(V_JOB_HEADER.DATE_DUE) AS [WO DATE], V_JOB_HEADER.DATE_START AS [WO
START], V_JOB_HEADER.QTY_COMPLETED AS [QTY DONE],
Sum(V_ORDER_LINES.QTY_BO)
AS [BACK ORD]
FROM (V_INVENTORY_MSTR LEFT JOIN V_ORDER_LINES ON V_INVENTORY_MSTR.PART =
V_ORDER_LINES.PART) LEFT JOIN V_JOB_HEADER ON V_INVENTORY_MSTR.PART =
V_JOB_HEADER.PART
GROUP BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE, V_INVENTORY_MSTR.QTY_CURRENT_USAGE,
V_INVENTORY_MSTR.QTY_ONHAND, V_INVENTORY_MSTR.QTY_REQUIRED,
V_INVENTORY_MSTR.QTY_ONORDER_WO, V_JOB_HEADER.DATE_START,
V_JOB_HEADER.QTY_COMPLETED
HAVING (((V_INVENTORY_MSTR.PRODUCT_LINE)="20" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="17" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="19"
Or (V_INVENTORY_MSTR.PRODUCT_LINE)="50" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="52") AND ("«Expr» Where [NET AVAIL]"<0)
AND
((First(V_ORDER_LINES.DATE_ITEM_PROM))<>#1/1/1900#))
ORDER BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART;


Jeff Boyce said:
I may have missed it, but I didn't see a clause in your SQL statement
that
looks like:

WHERE xxxx < 0

(where xxxx is the calculated value you first mentioned).

Where exactly are you putting the selection criterion?

Regards

Jeff Boyce
Microsoft Office/Access MVP


la knight said:
I am using the Query Design Mode to enter fields, table, input, etc...
And
I
have tried the "<0" without the quotes for criteria and when I Run the
query
it pops up with an Input Data Paramater" box. Which I'm not sure what
that
is
for. I just want to weed out the positives.

Here's the SQL: (I also have many other columns as you will notice)

SELECT V_INVENTORY_MSTR.PRODUCT_LINE AS [PR LINE],
V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE AS [PREV YTD],
V_INVENTORY_MSTR.QTY_CURRENT_USAGE AS [QTY YTD],
V_INVENTORY_MSTR.QTY_ONHAND
AS [ON HAND], V_INVENTORY_MSTR.QTY_REQUIRED AS REQRD, [ON HAND]-[REQRD]
AS
[NET AVAIL], Sum(V_ORDER_LINES.QTY_ORDERED) AS [SO QTY],
V_INVENTORY_MSTR.QTY_ONORDER_WO AS [WO QTY],
First(V_ORDER_LINES.DATE_ITEM_PROM) AS [SHIP DUE],
First(V_JOB_HEADER.DATE_DUE) AS [WO DATE], V_JOB_HEADER.DATE_START AS
[WO
START], V_JOB_HEADER.QTY_COMPLETED AS [QTY DONE],
Sum(V_ORDER_LINES.QTY_BO)
AS [BACK ORD]
FROM (V_INVENTORY_MSTR LEFT JOIN V_ORDER_LINES ON V_INVENTORY_MSTR.PART
=
V_ORDER_LINES.PART) LEFT JOIN V_JOB_HEADER ON V_INVENTORY_MSTR.PART =
V_JOB_HEADER.PART
GROUP BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART,
V_INVENTORY_MSTR.QTY_YTD_USAGE, V_INVENTORY_MSTR.QTY_CURRENT_USAGE,
V_INVENTORY_MSTR.QTY_ONHAND, V_INVENTORY_MSTR.QTY_REQUIRED,
V_INVENTORY_MSTR.QTY_ONORDER_WO, V_JOB_HEADER.DATE_START,
V_JOB_HEADER.QTY_COMPLETED
HAVING (((V_INVENTORY_MSTR.PRODUCT_LINE)="20" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="17" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="19"
Or (V_INVENTORY_MSTR.PRODUCT_LINE)="50" Or
(V_INVENTORY_MSTR.PRODUCT_LINE)="52") AND
((First(V_ORDER_LINES.DATE_ITEM_PROM))<>#1/1/1900#))
ORDER BY V_INVENTORY_MSTR.PRODUCT_LINE, V_INVENTORY_MSTR.PART;


:

You didn't post a copy of the SQL of your query. I suspect what you
are
looking for is a selection criterion. If you are working in query
design
mode, just add "<0" (without the quotes) in the selection under that
field.

If you are working against a SQL statement in code, you'll need to
look
into
using a WHERE clause.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello, just hoping for a bit of help on this one:

I have built a query which is linked via an ODBC database
connection. I
have
added 3 linked tables to my query. In my query I have a field called
"NET
AVAIL". This field is a calculated field based upon the following
expression:

Field Input is NET AVAIL: [ON HAND] - [REQRD]
Table Input is -- Blank --
Total Input is Expression

The way I have this written now it querys and displays all of my
records
accurately, but it displays all my numbers which result in a
positive
"NET
AVAIL" as well as a negative. I would like to filter this
calculation
to
display on the results of this calculation which are negative.

I've tried many, many different things and just can't get it.
Any help is greatly appreciated! Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Jeff:

Thanks for all your help. I did take your advice by starting with a blank
query and building it up piece by piece until I was returned the results I
was looking for. I guess the best advice I can give other new users would be
to do it this way also. It did take some trial and error to get the columns
of queries in the correct order, totaled, group and sorted to achieve my
results, but once I did - it was a beautiful thing!

One other question if your still listening - Is there a way to change the
display text of a query result to read as something else? Meaning this:

If I query a "PRODUCT_ID" which has a value of "20", can I change the
display of the result in the field to read as "lamp" instead of "20"?

Hope that makes sense. I've looked for an answer for this one too, but I'm
not sure I'm using the correct terminology to find the answer.
 
Do you have a table somewhere that lists
20 Lamp
30 Desk
40 Chair

If so, in your query, add that table, and join on the PRODUCT_ID. Then,
instead of showing PRODUCT_ID, select the field from the (lookup) table that
has "Lamp", "Desk", "...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tweaking a calculated field in a query 4
A negative display watch 9
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Calculations, Queries and making it all come together in my table 4
Access Updating inventory levels 0
Access Dcount (multiple criteria) 3
Calculating YOY Growth 1
Time in calculated field for shifts going past midnight 0

Back
Top