Search results

Hi Is it possible to retrieve the format of a field when looping through recordset. e.g you can get the field type by using But the type for decimal or percentage is the same. It is the format that is different I need to be able to see what is formatted as a percentage and what is...

Hi The calculated field is just a simple Thanks

Hi Is it possible to add/edit a record from a DAO querydef that has a calculated field in. Set qdf = db.QueryDefs("qryOutput_" & strDept) qdf.Parameters("Enter Date") = dDate Set rs = qdf.OpenRecordset() Using the rs.Edit or rs.AddNew worked fine until I put a calculated field in the...

[SOLVED] Re: DLookup - Not exact match I've sorted this now. I had to remove the join from the entitilement table, this then listed a record for each of the entitlement above the yrs service. I then had to use the Max on the days. SQL SELECT qryEmployees.EIN, qryEmployees.Fullname...

Hi I'm having trouble with something that I though would be simple (and it probably is). I have a query that displays a persons years service I then want to look up their entitlemet based on the years service. The entitlement table is... 0 yrs - 30 days 3 yrs - 31 days 5 yrs - 32 days...

Hi all Can anyone tell me if what I'm trying to do is possible! I'm sure its got to be something with the multiple left Joins but every time I create them it will show the records from Q1 and then only show the rest of the records for the Q's where there is a value in the Q1. Thanks in advance...

Hi That won't work for my data, they are not questions and there is one record per person. The Q's are 15min intervals throughout the day and the code is the task. I think I need something like the sample in this link but I can't apply it to my data...

All I have attached a small sample to explain what I am trying to do... Basically, I have a table with lots of Fields, Q1, Q2, Q3, Q4, Q5, Q6 and so on. There are various codes in those fields. All I want to do is then have a query with a count of each individual code. The only way I can...

Thanks again for detailed explanation and advice on a few things. Yeah, I just looked at the design view - I would have expected it to look different?!? This bit I did know, lol. Don't know why I use rs("Field"), just habit is I suppose. _____ Not that I need it at present, but is there any...

:D Thank you. That is spot on.:D :confused:aQuery1 and aQueryWithSub are the same! Not that it matters, it works. The order does matter, but there are other columns that relate to the order which I took out to keep it simple. I can sort it back in required order afterwards. I was just about...

Hi I get what your saying in terms of Excel handling data differently but I don't see how my my table can change to solve my problem. Can you suggest any changes or provide and example. If you have a look at my sample you will see what I mean. I have only put in two columns to keep it as...

Hi all I have been searching for a solution to this but can't find anything. This thread is the closest I have found but I need advice on how to build the arrays, if that is the way to do it. http://www.access-programmers.co.uk/forums/showthread.php?t=188959&highlight=sumproduct Anyway...

Hi Ahh, see what you mean now. Didn't think of the 2 reports combined, not done that before, just found other ways around it. Will definately change to your solution. Thanks again..:D

Hi Yeah, poor explanation on my part around the tripling part. I just meant that is was counting the same check multiple time dependant upon how many errors there were. I don't see how your solution will fit my purpose. If I use the distinct method how will I still be able to show all the...

Hi Thanks for the replies. I have only selected the data i require for the report but the problem with the grouping is that it can't group the data as the rows are not identical. The only thing I can think is that I have set up my tables wrong. I have got it working now by creating the...

I think I have solved this In the day footer I have this DSum in the text box. I had to use the ' to get it to work. =DSum("UnitsChecked","qryTotals","[DayName]='" & [DayName] & "'") in the week footer I use =DSum("UnitsChecked","qryTotals","[Week]=" & [Week]) Still please post if...

I thought one way around this my be to use DSUM and create a query just with the daily sums I tried the following but it just comes up with an #error =DSum("[UnitsChecked]","qtyTotals","DayName=" & [DayName]) Any ideas people..

I'll try and explain this the best I can... Basically I want to stop access counting the same record multiple times I have two tables checks and errors. A check can have several error types check units errors rate reason ID1 10 2 20% overs ID1 10 1...

Hi all Well, I'm glad I started this thread now, really starting to understand why and how dates are used so thank you all for your input, and once again for a couple more alternative solutions. Thanks ChrisO for the explanation around the mm\/dd\/yyyy. Gemma I meant that a...

Hi all JanR, Thanks for your simple explanation around why different formats are required. Makes sense. :) Gemma, that was the most annoying part. I was like, if its US format or UK format then fine, but don't change you mind half way through. lol Thanks for everyone's input in this. Like...