Recent content by ad.business

Where is the post you are referring to?

Is it possible to navigate to a cold fusion page that has a datepicker jquery calendar to pull a report. Here is my scenario: I navigate to a web page every day that has a popup calendar and a push button to "Pull the report" The report loads a CFM with the results for that days report. Could I...

Thanks for the reply, however, I am not looking to update it...I just want it in the same query but to count the number of times the names above appear in the query, starting with 0.

Make a new table, call it tblDaySort, in the design view, make the first field called Days, data type of text and a 2nd field called DayNumber, data type number, (long integer). Save it and do not put an autonumber when it asks. Then open the table in datasheet view and populate it with the...

I have a field called Name and another field called Audits. I would like to count the number of audits based on the Name field. I would like it to start at 0 and increment with each one. I am looking for something efficient as there are thousands of records. Would it be dcount? I attached an...

Hello, I need help with the following: I have a table called tblStats, with the following fields -Date (mm/dd/yyyy) -Month (mmmm) -Name -Sales % to goal (updated via update query) I built a select query for each month for the last 6 months and then a main query to view the last 6 months of...

I have a table with the following fields, month, name, and % to goal (sales). I am trying to start a certification program for their sales. Anyone who gets at least 80% to goal for 6 months in a row will receive a title of "Intermediate" and will get a 10% increase for that months check...

I have a table with the following fields, month, name, and % to goal (sales). I am trying to start a certification program for their sales. Anyone who gets at least 80% to goal for 6 months in a row will receive a title of "Intermediate" and will get a 10% increase for that months check...