Age Calculations Help DEADLINE TODAY

Jun 20, 2006

This is probably an easy criteria but I'm getting close to COB and I have to have it in today.

I have a DOB as (DD Mon YY 04 Jul 79) in which I need to create a column for thier age. Then I have to show all the people who are over 60 years old. I can't even get thier age to show correct. Any help. Thanks

View Replies


ADVERTISEMENT

Calculations Deadline Approaching Soon

Sep 21, 2005

Deadline approaching soon… HELP!!

I have three fields

Life Skills Credits Earned Total

I need to enter a number in the Life Skills Credits. The Earned field should continue to add what I enter in the Life Skills Credits, but I need the life Skills Credits to revert back to 0 (zero)

I hope I explain this right…..

View 4 Replies View Related

Today Or Before Today Date Criteria

Feb 23, 2007

what do you put in the criteria in a date field to show records with a date = to today or less?

View 3 Replies View Related

Calculations On Main Form Do Not Reflect Calculations On Subform

Sep 28, 2015

I have solved the problems getting values on the subform. I have not in getting values on the subform.For instance, on the one titled phone use the formula in the tutorial is:

=[sbfCustomerRoomUse].[Form]![txtTotalPhoneUse]

#Error results when the doc is put into a form mode.

Now when I input each value in the equation above separately.I still get no entry.

For " = sbfCustomerRoomUse" , I get #Error;
and for "= txtTotalPhoneUse", I get #Name.

CustomerRoomUse and txtTotalPhoneuse are from the subform that was dropped into the customer form in a previous step. It shows that explicitly when designed sbfCustomerRoomUse on the main that CustomerRoomUse come from a subform. This does not seem to need to be done with txtTotalPhoneuse, and I am not sure why. Neither one gives me a desired calculation result.

View 14 Replies View Related

Very Urgent: Deadline Very Near, Help, Help, Help

Dec 20, 2007

Hi All

Please, please help as I’ve got a really urgent project to complete. If I don’t get it finished I’ll be out in the cold. I’m really struggling for time myself so I hope people here can help. Here’s the rub:

I got a list of recipients (names & addresses) each requiring a list of items (we have all the lists currently on bits of paper). The number of addresses and hence the number of lists runs into the millions so I need a big database. Will Access be able to do this?

We have all the stock in our warehouse in stock ready to pick. We use to hand make the stuff but now we just buy it in. So at some point I’m going to need a buying schedule (future development).

Contrary to popular belief we the deliveries to the recipients are over several deliveries (not one). What I need is a database that allows me to produce a schedule of which go on which delivery (essentially I do this by postcode/zip code). I need the schedule so the pickers know how to assemble each load. Also there’s a claus in the contract that say we have to have a delivery schedule for the guy doing the deliveries (the same guy – my boss – does all the deliveries). His missus is funny, she keeps saying to him “Look out for the rain dear”. Thankfully we never have to deal with returns so no issues there.

I there also a way to monitor which picker picks what because in the past some of them have been a bit crap and they should give themselves a kick up the backside.

I also need to produce a run of labels so that I can stick a label on each item saying give the name of who the item is for. Is this possible? It’s now joke having to write them all by hand.

One more thing. Some of the delivery points have been known to leave gifts when the delivery is made. We use to just accept the gifts and say nothing about it but now we need to record this as the tax man says because of the sheer number of gifts then this becomes benefit in kind and has to be declared. Thankfully the company vehicle is except from tax (at least for now).

I can’t offer any money for this. We’re a kind of charity. My deadline is 4½ days and counting. I really hope yule all help with this because it’s really important and if it’s not done I’ll lose my job.

I haven’t got very far with this and I really haven’t got time to do it myself. If someone could send a sample database of how I should start, that would be great.

Chris Stapphamy

View 14 Replies View Related

Deadline And I Need Some Assistance Please

Aug 10, 2005

I created a form using a text boxes by using the field list icon and dragging the field I wanted to make into the text box onto the form. In the properties of that text box, under the format tab I set the format for "short date". Under the data tab in the properties of the text box I put in the control source this forumla =DateSerial(Year([Date of Service]),Month([Date of Service])+10,Day([Date of Service])). "Date of Service" on my form is the name of the source field it calculates from. What the forumla does is calculates from the date entered into my Service Date field and whatever date is in that field it adds 10 months to it. This field with this formula in it caluclates the date of my contacting the customer to setup an annual service for them. I also have another field that calculates the annual service date using the same formula only changing the +10 to +12.

When the Date of Service it entered the Contact Date field automatically adds 10 months to the date entered into the Date of Service field. Same of the Date of Next Service field only instead of 10 months it adds 12. So my formulas are correct. However when I go to my table I can not see any of the caluculated dates entered into the table. I can see it in the datasheet view of my form. My question is how do I create a query to pull only contacts dates from this form for a specific time frame? When I attempt to create a query I can only see table fields which do not contain the formulas for calculating the dates. Or can the fields that calculate the dates on my form be linked so the calculated dates are linked into the table and updated on the table when I update the form?

Keep in mind I am new to access so please give very detailed and specific instructions on a solution for this issue.

View 3 Replies View Related

Email Report (UNDER DEADLINE)

Feb 24, 2006

I have a form with a subform. The form is the date field. The subform are all the stores delivered to on that date. I need to have a command button to open an email with the current date showing and list all the stores with their delivery numbers next to it inside the email.

View 2 Replies View Related

Displaying 'deadline' Dates Depending On The Activity

Feb 1, 2008

Not really sure how to word this as I'm not sure if I even understand.
Basically I have been asked to set up a database logging distubances and need to display on the form 3 different dates (action by, monitoring period and date to close case) from the date the data is entered, depending on the disturbance chosen.

So if there was noise nuisance the action date would be 7 days, the monitoring period would be 14 days and the closing date would be 90 days. This would be different from, say dog fouling. When the user chooses the disturbance from the combo box I need the dates to reflect the deadlines for that disturbance.

I have entered the number of days to add onto the table containing the disturbances (ie 7, 14 etc) and know how to add these days onto the original date.

How do I make this happen depending on the disturbance selecting.:confused:

Hopefully someone can help!

View 4 Replies View Related

Issue With Form Fields. Deadline: Can Someone Assist?

Jan 2, 2006

I have a form that pulls data from a table. Basically the form is just a postcard. I have our company name, address, PO Box, city, state and zip in the upper left corner. My fields in the center of the postcard tie back to a table that contains the contact companies name, street address, PO Box, city, state and zip. My question is this: How do you format the contact company, address, PO Box, city, state and zip so that it appears uniform when printed? Some of the contact companies will have a street address but not a PO Box. How can I have the form print so the PO Box does not leave that field blank and pulls up the city, state and zip into that empty space? Also if one company's city is shorter than another how can it be formatted to pull over the state to make it uniform?

Any help on this would be greatly appreciated. I am under heavy deadline to have this form corrected and working by the end of the week.

Thanks in advance,
cnut1

Attempted to add the database but it would not upload for some reason. Will try again tomorrow. I am sure the way I am doing some things are not necessarily the best or easiest way since I am still learning Access. The form I am looking for help on is frmpostcardJanfrt.

View 3 Replies View Related

Modules & VBA :: Calculate Deadline With Workdays And Holidays

Mar 19, 2014

I am trying to get a module set-up that will add a number of workdays (no weekends, no holidays) to a date that is mentioned in a form and put the resulting deadline date in another field on the same form (date or remaining days to deadline would be even better).

Now it gets a little tricky, the module will need to select different amounts of workdays to be added to the date in the form depending on what status is selected (different statusses have different amounts of days).

I'll probably need:
List of holidays
List of days required per status
Start date (to which the days can be added).

Example:

Status = "DQ" which has 2 days to work with.
Start date in form = "21/03/2014".
Result = 25/03/2014 or preferably "2 days remaining".

View 14 Replies View Related

Deadline Getting Closer - Still Stuck In Table Design Phase

Feb 5, 2008

Thanks to all who have provided help on other threads. I have made some progress but I am still struggling with the last couple of relationships here. I am tracking projects and have normalized this data into the following tables:

tbl_customers (contains customer specific information)


Is on the "one" side of a 1:many relationship to tbl_workorders. (1 customer for multiple WO's)
Is on the "one" side of a 1:many relationship to tbl_locations (up to 2 locations per customer).
Is on the "one" side of a 1:many relationship to tbl_circuits (up to x number of circuit ID's for each customer)


tbl_workorders (contains order specific information)


Is on the "one" side of a 1:many relationship to tbl_costs (multiple costs for each WO).
Is on the "one" side of a 1:1 relationship to tbl_services (each WO can only have one row on the services table. I suppose I could combine all fields onto 1 table, but logically they represent different information. The WO table is about the work order and the other table deals with the customer's services.)
Is on the "one" side of a 1:many relationship to tbl_contacts (can be multiple internal contacts for each WO)



tbl_dates (contains as many as 33 possible dates for each project)

This table is one that I am having trouble with. Each work order can have any of the possible dates on tbl_dates. I have designed tbl_dates to be as normalized as possible. You select a date type and enter the date. I can't figure out where to relate this to tbl_workorders without using the WO field. Perhaps I am designing this table incorrectly.

Any help is appreciated. Thanks!

View 2 Replies View Related

Calculations On Calculations--too Much For Access?

Jun 8, 2005

I have an odd problem that has stumped me for several days. I'm working on a form that contains a chart. The chart is based on a query, which is based on another query, which is based on a table. In the top query, I need to put some calculated fields that operate on other fields. But when I try to multiply two fields together, I get Null. I'm pretty confident that the fields I'm operating on are numerical.

The fields of the query should be:

MaxOfEverInSchool
MaxOfSurvivalToGrade
MaxOfEverInSchool

With these being the calculated fields:

MaxOfSurvivalToGradeCum: MaxOfEverInSchool*MaxOfSurvivalToGrade/100
MaxOfCanReadCum: MaxOfEverInSchool*MaxOfSurvivalToGrade*MaxOfCanRea dCum/10000

Any insight would be greatly appreciated--I just can't understand why Access would suddenly refuse to do math.

View 1 Replies View Related

Run Today Only

Mar 6, 2008

Hi,

How can I have a query only run the records with Todays date only?

What do I put in the criteria for the date field?

Thanks.

Fen

View 1 Replies View Related

I've Done This Before - Can't Think Today

Apr 11, 2005

G'day:

I am creating a dB that has several different "parts" to it and creates several different reports and such.

I am trying to create a form - frmExpenses that I can put down several different types of information to creates these multiple reports.

Part of the form has combo boxes based on information from other combo boxes.

I am having troubles getting the second ComboBox AgencyStaffCMBO populated based on the AgencyID from the first ComboBox AgencyIDCMBO.

Any help would greatly be appreciated!

View 2 Replies View Related

Today's Records

Jun 24, 2005

What is the best way to determine start and end of a day? I am trying to pull all records that are time stamped with today's date and time. I tried >now()-1 but because hours are involved I end up with records from yesterday as well. I need to pull EVERYTHING that has today's date and time.

thanks!

j

View 4 Replies View Related

Look Up Today's Date?

Aug 15, 2005

Hi,

Is there anyway to retrieve the value of today's date?

Dedi

View 1 Replies View Related

Counts Before And After Today

Dec 19, 2006

Hi All
I need to be able to do a count before and after the current date.
My table has fields named month and year and I need to find the count before and after the current month. Any help would be much appreciated.
ChrisD

View 2 Replies View Related

Today's Date

Mar 14, 2005

Hi I have a form that I use to capture information. The "DateReceived" field prefills with todays date. I also have a "DateResolved" field that I would like to prefill with the current date, however that date would be different from the Date Received date. The reason for this is because user logs information then goes back into the form and closes the case by entering a Date Resolved. Thank you

View 3 Replies View Related

Help! Need This Report Done Today!

Nov 2, 2005

I have an unbound text box. I would like to use the Iif function so that if someon'e preferred address is B (business) It returns the field [BUS JOB TITLE] and if it isn't B it returns [BUS JOB TITLE] and then [BUS EMPLOYER] on the next line. I tried this:
=IIf(([PREF TYP]="B"),[BUS JOB TITLE],([BUS JOB TITLE] & Chr(13) & Chr(10) & [BUS EMPLOYER]))

And it's returning "#ERROR". Help! I need to finish this today for a big meeting. Thanks!

View 1 Replies View Related

Number Of Days Between Last Pay And Today

Jun 27, 2007

I'm looking to pickup the cases where the date last paid is greater than 60 days. Can someone help me

select id_case,
dt_last_pay
from noldba.case_rollup;

View 4 Replies View Related

Avoiding To See Today's Data

Mar 25, 2008

I have a query that is pulling data from a table containing a Tamestamp field. I want to set the query to pull my data but don't include anything that was logged in TODAY. How can I set this in my criteria?

Thanks

View 2 Replies View Related

Today Or All Records Query

Apr 14, 2008

Hi,

Is there anyway to add criteria to a query so when a report is run it prompts you for:

Show all records entered today or hit enter for all records?

Thanks.

I use this for filtering other data but I cannot seem to make it work with a date..

Like "*" & [Enter Part of The OFFICE or Enter For All Records] & "*"

Thanks.

Fen How

View 1 Replies View Related

Help - Need To Finish Project Today!

Jun 14, 2006

Hi guys,

I need to finish the Asset Management System I have been creating today.

The main Asset Form works fine for Data Entry. However when I view existing records, the Model of the Asset (I.T Equipment) appears blank.

The reason for this is:
I have three tables linked in the following way:
Manufacturer > Model Group > Model

When an Asset is recorded in the DB, the user must select a Model.
To minimise duplicating data I decided to only store the Model ID in the Asset Table. This way, if I need to view the Manufacturer and Model Group, I can just do a reverse lookup based on the Model ID.

Problem:
The Manufacturer and Model Group are unbound combos. The Model is a bound combo filtered by the Model Group filtered by Manufacturer (aka Cascading Combos).

However, as I am not storing the values for Manufacturer and Model Group in my Asset Table, when viewing existing records, all combo boxes are blank.

Has anyone got a solution to this problem. I downloaded an example by Pat Hartman that requeries the filtered combo on the forms current event. However in that example the main combo was stored in the underlying table.

Any suggestions. Would really like to knock this one on the head today.

Can post an example DB if it would help

Many thanks
BF

View 6 Replies View Related

Age Using Date Of Birth And Today.

Jan 28, 2005

Hi i know it is simple but can someone tell me how to work out an age of someone using their date of birth and the date now please. thanks i cannot remember the formula.

View 1 Replies View Related

Queries :: Get Records From Day Before After 5 PM And Today Before 8 AM

May 4, 2015

I need to find records for the day before after 5 pm and today before 8 AM,

I'm using access 2010, the field type is a timestamp, (mm/dd/yyyy hh:nn:ss)

I'm doing it manually using date()-1 and date(), then eliminating the records before the day before that we received before 5 pm and eliminating the records we received after 8 AM.

Theres gotta be a code for this..

View 3 Replies View Related

Automatically Update To Today's Date

Oct 24, 2006

Hi

I have a table which has a date field in it, where the default value is Now().

How do I get this field to automatically update in the table to "today's date"?

Thanks

Maria

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved