Recent content by crispbreeze19

crude way I am ok with queries. So here is a crude way of doing it. Subtract the date field that you have from Date() and then put in the criteria field <=365 for a year and then for month-to-date <=30 and the week-to-date <=7. For the month-to-date, since months vary in length, a Like state...

Still getting errors I tweeked your SQL statement and formed into this. can tell me what I am doing wrong SELECT Scan_Date_Table.DS, Scan_Date_Table.DSS, DCount("dayid","noweekend","(((noweekend.noweekday)=1) AND ((noweekend.dayid)>=Weekday(Scan_Date_Table.DSS) And...

Here is the SQL that A2K gives me for the query that has the actions I want it to perform. But I can't get it to give me a count of the number of records returned. I would love to use DCOUNT but I am having a tough time working it out. Also in the final soultion, the numbers 2 and 23 are fields...

i have attached a sample database. Now I want another field in the query to count the number of 1s and 7s in the field noweekend between specific row numbers. The first and last row numbers are defined by the expr1 field and "expr1 + turnaround time" fields Example turnaround time equals 4...

The fields are only numbers but I want to count the 1s and 7s between record # blah blah and blah blah with blah blah being set to field3 and field4 respectively. Example Table1 Field1 Field2 Field3 2 4 Table 2 Field4 the first column is the record number...

I have a 2 tables and 4 fields that I want to work with. where it is Table A with Field1, Field2 and Field3 Table B with Field4 I want Field1 to be equal to the number of 1s plus the number 7s. Here is the doosy! but I only want to count the 1s and 7s in Field4 between the record number...

I have two tables, 4 fields A, B C and D. I want to set the D value to the number of 1s plus the number 7s that are between A and B on field C D= the # 1s and 7s between the row numbers FieldA and FieldB in FieldC I know a little VBA and macro stuff but not too too much

Kinda sorta but not reallly. I don't know how to start the code but i have a pretty good idea what i think it should look like but don't know how to implement it. IF LEFT(Form1.Title.Value, 2) = "A " Then MID(Form1.Title.Value, 3) & ", A" = Form1.Title.Value ELSEIF LEFT(Form1.Title.Value, 3)...

I have a form named form1. In the form I have a field called title. I would like to know how to call this into VBA code. is it Forms!Form1![title]? So if the title field was equal to The Hundred Years War, then LEFT(Forms!Forms![title], 5) would be equal to "The H".

Hey peeps, I have a problem. I want my field to become "[field], An " etc. when I type "An [field]" For example, if I type "The Hundred Years War" for the field, it automatically updates to "Hundred Years War, The". I would be happy with a simple validation rule that prohibits the use of...