Search results

I have data set out in the below format: Jan Feb Mar … Stage A 4 5 2 Stage B 5 8 1 Stage C 3 6 4 Stage D 8 7 4 I am using this for a report and displaying it ‘as is’. I need the Stage’s to go vertically and the months to go horizontally (for space and presentation). My problem now is that...

Hi all ! Im having an annoying debate with my brother who knows very little about SQL. Anyhow what would you guys say the SQL query for the following would be: 'What is the first and last name of customer 405' The table is called 'CUSTOMER' and the respective columns are 'CUST_FIRST'...

The below Stored Procedure was refined to incorporate a UDF. My problem now is that I need it to be even more dynamic. I ideally need the user to have the option to select which fields are incorporated into the query. I have the front end framework although not sure currently how to make field...

Front End: MS Access Back End: SQL Server I currently have a client record database. The most important tables are the client and order tables which are joined via 'clientID'. I have built a search system which displays the results in a subform below the search criteria. The problem is that if...

Ive been pondering on this problem for far to long now so decided it was time to ask here ! I would like to return (based on a query) some records that would populate a report. I can set the source of the report as the query but my issue is that I need to actually have some code prior to report...

Hi Guys, Im writing a stored procedure with a couple of date inputs. It returns rows with dates that are equal to those inputs. My problem is that if I put a date such as: 15/12/2005 it overflows as it interprets it in US format (eg month 15...). If I add: 12/15/2005 everything works fine...

Just to start I have read numerous articles on numerous sites in regard to this and none seem to have helped me out... What I need is the ability to pass three multi value strings to a stored procedure. So it could be: String1 = Country1, Country2, Country3 String2 = Item1, Item2, Item3...

Hi, I have my report setup do that a Stored Procedure is added to the On_Open attribute of a report. Everything works find and there are three parameters: I have hardcoded three values in for simplicity although the problem occurs when I try to add more than one value to a parameter. I...

Backend: SQL Server Front End: MS Access Just a small problem with a stored procedure im trying to create: UPDATE tblOrders SET active = 1 WHERE (invNumber = 'Forms!frmMainsub1!oID') The above I believe is correct for updating all records to active with an invoice number...

I am need of urgent help with the following situation: Currently my project has been developed on my computer with frontend Access, backend SQL Server (on our companys server). Now that I am testing release as soon as I create the package and install it on any other computer it says that it...

I have recently made a database and through MS Development Tools have been able to bundle it with Access Runtime. We are using MSDE as a backend and when I install the 'package' created by MS Project on another computer it says that it cannot find the SQL Server database. This will mean (i...