I need to clear about 200,000 checkmarks in my database, does anyone know how I can do this? I have tried REPLACE with (-1 with 0) and (Yes with No) but...

I'm trying to store a 1 or 0 in the field but don't seem to understand how. I made a filler feedback linked table with input form. I'm want to grade several...

What I've got; An excel spread sheet that contains all employee travel criteria, with the headings: - Travelers; Travel Date(s); Cost Centre; Division;...

Hello, I have been challenged with making a yes/no field either stay on or off based and contract end date field in my table. I am using Access 2003. So for...

G'day ppl What do think is the best way to setup/structure a work/task scheduler. Eg, if Mr. Smith wants his grass cut on Wednesday of every week, Mrs....

I know how to extract the year from a date field in a form or query using the Year function. But how would I do that in a table? I need to keep the year as a...

Hello, I could use a bit of help in this. While it seems simple, maybe it is not the correct way. In a new table, I want to have a field for the YEAR. ...

Hello, I have table that stores a "year" value. Is it better to have this field's data type as a Text or Number value. There is no dates, just a year...

I want to have a field that simply allows for the year, with no month or day. I can't figure out how make the field a Date data type. Basically, I've made a...

Say my table as Date, Year, Month fields and a user form has a Date Textbox with Cs set to Date in table Is there a way for the table to add the year and...

I have an old database file in DBF format that I use Microsoft Access to display. The dates in the DBF file only has 2 digits, so when it's opened under...

I already have a form that displays the basic necessary information about a product (ProdID, ProdName, ProdCode, UnitPrice etc) but what I want to have is a...

XP Home US$19, Pro US$29 Vista US$29 Up MS Office US$49 Up

My XP Professional Home Edition doesn't have Front Page for SP3 installation!! I've gotten Microsoft Office XP Professional Service Pack 3 CD-rom for...

I have two tables, one is PaymentMethod and other is PurchaseOrderDetails. In the PaymentMethods table I have the following fields & data PaymentTypeID ...

As an untrained user of Access, I have foolishly created a simple database using the date format dd/mm/yyyy (text). I now need to extract records within...

I have a textbox that perform some calculation, at the control source i wrote a statmen for calculating the value in this textbox = - and it works now i...

When our net work does down and am in processing of completing a report when I finish i get a disk error message. Consequently I cannot save my report. I read...

=DCount("OrderID";"" Between " " And ""='" & Forms!""Between"ÙŽ"And"""') Hi every body, this expression is written in the form to count orders between 2 dates...

I am trying to write an IIf statement to use in a calculation where if PT1 is zero it will use PC1 to determine the value. Here is the state I have tired but...