I need to do an update to change all blank fields to a 0 (zero). In the criteria, I have tried IsNull and it is not returning any of the blank records. I...

I have a database that I want to share over my network (total of 9 computers on network). I split the database to have a FE and a BE. However, once split,...

I need to (very quickly) create a program that is user friendly that would be used by a small corner store to track sales/inventory/expenses/employees/etc. ...

I have a table with a Gross Sales field and a Total Costs field, there is a third field called Net Sales. How can I create a function to take Gross Sales...

http://find-stolen-laptops.com/wp-content/uploads/2010/03/never_know.jpg Use Snuko Anti-Theft Software to trace your lost or stolen laptop. It's easy to use,...

I am fairly new to Access and am designing a new database. I retreive all of the data from various Excel worksheets. I have 5 tables that I will update from...

2003 Access Database z:\\Jones\HomeFiles\household.be z:\\Jones\household.fe Users A and B have full access to both files and all folders. User A is using...

Hi, I need a table which will hold a user's answers to about 27 survey questions. Multiple users will use the database to enter responses for each question....

Office 2007, just upgraded from 2000 ( OMGOODNESS!! What a flippin' NIGHTMARE!!) I am simply trying to import a tab delimited text file into an existing...

Hello, I would like to ask advice on database / query design. I intend to create a salary calculator in Access 2007. In my plan there are different job...

Steve can you email me I really need a database created as well and will pay you the fee. Sheryl

Hi ! I am a beginner to databeses, and particulary to MS Access 2003. (althought I passed the first lessons) I want to make a small database with possibility...

Using Access 2003. I have a tblFamilies and a tblFamilyMembers. What do I do when I have a "family" where the Dad lives at a different address and is...

For an example, I have been using MS Northwind example. One problem I have run into is adding the same item twice in an order. I am keeping track of time in...

I have a runtime/accde app to be distributed to users that can't have access to the nav pane or objects, and even though I've disabled special keys,...

I am building an automotive shop database. I have a table that lists all of the services and the prices. I have the main form created where all of the...

Correct me if I misunderstood, but I read that one should index fields that are used as criteria in queries. With this in mind, when one does a caculated...

Hi, I am trying to create an access database that has historical data and new data is imported in monthly. I need it to be able to check each time if it's a...

Hi i want to change a filed called salary range property settings so that the currency does not show £ or $ in my reports but a local currency which will ...

hi may i know what the fields Entry Title and Entry number in the account transaction templates of microsoft does. i have downloaded it but am confuse to...