Recent content by Phil_b

hi guys any help with this or suggested area to focus my attention?

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...

lol. Just to clarify my brother came to me for help and I explained that the question is asking for you to return two columns (first and last name). If it was asking for the ID as well it would ask you to list the ID. This is such simple SQL I cant even believe im debating it here but a third...

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...

after the best part of 2 days this is how I did it: I setup a stored procedure with one parameter (my invoice number) and set this as the record source of a dropdown box whenever a user searched for 'Invoice Number'. (I had to do this via VBA so i could add my invoice number parameter). The...

how are you building the expression? Is it from a dropdown list? If so check that the bound column is correct. If not then its probably (as above) just adding the field to your query.

Currently my search system allows for searching in any field in the client table. Instead of going to an individual order it was decided to go to a 'selection' based on a filter. For company name: I then build up the string and add it as a filter. Thats no problem but searching and filtering by...

hi wazz, I have a form with controls from tblClients. I have a subform on that control which is linked to the clientid. It hence shows all invoices for the client. Hence my query for the frmClients has no joins but just pulls information from tblClients. This is fine and allows me to search...

thanks for the response guys. I didnt want to give too much in my first post as I thought it might over complicate. My main form shows all Clients (one record per client) with a subform showing invoices specific to that Client. Everything works fine apart from when I want to search. I can...

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...

thanks Kodo !!! For some reason when I put the SQL statement into a variable and then run it the error occured... Really glad to have seen the back of this ! Hopefully soon SQL server will add an array datatype...

thanks for the reply Fofa. I tried them all (literally) and am no better off. I infact went onto another part of the project but now am coming back to it. Whatever I do I cant pass a csv string to the IN part of an SQL statement... all i get currently is: "is not a recognized optimizer lock...

any help with this? If there is an alternative way of passing multiple values to a parameter I would be willing to change my approach. Phil

thanks, that worked fine although now I get this error: "is not a recognized optimizer lock hints option" All i want to do with this is pass a CSV list to my stored procedure but it seems to be turning into a nightmare. I looked up the following error and it said about changing my SQL server...