I'm asking for suggestions on how to do the following: I need to design a form(s) to input who will attend meals (B/L/D) each day.
This is for a group of individuals, some of whom are assigned to a facility. Most of the individuals assigned to the facility attend all meals, but it is possible...
I help a company currently using Access to manage day-to-day activities of their site. They have historically maintained a network server and the database (back end) lives here. They are considering "going to the cloud" so as not to have to maintain this network server. Not completely sure...
I'm trying to create a crosstab query with multiple values and need some help.
I have two crosstab queries (SM and RM) with the following fields:
[Meal], [MealLocation],[Date1],[Date2]...[Date7]
The value in the queries for each date is the sum of RMMealCount (in crosstab query RM) and sum...
When you group by a field and you put a textbox in the group's header with the value =sum([somenumericfield]), shouldn't it result in the sum of [somenumericfield] for that group only?
I'm doing that and getting some inconsistent results.
Thank you!
Is it possible to group based on a value?
I have a list of individuals who are either "commuters" or not based on a room number. I want to display the "commuters" on this list followed by the "non-commuters." I've created a query behind the report and one field is "commuter" into which I've...
I have a report where I am trying to use the DSum() function as the control source for a text box and am getting the error #Name? I can't figure out where the problem is and need some help.:banghead:
The table I'm querying is tblTEMPMealCount:
MealDate (date)
BreakfastRM (integer)...
I have a table that I want to query for a report but need to do some calculations in the query.
My table has:
Date (date)
Location (text)
Breakfast (numeric)
Details (text)
Essentially, if the field [Details] has something in it, that means this is a "special meal" and I need to count it...
I need help in creating a loop through a recordset.
I have data containing information about event meals. Each event has a start date, end date, first meal, first meal date, last meal and last meal date. I need to loop through the data and create a record in a table for each date that a meal...
I have a [StartDate] and[EndDate] and I want to select any records that fall between these two dates. If I select [StartDate] >= date1 and [EndDate] <= date2, I don't get the records that have a start date BEFORE the date1 but occurred during this date range.
How do I write the query for this...
I'm trying to set the control source of a textbox on a form with the following:
=IIf(DLookUp("[Room]","tblTEMPEventRooms","WHERE #" & Me.DateOccupied & "# BETWEEN [StartDate] and [EndDate]) AND [StartDateTime] =8")=122,1,0)
But it gives #Error. Is it the quotation marks?
[DateOccupied} is a...
I have four fields in my table: [Tables] (integer), [Chairs] (integer], [TheatreStyle] (yes/no), [ClassroomStyle] (yes/no) and some may be null.
Is it possible to nest these together using IIf in my query to display as follows: [Tables] Tables, [Chairs] Chairs, ([TheatreStyle] or...
I'm getting a type mismatch error when trying to open a form:
Dim stDocName As String
stDocName = "frmReservations"
DoCmd.OpenForm stDocName, acNormal, , , "[RNOS] = " & 4730
The field [RNOS] is a long integer.
What am I doing wrong?
Thank you
Can I display the weekday in a label on a report? If so, how?
The record source for the report has a variable "StartDate" and I want to show the day of the week (Monday, Tuesday, etc) of this date in a label.
Thanks much
I'm trying to add onto the open report command but having problems.
I'm using the filter on a form to populate labels
DoCmd.OpenReport "Labels_Contacts", acViewPreview, , Me.Filter & "and [Mail] = 'Yes'"
and Access doesn't like this.
I'm getting a 3075 error "Syntax error (missing operator)...
Is it possible to capture a form's filter? In Access 2013, I have a form (from a template database) listing contact information. I can set filters by clicking on the column headers and selecting which records I want displayed. There is also a button to run a mail merge with Word. I want the...
I'm trying to modify a MS template that has the following code:
OnError Next
RunCommand SaveRecord
MsgBox =[MacroError].[Description],Yes, None,
StopMacro
OnError Fail,
OpenForm Contact Calls Details, Form, , "[ID]=" &...
I have two forms:
(1) List of names
(2) List of events
A person is added to an event on form2 using a combo box with a row source being a select statement from the table of people.
When the user wants to add a person to an event, and that person does not yet exist in the table of people, the...