I have about 10 years worth of data in a database, and i would like to only have 2 years. Is there a way to strip out the other 8 years of data and put it in...

I have MS Office 2007 and created a very simple basic database with dates and drop down lists and fields for names and addresses all in English, but we're...

Hello, I have this formula: =Abs(Sum(=1)*)/Abs(Sum(=1)*) in a text box in a report just showing a total for shift 1 thats on the report. I want to change it...

Hi I have created a transactions table in an inventory application. I have also created a DSum function that shows the quantity in stock on a form, by...

I want to make a form for a library where I scan in the book barcode and automatically it will show on some part of the form the name and author of the book...

I think the MS server ops should consider adding a binary group to these help forums so that a poster can upload a screenshot of what they are referring to for...

I am very much a newbie when it comes to databases but I have been given Microsoft Access 2003 and/or Microsoft SQL 2000 server to use to accomplish my task....

I have noticed that as soon as I run a query or a report in Access 2007 the name of the database I am working in disappears from the top of the screen and it...

i am a very small business owner. I have been using FileMaker pro but now that i have Office 2007 i would like to change to Access. at present i am manually...

Didn't know which area to post this so I chose here! :D I have a form in which there are 3 ComboBoxes, 1 Textbox and a CommandButton. Each ComboBox has items...

Anyone know why I'm getting this syntax error? Syntax error (missing operator) in query expression 'DateSerial(Year(Date(), Month(), Day()) AS Birthday FROM...

I am hoping that the much more experienced here can assist me to determine where I should go with my current usage of Excel. Some explanation of my system I...

I am building a database that will have: tblCustomers (PK CustID) tblPets (PK PetID 2ndKey CustID -- many pets may be owned by each customer) tblVisits (PK...

I have a form for data entry with a sub-form embedded in the main form. The main form has a combo box where you can select the vendor and then it...

I'm trying to teach myself Access, but so far its not going so great. I've created a database with a few tables in it. Now Im trying to make a form with...

I am making a strange database heres a quick summary There is a parts list linked to a list of who we get them from There is a module list which has a form...

Hi I guess I've reached the limit of my abilities with this... I've a form with a SQL statement which includes a dummy column I'd like to set in the "On Open"...

I have a combo box used to view specific customer records. I would like to add ALL to my Search By Date combo box as the default value. Below is my current...

I downloaded the "Order Entry" database from Microsoft web site and I am making the need changes to fit our company needs. How can I get a query,report or...

Hi All, Thanks so much to anyone who might be able and willing to help me:) Can i somehow pass data, from a form to a query, that represents the field...