Search results

In the query i dont currently have a column for year and week-this is in a seperate table named:dbo_@CALENDER and the screenshot is just from that table. I was just thiking of making use of the calender table to determine the correct year and week in comparison to the complaint entry date. The...

Hi David, thanks for your reply. I'm looking at the database and document in the link you provided but at the moment I cant think how i could do something similar to allow the user to enter a year and week rather than a date from and date to range

Hi, I have an access query that looks at a table named DATA-COMPLAINTS which has complaints data. One of the fields on the DATA-COMPLAINTS table is named: CC_ENTRY_DATE which is the date each complaint record was entered in the format mm/dd/yy What I would like to be able to do is prompt the...

Peterf: Your solution worked fine, many thanks for that :)

I can supply more information if you let me know what would help. Do you mean sample screenshots of the query results?, or the SQL code?

I tried this: YEAR: Val("20" & Mid([YEAR_PERIOD],1,2)) and i got 2010, but for some of the other years i got some strange dates such as : 2071 - think this is meant to be 2007 2081 - think this is meant to be 2008

Ok gemma, i'll try your suggestions now.

Ok thats sounds like a good option, do you mean something such as IF year is <=2009 then YEAR: Val("200"+Mid([YEAR_PERIOD],1,1)) else YEAR: Val("20"+Mid([YEAR_PERIOD],1,2)) and if period <=2009 Mid([YEAR_PERIOD],1,1) else Mid([YEAR_PERIOD],1,2) hm not sure how to put this into a working...

Hi, ok thanks 2010 dates seem to be showing now but not any years before, any ideas?

Hi, We have a query within a Microsoft Access 2003 database that looks at some data within Oracle tables including a period field and a year field that reference a field in an oracle table named: YEAR_PERIOD. The query has been working fine up until this year. It doesn’t want to display any...

Ok, its working fine now, thank you all for you help on this :) Brianwarnock: i added the missing brackets. (sorry about liitle late reply, thought id already replied)

Brian - ok I tried the SQL code you suggested but when running the query i get an aggregate function error message (please see attached screenshot) any ideas why this could be? All records have an entry in the description field.

Ok, SQL code below, if possible the user can enter a date range so that for example: from 01/12/09 to 16/01/10 (DD/MM/YY format) can be entered, ive just put "Please enter a date" for now to test. if that works i guess the date range should work. i guess i should of been more clearer what i was...

I think its ok now thanks, although it wont allow me to specify entering a date as well as a product code, as it says the query is to complex when running

I dont need CC_REF sorry ive now removed this from the query" CC_ENTRY_DATE" is needed because as i want to display the date, and possible at some point allow the user to enter a partcode then a date range.

Ok sorry, think ive got the design of the query ok now as suggested however if i do that and run the query, the results just show the number 1 on every row for the count column. See new attached screenshot

Do you mean like this (please see attached) it come up with a message when i run the query

Hi i tried doing what you suggested but now when i run the query no results are displayed. see attached screenshot of the query design view. Is this correct?

Hi, I would like to be able to count the number of complaints in a query by counting the number of times a product code appears for each complaint description but not sure how. So when the user starts the Query it promts to: "Enter a partcode" so if the user enters "2358NXA" the results then...

i tried grouping all the fileds aprat from the part code field which i set to count and in the query results it just shows: 1 for all the count of part code records.