Search results

Hello All, I have been using excel for sometime now and it does what I wanted to do but frankly I am tired of creating new tabs and editing fields every month as new tab gets created monthly and new sheet gets created yearly. so I have decided to move to access. In my humble opinion access...

Hello All, I have built a database for storing partnumber and serial numbers of various products. tbl1x main table tbl1xdetail subtable use for serial numbers tblparts for storing partnumbers On my main form I have fields like date, order number etc. On my subform I have partnumber as a...

Hello Experts, i have this small problem with my qry results not being displayed in the text box. tbl Issues= status field and many other fields tbl Status= Active or Closed here is my qry SELECT Count(Issues.Status) AS CountOfStatus FROM Issues GROUP BY Issues.Status HAVING...

Hi all, I have a database which is being used for storing name, order #, part number and serial to that part number. Name and Order Number is setup on the main form, part number and Serial Number is setup on the sub form. I have many users that use this database and I have recently noticed a...

I have two reports i run every so often in those reports i have a criteria set which asks me to type yearly, lifetime or three year and then after report prints out it also has total member quantity query on top of the page which counts whatever membertype i am typing it in, however right now...

Hi all, My database is a simple membership database that adds members and by clicking of a button it tells me the memebers birthdays for the month and if i chose to select the send card option then it remembers who has been send the card. All i want now is a query that will take a member...