Search results

Ok, is there a better method that you would suggest doing intead of using Dsum?

ok "create a new query and include the oracle table. Bring down the prod code field and group by this then sum the value field and see what happens." This works ok - lots of records are displayed with all the diffrent part codes "If ok then apply a filter based on the 23 field and see what...

i tried adding: Is Not Null into the criteria under the 23PARTCODETOTAL: field but when running the query no results are displayed. EXT-STK_PARTS is the name of the oracle table

When i try to run the query i get the attached error message i then click ok and no results are shown in the 23PARTCODETOTAL field. The rest of the query works fine and data is shown in the other fields. The query is looking at 1 linked oracle table and 2 access tables. THe partcode number is...

hello, im trying to find out the total number of times a particular record (one with a particular partcode called 2358NXA) appears in a query. Ive tried the following: 23PARTCODETOTAL: DSum("[STK_PART_CODE]","EXT-STK_PARTS","[STK_PART_CODE]= '2358NXA'") but this doesnt seem to work Anyone have...

Ok thats great it seems to be working fine now using bob's code and calling the function from the query, after looking more closely one of the issues causing the #Error on some records was as bob suggested: the End date is < start date on some records. Thanks a lot for everyones comments on...

ok i tried the following code in the criteria of the query: Numdays: DateDiffExclude([CC_ACK_PRINTED_DATE],[CC_LETTER_PRINTED_DATE],17) but for a lot of the record results it says: #Error any suggestions on how to fix this?

raskew - thanks for the post but Please can you clarify what you mean? so copy that code into a new module then save it and call it from where?

Ok thanks for the link David, that table looks helpful although i'm not to sure at present how to make use of this in the query. i guess i need to reference the weekend dates in the table to see of any of the dates in my query include weekend days

i tried changing d to w as below, but it doesnt seem to calculate correctly DATEDIFFERNCE: DateDiff("w",[CC_ACK_PRINTED_DATE],[CC_LETTER_PRINTED_DATE]) for example CC_ACK_PRINTED_DATE = 23/07/09 and CC_LETTER_PRINTED_DATE = 31/07/09 and DATEDIFFERNCE says: 1...maybe its calculating the number...

Hi, i have the following criteria in a query to calculate the difference in days between two date fields, however i would like to not include any saturdays and sundays in the calculation. DATEDIFFERNCE: DateDiff("d",[CC_ACK_PRINTED_DATE],[CC_LETTER_PRINTED_DATE]) Is this possible?

do you mean instead of one of the querys having this criteria: >=DateAdd("d",-14,Date()) and <DateAdd("d",-7,Date()) i remove this so that its looking at all purchase orders and products?

Hm sounds tricky, do you know if it poosible to look at the most recent occurance of a product appearing in the most recent purchase order during week1 (or the last 7 days) with the most recent occurance of a product appearing in a the most recent purchase order during week2. I could then run...

ok ive joined to queries by product code, and i've found that the problem in the report was a field was listed in the sorting and grouping but was looking at the wrong field :o report works fine now. :) but I've found one potential issue :confused:...if multiple orders are created in the last...

Ok the query seems to work ok now thanks that compares the other 2 queries, the only issue is when i try to create a report based on the query it says: "The specified field '[PURCHASE ORDER]' could refer to more than one table listed in the FROM clause of your SQL." this issue happens for any...

hm ok, ive created the first two querys by having >=DateAdd("d",-7,Date()) and >=DateAdd("d",-14,Date()) in the POP_DATE_ITEM_RECEIVED field but im not sure how to comare the COM_DATA_VALUE filed (this filed contains the manufactured site). Ive tried doing an unmatched query but this doesnt...

Please can you clarify what needs to be done?, do you mean have 2 querys. first query: looks at the last 7 days second query: looks at the last 14 days and then do a new query of a comparison of the two queries?.

Hi, I have a query in Microsoft Access 2003 named: "QRYPRODUCT_MANUFACTURING_SITES", this query looks at another query which in turns looks at 3 oracle tables. What I would like to do is do a weekly comparison of the manufacturing site for all products from the most recent purchase order(s)...

Thanks, Item Code: Right(trim([EXT-COM_EXTRA_DATA_FIELDS].[COM_DATA_KEY]),3) did the trick fine :)

No I dont believe so, unless there is some blank data at the end but i cant actually see them within access. The table the query looks at is an Oracle table (which i cant modify)