Search results

Sum and Count for selective Counting of Records -- CountIF I found the following suggestion in another Thread: "Count gives a total count of all the records, which is what it is supposed to do. Sum gives a total count of all the records meeting the criteria, it Sums the result of the IIf...

Hi Bob, Thanks so much for the quick response. I tried your suggestion, but am still getting all 36 records. I should only be getting about 16 records. :( Any other thoughts? Gordon

I've read various posts, some of which indicate that the CountIF function does not exist, and some of which suggest using it. What I'm trying to do is to show the number of incidents in a report where the date in the field "Current Revision Date" is greater than a given date. Here are the...

Thanks Pat! I'll give that a try! Gordon

Like * & [Please enter address] & * RV, Thanks so much for the response. Your link took me to the thread where the format Like * & [Please enter address] & * was suggested. I already had tried that, but it was still not returning the desired results. The solution I found involved...

Hi, I'm trying to search a field which has both names and numbers in it. For purely text entries the wildcard search works just fine.... like this: Like "*" & [What is Last Name?] & "*" I can type in "Smi" and get all of the Smith, Smiths, etc. However, when I try to use this for entries...

DATEYEAR: DatePart("yyyy",[Date]) Thanks - I ended up using the syntax DATEYEAR: DatePart("yyyy",[Date]) and putting the parameter [What Year do you want?] in the criteria. This worked. Gordon

I'm trying to set up a parameter for a query which would allow the end user to type in a year, and have it show all occurances for the year. I've tried the following syntax, which does not work..... Like "*/*/&[what is year?] Any suggestions for the correct syntax on this? Thanks! Gordon

Time - Morning/Afternoon/Evening --- Thanks!!! The clarification is needed because a date/time field can't have 24:00 Try this:- IIf(IsNull([Time]),Null, IIf(Format([Time],"hh:nn:ss")<="12:00:00","Morning", IIf(Format([Time],"hh:nn:ss")<="18:00:00","Afternoon","Evening")))...

What is the data type of the [Time] field - a text field or a date/time field? The field in the underlying table is date/time. Format is "Short Time," and Input Mask is "00:00;0;_" Thanks for the help! Gordon

More on Time (Morning/Afternoon/Evening) for Crosstab Thanks so much for the suggestion. I tried putting morning_Afternoon: IIf([TIME]<=12,"Morning","Afternoon") into the field area, and I got the response of "Morning," for all of the times listed, except for one where there was no time...

I have created a query which gives me the date and time of events. Now I want to create a crosstab query which summarizes those events according to whether they occurred in the morning, afternoon or evening. This would be along the lines: 00:01 - 12:00 -- Morning 12:01 - 1800 - Afternoon 18:01...

I have the same problem. I'm taking an Access class, and asked the instructor the very question that you posted. He said that it is not possible to auto-size the form. Seems crazy in this networked world we live in. Hopefully someone has heard otherwise?

I have created a form which allows the entry (or should) of data into two tables, via a query. The tables are linked in a one to many relationship. I can view the existing data, but cannot add new records. I get an error message which states that "a related record is required in the Household...