Firoz Ahmed

[firoz.raj]

Kindly help me

I am having a table production which table consists productname, item_code,qty and approx 1000 records in that
there are three type of product_id
p1,p2, p3 ....to p300 product_id is for production consumable
m1, m2,m3 .....to m700 product_id is for maintenance consumable
rest other are for tool consumable products
i want to see only maintenance consumable products by ms access query
how should i do it ? on the basis of product_id

i have already run on sql view

SELECT DISTINCTROW PRODUCTION.Item_code, PRODUCTION.Productname,COUNT( PRODUCTION.Qty),
FROM PRODUCTION
GROUP BY PRODUCTION.Item_code, PRODUCTION.Productname
HAVING ITEM_CODE= "m*";

but it is not solve my problem
kindly help me it is very urgent

 

[DCrake]

Change

HAVING ITEM_CODE= "m*";

To

HAVING ITEM_CODE Like "m*";

 

[firoz.raj]

I Am Having A Database Which Is Having Production Consumable
Product With Product_id P1 To P199 Similarly Maintenance Cons.
And Tools Consumable How Should I Make A Query So That Last Product_id Should Return. When User Enter Something It Should
Automatic Generate P200 For Producuction Cosumable

Data Entry Operator Is Putting A Entry From Front End I Will
Generate A Query So That When User Click Production Consumable , Maintenance Consumable, Tools Consumable The
Last Entry Should Come In List Box (that Is For Reference Sir)
When User Click On Tools Automatic T1500 The Last Product_id
Should Come In A Query

I Will Remain Grateful To You .
Kindly Help Me.
I Am Sending A Copy To You Front End As Well As Backend
Kindly Don't Mind Visual Basic 6 Form Is Only For Reference

 

[raskew]

Hi -

As you can see from your example, combining alpha and numeric and saving as a text field prevents proper sorting.

Suggest you split the product type and the product ID into two separate fields, saving as (1) Text, (2) Number respectively.

Having done that, query SQL something like this would give you what you're after.

SELECT Top 1 IDCode, ProductID
FROM Table1
WHERE (((Table1.IDCode)="P"));

HTH - Bob

 

[firoz.raj]

can anybody tell me .how should i resolve this issue.when try to open ms access database got error. The database is an Unexpected state.
Kindly help me.any help would be Greately appreciated.Kindly find the
error.zip attachment also.