Search results

Thanks Sohaila, But, I need to calculate the total Yeses (Trues) for Gender = 1 (Male) and also Gender = 2 (female) for each of the check boxes. tx Simon

I'm trying to count the number of records in a query, I've got two fields to compare: gender and a yes/no field. In other NONE Yes/No Fields calculation I'm using =(DCount("*","qryName","[Gender]=1 And [OtherFieldValue] = 1")) and this returns the number of records with the Gender Value of 1...

No new info on this, other than to say I've used the Litwin, Getz & Gilbert Re-size code quite a few times, it works realy well, though sometimes you have to be careful putting fields or objects close to the edge of a form. The book has lots of other good code examples as well, it's worth the...

Thanks for this, it was the DCount part that I was struggling with (I'm fine on using query parameters driven by forms and the Me. syntax). I'll try this later today! Cheers. [This message has been edited by CutAndPaste (edited 08-01-2001).]

I've created an append and delete query combination to move records between 2 dates to an archive database. I've also got a message box that pops up prior to this query executing to ask for confirmation from the user before this action is carried out. I'd like to include more information in...

I've got several groups of fields, all in the same table where the responder can tick check boxes with yes/no answers e.g. Type - Fruit (tick the ones you like) x Oranges x Apples x Pears Each Fruit type is a seperate field and they are only grouped into "Fruits" for ease of use for us humans...

I have a requirement to allow users to custom "label" 10 fields. I've created a mini table where they can enter their Custom names for Field1 to Field10. I've then put unbound fields next to each of the Fields on my form and used DLookUp to reference the Custom Name of the Field1 and so on...

Drew, Worked like a dream, I was giggling away with glee as this function created lots of info for my test data tables! Saved me loads of typing!!!!! Thanks, Simon

I've got to create some reports showing simple Cross Tab results that calculate numbers and percentages of a various fieldsCross Tabbed against their Gender. I thought I'd create just one Report template and set the datasource of the report to the required query by referencing the query name in...

Not quite so easy as I thought... Ok I've specified the Start and End Dates in the Query parameters and even got the sum of male and females calculated in the Cross Tab query. More importantly I can limit the output of the query by having the VisitDate field reference the start & end dates...

Pat, Worked a treat, many thanks!

KdG, Thanks for the reply, though I'm still scratching my head as to where I enter the [StartDate] and [EndDate] to limit the range of the random dates. In most cases when I want to run this function the dates would be fixed so can be hard coded rather than entered from a form etc. From which...

I'm adding the total minutes spent on an activity and want to convert the results to hours and minutes for a report so that a total of 45 minutes becomes "45 minutes" and 75 minutes becomes "1 hour and 15 minutes" etc. etc. Anyone know of a code snippet / function to do this? Thanks.

I have a query that calculates Clients Ages in whole years. I want to be able to group my query output into a report grouped by age bands, say <16,16-20,21-30, >31 etc. and then be able to use the results of this in other groupings e.g. Gender by Age Band, or Favourite Fruit etc. How can I...

When all else fails I find using the inbuilt help system invaluable... :-) Text Cut from Access Help File... The specified name isn't a recognized field name or a valid expression. In a query, this error can occur if you enter a name that improperly refers to a database, table, or field...

Carol, Tried this and it didn't work until I actually re-read your post, then it worked first time. As I'm using look up tables for the main data I then pulled in the "English" Field Values and I got my report looking realyl good. However, I can make this work from my main table but when I...

Thanks, I can follow the first part of the function but I'm not sure where the 2nd sub comes in? can you explain it a little more? Do I need to call both functions? When? Thanks! It may be an inelegant way of populating these records with random values but I'm calling my random number...

Sometimes I need to copy some values from a current record into a new record. I know i can duplicate the record but this copies everything. Also I want ot be able to visually flag that we are now in the new record and that te user has to fill in fields x,y, & z to complete the new reocrd as it...

I often need to generate random numbers within a given range to populate a table with test info. I've managed this fine with numbers in a function using something like: Me.Field1 = Int((8 * Rnd()) + 1)'Generates random value between 1 and 8 However I can't seem to do this with dates. I need...

I have a table that lists various information about the Clients at a Charity Advice Service. I'm aiming to produce (amongst others) a report that details the breakdown of Clients by male and female in particular categories in a chosen field (for example as in Employment below). My Report needs...