Search results

I have a crosstab report with three columns: Name C W Total Paul 2 2 4 Jane 5 6 11 John 15 I would like to add a column that sums the values for each name (Total) - as shown above. For instance...

Hello, I have a report which is based on crosstab query. One of the fields in the query is "date" current range is "Between #7/1/2007# And #7/1/2008#" Dates are not part of the column or row headings. The date field is there just to limit the range of data which is chosen. I would like...

Hello, I would like to create a text box which automatically prints the name of the report in the report. This is the report name as shown in Access, in the reports area (example rpt_monthly_sales). I don't just want to type the name in, since I may change the report name at a later date, and...

I have a text box in the page header for a report. I want to apply conditional formatting to whenever the word "overdue" comes up in that text box. If I type in the full text for one possible variation, then it works for that variation (i.e. "Overdue from Author). However, I want to have it...

I have two tables which I pull records from. One table has a list of sections. The other table is a list of chapters. One chapter has many sections. I have the sections table populated, and want to show all of the sections, even if they are not currently assigned to a chapter. Currently...

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...

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...

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

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 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...