Need A Hlep

Feb 23, 2008

hi

i'm trying to create a database but i'm facing some problem in qury


my database contain two fields which are

recieved date and released date

both of them contain dates



i want my result to be like :


date
1-2-2008
2-2-2008
3-2-2008
4-2-2008
5-2-2008
6-2-2008
7-2-2008
8-2-2008
9-2-2008
10-2-2008
.
.
.
.
until the end the of the month


recieved

5 1
-
1
-
1
1
-
-
1


released

1
-
-
1
2
-
-
-
-
1






date will view the dates
recieved example will view how many time 1-2-2008 is repeating in the recieved date field
released example will view how many time 1-2-2008 is repeating in the released date field

finally i would view the total of the recieved and released




i hope that i will get a help from somebody

View Replies


ADVERTISEMENT

Changing From One Mdb To Another One With A Hlep Of VB

Jan 9, 2008

I need a little help in the following topic:

There is an Access (2002) database used at our company covering its different tasks; different mdb files are used for different tasks (storage, invoicing etc.). All of them are linked to a central file that holds the tables.

Some of the users use more files; the same colleague uses for example the storage module and the service module.

I'd like to keep it this structured but I'd like to make it easier to change between the files so the user don't have to quit manually from the storage moduel and open a service module, giving his password for the tenth time per a day.

Could you help with an advice how I could do with VB that by clicking on a button the presently used file closes and another preprogrammed one opens.
(For closing I'm using DoCmd.Quit but no idea how to open something)

I really appreciate your help.

Peter

View 3 Replies View Related

Excel Hlep

Oct 31, 2005

I need to convert all these indidvual text files into either excel or access.
What should i do inorder for these text file to allocate to the right Field name in row once i click a import data from text file?
Any advise or example?

View 7 Replies View Related

Link Database To Excel With Autoupdate, Could Anyone Pls Hlep Me With This. Tnx

Sep 14, 2007

i need to link my db to my excel.
if i input data to my db then the data will appear also to my excel.
is it possible?

please help. i need it very badly.

thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved