Search results

Does anyone think I could do these IIF statements in a Public Function Module to evualate the corresponding fields in my Query? IIf([MON P/U] Is Not Null and [WEEKDAY]=2 and [TIME]="AM","AM",Null) IIf([TUE P/U] Is Not Null and [WEEKDAY]=3 and [TIME]="AM","AM",Null) IIf([WED P/U] Is Not Null...

ooohhhh! I get it now. I never knew what that Module selection used for. This may solve many of my other issues too! Kathie

Yep! Considering all the pick up and drop off times are in Access already. I'm sure I'll figure something out. I know it can do it cause it's fine when I put the IIF statements in for Monday through Wednesday. Gives me just what I need but it's too long when I get the Thursday and Friday in...

Didn't really that table wouldn't come in like I wanted it to. Attached is a screen capture of what I should geKathie

[MON P/U] is a time (the pick up time for a student in the AM) [MON D/O) is a time (the drop off time for a student in the PM) [WEEKDAY] the the numerical equivalent of the weekday (eg Monday=2 & Tuesday = 3) [TIME] is simply AM or PM I have a list of dates the kids can go but need to have...

Ok I have an IIF statement in the Field cell in the Query wizard in Access 2000 which works perfectly if I shorten it but if I put in all the criteria it's too long. What I'm wanting to do is this essentially If [MON P/U] is not null AND [WEEKDAY]=2 AND [TIME]=AM Then the field will =AM If...

Thanks for your answers. Of course now I can't remember where I was going with that. Doh!! One thing is these are all VBA code but I can't seem to get that from the Design view of a query. Am I missing something? Kathie

What I'm attempting is to put an expression in a query that will count the number of Fridays between two specified dates. Thanks Kathie

I figured out a method in playing around. I put in the query a count of the number of the specific days in the period (like there is 1 Monday but no Sundays in the period 8/1/11 through 8/6/11). Then I used if statements for each day of the week to calculate the date. Probably a simpler...

Ok, I have no clue if this is even possible. I'm creating an Access 2000 report to use to print timesheets for employees to fill out. I have a table with the pay periods and a table withe employee names. The report I currently have has that basic information but want I need to add is the...

Thanks, Guys!!! Ling's code worked perfectly. :):) Out of curiosity any way for that code to be modified slightly so that if the entered number in text22 that text26 would go up to the next division of 5. For example: I enter 5 into [text22] and then [text26] goes rounds up to 10...

Okay everything I've found doesn't seem to work. I have a textbox [text22] that has a number in it that I want rounded up to the nearest 5 in a different textbox [text26]. Example [text22] = 13 then [text26] = 15 I used the Ceiling function easily enough in Excel but now I want this in...

Hi all! I have a text box that calculates a child's age and another text box that states whether that child needs a carseat or booster seat. What I want is the text box for carseat to automatically calculate based on the number in the Age text box. Normally I use something like the below...

This is probably a real simple formula but what I want to is to have a query that each column is data for day of the week. Example Column 1 pulls anything that happened on a Monday for June 2011 would include anything on 6/6/11, 6/13/11, 6/20/11, and 6/27/11. Column 2 pulls anything that...

I have know idea even how to start this report in Access 2000. I just know it should be able to do it. Attached is an example for the month of May 2011. I have a table that lists the cost of each Run Name, another table linking the student with each run, and another table listing the...

I was putting that "Text135=[Driver #].Column(1)" in the main Property Dialogue box for After Update. Once I put it in the Code Builder it worked perefectly. It's not an issue on the names not updating. Even if a driver changes their name they don't usually driver that many of my students...

I've tried the after update link you gave me but it's still not working. I changed [Text135]'s row source: [Driver Name] on the [Student Data] table And I changed the [Driver #] combobox's After Update field to: Text135=[Driver #].Column(1) I keep getting an error saying Access can't...

OK, so I figured out how to get the [Driver Name] textbox to autofill with the correct name when the [Driver #] is selected in the dropdown box. Now I'm wondering if there is a way to save that autofilled value in the textbox to the [Student Data] table under the [Driver Name] field? The way...

Thanks! =comboboxname.column(x) This is what finally worked.

I'm very new to building forms and reports in Access 2000 and need some help with something I know should be easily accomplished. I have a combo box that I can select a [Driver #] from based on the the [Drivers] table. What I want is a text box to automatically populate with the [Last Name]...