supply database

  • Thread starter Thread starter msaccesnoob
  • Start date Start date
M

msaccesnoob

foakes

I have a certain problem with my acces database
when I setup a query I want to select only count of a category.
example

i use 4 objects in the category.

laptop/workstation/tft/crt

i want to know how much laptops i have and i want these in a repor
what i can print and send by mail.

i also want to have an automatic check so i can see how much computer
i have in stock and when it is to low example
4 computers is minimum amount
-2
so I must order 2 computers.

i want this report send automaticly to email

thanks in regards

marvin AKA NOO
 
Dependinig on your table structure, your query should look somethin
like...

SELECT Count(YourTable.YourField) AS Totals, YourTable.YourField A
Models
FROM YourTable
GROUP BY YourTable.YourField;

I've attached a simple example.

HT

+----------------------------------------------------------------
| Attachment filename: counta2k.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=181487
+----------------------------------------------------------------
 
How do you enter your data? Do you import it or manually input? Eithe
way, the query will automatically calculate the totals
 
It will if you try! Post a stripped down version of your db here an
I'll take a look for you
 
but that is the clue
i have information but i don't know how i must put it in acces
but i've put some information in excel sheet
so here you are

Asset tag Make Category Product Serial Room
20030100288 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E7110 SERIE
FPC07064B YBSN012487 273
364274 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6560 SERIE
FPC03040B YBLX058823 273
365182 FUJITSU SIEMENS WORKSTATIONS, DESKTOP COMPUTERS SCENIC S I815
P3/1000 128MB 20GB K523-V413-470 YBQN010793 273
336944 FUJITSU SIEMENS FLAT PANEL DISPLAYS ERGOPRO E150F PD68M52
SK9090FC 273
20031200252 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E4010D P4/140
256MB 40GB 24XCD NDL 135150-005 YBFP034826 273
20031200249 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E4010D P4/140
256MB 40GB 24XCD NDL 135150-005 YBFP034523 273
366470 FUJITSU SIEMENS MONITORS 177V 17inch S26361-K856-V15
YEKU081450 273
366471 FUJITSU SIEMENS MONITORS 177V 17inch S26361-K856-V15
YEKU081458 273
366472 FUJITSU SIEMENS MONITORS 177V 17inch S26361-K856-V15
YEKU081449 273
366467 FUJITSU SIEMENS MONITORS 177V 17inch S26361-K856-V15
YEKU081453 273
20030100217 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6540 P3/60
128MB 12GB CD BLV59E15E7C1 YBLX035742 273
336905 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6530 SERIE
FPC03034B YBLX012819 273
444131 COMPAQ WORKSTATIONS, DESKTOP COMPUTERS DESKPRO EXD P10/20C/8/6
NL 470012-336 8118FR4Z0HHP 273
365096 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6530 SERIE
FPC03034B R0200278/K00102ZDZ9 273
20031200089 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6530 SERIE
FPC03034B YBLX012749 273
20030200431 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK C1020 SERIE
S2639 K126 V100 YBDM089335 273
366211 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6540 SERIE
FPC047802 R0713673 273
336886 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6530 SERIE
FPC03034B YBLX012824 273
365075 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6540 SERIE
FPC047802 R0710955 273
365120 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6540 SERIE
FPC047802 YBLX028265 273
20031200263 FUJITSU/ICL MONITORS 171P PD16E091 YEGB043072 273
365375 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6530 SERIE
FPC03034B R9Z00841/K00051X713 273
365222 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6530 SERIE
FPC03034B R0200404/K00102ZE27 273
365453 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E5320 SERIE
FPC03030B R9X00009/K00041K2U9 273
354469 FUJITSU SIEMENS NOTEBOOK COMPUTERS LIFEBOOK E6560 SERIE
FPC03040B YBLX111300 273
20030700527 FUJITSU SIEMENS WORKSTATIONS, DESKTOP COMPUTERS SCENIC N30
P4/2400 256MB 40GB 48XCD CDRW S26361-K667-V111 YBEN065422 27
 
I need to know
example
how much laptops i have
that i can make a rapport so what i can see how much of category
have
create a form so i can add en remove easily a laptop

and i need to have a auto count so you can see automatilly by mail
if you still have enough laptops

:confused
 
You can import information from Excel, as long as you have the correc
data in the correct columns. ie

Column1----------Column2----------Column3----------Column4
20030100288------FUJITSU----------SIEMENS----------NOTEBOOK
365182-----------FUJITSU----------SIEMENS----------WORKSTATIONS
etc, et
 
Back
Top