Recent content by maxxev

Solved this SELECT T_SKUMaster.SKU_ID, T_SKUMaster.SKUCode, T_SKU_vs_LabelFormat.SKU_ID, T_SKU_vs_LabelFormat.ID, Count(*) AS RANK, "FORMAT0" & [Rank] & " TITLE" AS FormatTitle, T_Labels.Title, "FORMAT0" & [Rank] & " PATH" AS FormatPath, T_Labels.FileName FROM T_SKU_vs_LabelFormat AS B...

Hi, i've been working on something like this, I can't get it to work in my crosstab but in a standard query it works. Though I will point out that in my data ID is a unique value and from your data above i'm not sure you have a unique value in your data for this to work. But perhaps it will...

Hi, to clarify the alias'ed fields it cannot find are in the Sub-query of the first query. e.g. the fields in : T_SKU_vs_LabelFormat2 I get the message "The microsoft access database engine does not recognise '[T_SKU_vs_LabelFormat2].[ID]' as a valid field name or expression I know it will...

I had finished an indepth post on this before my PC crashed I don't have that much time anymore so hopefully this will be enough, please ask any questions and I will try anmd get back to you. I have a query that works fine, but when I try to put it into a cross-tab it tells me it can't find the...

I have sorted it out now me being daft (I left the comma off the end (there is another field below)). All working now. Thank you very much for the help.

Hi thank you for the suggestion, very similar to the code I tried before (exceopt I missed the ,1 from the when line). This brings up the following error: ODBC--Call failed [microsoft][ODBC SQL Server Driver][SQL Server]Incorrect Syntax near 'Table'. (#102)

Hi, we have a query running out of Navision into access, this query was setup by someone on site who is presently on holiday.... A shortcut was taken to fix one issue but it has caused another, so in his absence i'm trying to fix the problem. We have a field being cut down to 3 characters...

I would like to know how to fix the above still, but i've decided at this point that it would be a lot easier to just use unbound text boxes on the parent forms that work through sums on the sub-forms, then on the on-close event of the form, make the bound values = the unbound values. Cheers

Hi, thank you for the suggestion but that has made no difference. I have tested the code with a text box on the parent form with the following code: =[Forms]![SFLF_Benchmarking_Info].[SFLF_Benchmarking_Attendee_Scores]![SubAverage][ This takes a calculated unbound value from the subform...

Hi, I have a form with a sub form. The subform allows (up to) 4 entries with only one variable (Score). I want to total up the scores, divide it by the total number of scores recorded and then return the result to the parent form into a bound variable (Score). All of this works great.... with...

Sorry I forgot to say that I re-named the Query to Test In Access it does contain valid data, also in the Microsoft query screen it contains valid data, it just doesn't pull through to excel while the below code in access is functioning. CUSTOMER: Mid([Full_Product_Code]...

Hi, sorry it seems I was connecting via OLEDB in 2007.... but the query doesn't work either..code below SELECT TEST.Active, TEST.CUSTOMER, TEST.`Product Code`, TEST.Description, TEST.`Storage Condition`, TEST.`Dating Notes`, TEST.Shelflife, TEST.MinlifeintoDepot, TEST.MinOutloadLife...

Apostrophies even, sorry.

Hi, thank you for the suggestion still works in Access with the commas, made no difference to the issues with MS query though :(. CUSTOMER: Mid([Full_Product_Code] ,InStr([Full_Product_Code],'.')+1,InStr(4,[Full_Product_Code],'.')-InStr([Full_Product_Code],'.')-1)