Search results for query: *

Not sure if this is the right forum... A friend of mine owns a business and he purchased a desktop software package with a local DB. Since then, he's paid regular support/upgrade costs. Now, he wants to make a switch to another software but when he called the existing vendor, they said that...

I am using DateAdd but causing problems when I change to another month. Any ideas on how to get this to work? I am looking to just find a way to add a day to a specific date, but for it to automatically go to the next month if necessary ... and I am stumped! updateDay (100...

When a user enters a form with basic controls (buttons, imagelist, frame...), the user gets this error: The error number is 339. "component '' or one of its dependencies not correctly registered. The file is missing or invalid" Frustrating that the component isn't specified. Any ideas?

I have a table called Billing that holds all a stores transactions. I use the following query to figure out totals based on each payment method (Cash, Visa, Debit, etc.). SELECT Sum(IIF(isnull(paid),0,paid) + IIF(isnull(provided),0,provided)) AS totalpaid, method AS typepaid FROM Billing GROUP...

I am allowing the users to select their start and finish times for their business for each day of the week. If I manually use a combo box and plug in the values with say a 5 minute interval, thats a BIG combo box. Are there any components that work similiar to a DTPicker? ... but for time?

I have a table with a field called pat_num for our patient numbers. Another field is called cost. I want a way to figure out the pat_num with the highest total cost. I guess I want to find the patient that has spent the most money. Any ideas?

We are using an ADODB.Connection to an access database. Is there a way that I can grab the number of connections or current sessions to that database? I have a compact/repair utility built into the software but I want to tell users what workstatations are still connected. Thanks.

I'm getting the following error: ActiveX component can't create object. Here's the code: strComputer = "." Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colProcessList = objWMIService.ExecQuery("SELECT * FROM...

I have a query with a few fields that I am creating. I want to order by on one of the fields that I create but I get an error asking for the order by as a parameter. SELECT IIF(Billing.invoice_num = -1,oInvoice & " (Payment)",Billing.invoice_num) AS newinvnum, Billing.method...

I have the following in my query... CCur(Avg(paid)) + CCur(Avg(provided)) AS avgvalue Sometimes paid or provided is null so it kills my avgvalue. Is there a way to wrap it to make it a 0 when its null?

I have a table called PatientList with a field called prim_key representing each patient. I also have a table called Recalls with a field called pat_num. Is there a query that will tell me what patients in PatientList do NOT have a recall associated with them?

I have a table called PatientList that has a field called frst_visit that indicates when someone becomes a customer. How could I return the total number of customers that dates are from the current year, one year previous and 2 years ago. So I am looking to return 3 values.

I'd like to find a way to get the date for the next Sunday from the current date. How would I go about this?

My same table filled with invoices, has a 'date' field. I'd like to figure out how many invoices I have that are between 30-44, 45-59, 60-89 and 90+ days in the past, but only where 'balance' does not equal 0. Anyone?

I have a query that reads a table to get my payment methods and return the number of purchases by payment type. But I have also have a field called 'paid' that I would like to get the average totals for each payment type. I'm not sure how to go about this... SELECT TOP 10 method, Count(*) AS...

I have a table called PatientList with a field called 'city'. I want to find the TOP 10 cities for all rows. Here's my code: SELECT TOP 10 city, newvar=Count(*) FROM PatientList GROUP BY city ORDER BY newvar ASC But I keep getting asked for a value for newvar. But newvar is supposed to be a...

I have a table with each row having a date field. I am trying to return the total number of rows from each day of the week. Mon Tues Wed Thurs Fri Sat Sun 44 45 3 45 23 2 34 I'd like to have something like the above to work with. Any ideas????