Urgent!! 7 Days From Now
Jan 27, 2006how do i make a query that only shows things with a date in them of only the previous 7 days?
this is urgent due to needing submition in 3 hours time
ADVERTISEMENT
Queries :: Counting Days Between Dates - Vacation Period And Work Days
Sep 11, 2014I have a form called subfrm_vactions
rowsource is a query called qryVacations
the query should calculated two things
1 - the difference between start_vac and End_vac in days to calculate the vacation period and put the value in field called Period (working well)
2-the work days which the period between the last day in Previous record (End_Vac) and the (Start_Vac) in the next record (didn't work)
the result is the difference between (End_Vac) and (Start_Vac) in the same record which i don't want
simply i want to calculate the work days.
Reports :: Count Number Of Days Each Week (7 Days) Person Has Worked
Jan 24, 2014I have to count the number of days each week (7 days) that a person has worked - simple enough.
But - what if they come off the job within the week?
I have been using the DateDiff function which is fine.
In the database they have a Mobdate and a DeMobDate but if the DeMobDate falls within the week the whole thing falls apart?
Trouble Implementing The Regular Days And Sunday Working Days?
Dec 14, 2004Hello everyone,
I have problem with my code here. I am using this code to determine if the LogDate with a weekday of Sunday can be declare as Sunday Work or Regular Work. The 1st week of my entry can determine if the LogDate is Sunday then compute if it reaches a 7 days working, if he is absent even 1 (one) day in his previous working days within the week. His Sunday LogDate is considered as Regular Days instead of Sunday Work. Can anyone tell me what is wrong in this code?
The problem here is the computation of 7 days after 1 week. There should be a 7 days computation every week per month in able to declare Sunday Work or Regular Work. I tried this code but it did not work on 2nd week, 3rd week and 4th week of the month.
How come on 2nd week, Sunday (LogDate) is not considered as Sunday Work even he completed the 7 days (working days) per week? I need help on this ASAP Thanks
Tim
Below is the code i'm using for defining Regular days and Sunday Working Days:
Private Sub LogDate_AfterUpdate()
Dim rst As DAO.Recordset, rs As DAO.Recordset
Dim db As DAO.Database
Dim dteToday As Date, dtePrior As Date
Dim i As Integer
dteToday = LogDate
dtePrior = DateAdd("d", -6, dteToday)
Set db = CurrentDb
Set rst = db.OpenRecordset("SELECT [HolidayDate] FROM tblHolidays", dbOpenSnapshot)
rst.FindFirst "[HolidayDate] = #" & dteToday & "#"
'See if the date entered is a holiday
If rst.NoMatch Then
Holiday.Value = 0
Else
Holiday.Value = 1
End If
If Weekday(dteToday) = vbSunday Then 'If dated entered is a Sunday determine if
Dim strSQL As String 'it will be a regular day or a Sunday
strSQL = "SELECT [LogDate] "
strSQL = strSQL & "FROM tblLog "
strSQL = strSQL & "WHERE [LogDate] >= #" & dtePrior & "#"
strSQL = strSQL & " AND [LogDate] <= #" & dteToday & "#"
'Create a recordset of records from date entered and 7 days prior
Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot)
rs.MoveLast
i = rs.RecordCount 'Count the number of days between the two dates
If i = 7 Then 'If there are seven days then it is a Sunday
Sunday.Value = 1
Else
Sunday.Value = 0 'If less than 7 days then it is a regular day
End If
Else
Sunday.Value = 0
End If
DayofWeek.Value = Format(dteToday, "dddd")
End Sub
General :: Convert Weekend And Holiday Days To Work Days
Jun 14, 2013Is there a way i can convert the weekend days into working days for example.
5/4/13 1:30 PM is on saturday what function can I use to make this day read 5/6/13 8:00 Am which is monday. Same thing for holidays.
Queries :: Number Of Days Between Two Dates With Irregular Days Worked
Apr 14, 2014I have a form where a start date is inputted (Inputfrm , StartDate) and a form where the end date of the process is recorded (Inspectionfrm , EndDate) and these both record in the table InputTbl as StartDate and EndDate respectively.
I have created a union query which shows a list of all the dates where there is work recorded (WorkingDatesQry and the column of list of unique dates is "WorkingDate"), and as we run a highly varied schedule depending on time of the year and order numbers I cannot just use a query which says Monday-Friday or Tuesday - Saturday.What I am trying to do is to find the number of days between StartDate and EndDate where there is a date recorded in the WorkingDates query.
Queries :: Missing Days - Creating Table With 31 Days Of Zero Values
Apr 3, 2013Client has asked me to create a report showing summary of monthly sales by day. That was easy. I created a query for the month the user selected and then summarized and group the data by day. Client like the result but would like to see zeros on the report for non sales days. Non sales days are days like holidays and there are no sales.
I am thinking of creating an table with 31 days of zero values and then join the two tables in a query? Or, should I create a temporary table with code and then merge the two tables which the existing query which I can then use for the report?
Date Add Problem (calendar Days Vs Working Days)
Dec 4, 2006I have a query and I need the records to display 3 working days before the 15 working day deadline.
I used the following in the criteria box below the received date field and it doesn't pull the correct number of workdays, it's pulling calendar days instead.
<=DateAdd("w",-12,Date())
Can anyone help, thanks for your time!!!
Date Add Problem (calendar Days Vs Working Days)
Dec 4, 2006I have a query and I need the records to display 3 working days before the 15 working day deadline.
I used the following in the criteria box below the received date field and it doesn't pull the correct number of workdays, it's pulling calendar days instead.
<=DateAdd("w",-12,Date())
Can anyone help, thanks for your time!!!
Calculate Days In Advance Or Days In Arrears
Dec 26, 2006I rent out a property , on the rental statement I have a field [Datepaid], [RentpaidFrom] and [rentpaidTo]. I would to have a field that can calculate the rent that is paid to show if the rent is in arrears or in Advance. I guess the code would be something like (datediff ???? etc) but i have no idea what it should be. the calculation should appear on the query as i.e.2 days in arrears or 12 days in advance etc
your help would be much appreciated
merry christmas to you all
Jabez
Calculate Working Days Between 2 Days
Mar 14, 2006Dear All,
I'm new to VBA coding. A code below is copied from a friend of mine and I can't make it work. How to call up this function in my form. In my form I have 3 text boxes (StartDate, EndDate and NumOfWorkDays). My form is based on a table.
Please anyone who would help me on this, kindly give me the step by step procedure as I am really novice. Thanks in advance.
'*********** Code Start **************
Public Function WorkingDays(StartDate As Date, EndDate As Date) As Integer
On Error GoTo Err_WorkingDays
Dim intCount As Integer
StartDate = StartDate + 1
'If you want to count the day of StartDate as the 1st day
'Comment out the line above
intCount = 0
Do While StartDate <= EndDate
'Make the above < and not <= to not count the EndDate
Select Case WeekDay(StartDate)
Case Is = 1, 7
intCount = intCount
Case Is = 2, 3, 4, 5, 6
intCount = intCount + 1
End Select
StartDate = StartDate + 1
Loop
WorkingDays = intCount
Exit_WorkingDays:
Exit Function
Err_WorkingDays:
Select Case Err
Case Else
MsgBox Err.Description
Resume Exit_WorkingDays
End Select
End Function
'xxxxxxxxxxxxxxxxxxxxxxxx
Can someone please direct me to the right path.
Your help is highly appreciated.
qwerty70
Need Help, Urgent. :)
Jul 13, 2006I have a database of employees, sales, products(Sky and Mobile Phone Contracts) and customers(Need to be common and shared between all products). ( A door-to-door marketing company)
Since each product requires different inputting tables, I have inserted all the required fields into the tblSales and then I want to run a query in order to select the needed fields and create a new Sale of a specific product.
However at the same time I want to create a new customer, assign the sale to an employee, select the commission ID that he is going to receive for the job... etc. Well as you can see the problem is that it is not letting me do it due to the fact that an entry is missing in the other table for that client or a client is not yet created for the sale. (Only one autonumber is assigned.)
What am I doing wrong?
Just in case you want to look at my mess... I have attached the DB :P
Urgent Help!!
Mar 16, 2007Hello,
I have the following "range" table. I have a "txtBoxA" (numeric) and "txtBoxPrice". I have to look in the table for the corresponding range of "txtBoxA" and retrieve the VALUE for that range and store it in "txtBoxPrice"
LOW HIGH VALUE
1 500 40
501 1,000 70
1,001 2,500 90
Example: "txtBoxA" = 200 then the corresponding VALUE would be 40 and I would have to store 40 in "txtBoxPrice"
How would I do this??
I'm doing this in ACCESS
Thank you
Urgent Help Please
Apr 5, 2007My school coursework database is on my memory stick, and i have just opened it, and all my forms, reports and marcos have gone. The file has gone from 12000kb to 10000kb, and a table MSysCompactError automatically created itself. How can i get it all back?????
The last time i accessed the memory stick was on the school PC.
http://img485.imageshack.us/img485/1139/errorzm6.jpg
Need Urgent Help
Oct 31, 2007Hi everyone,
I'm developing a small Access 2003 application for a purchase service that includes managing informations about Suppliers, Customers, Carriers, and Orders.
With the Orders issue, I'v created a form to enter all the informations about the order; customer, supplier, carrier, orderID, and a subform to enter the items with their quantity and unit price... I want to:
1- Add a botton in the form that opens a Word document; a Purchase Order, that includes all the information entered in the form.
2- Add a botton to send this document as an attachement from Access via Outlook.
I need a guide step by step to understand how it works in Access with examples if is it possible.
Any help is highly appreciated,
Best Regards,
Help.. Urgent...
Sep 26, 2005hello!
the scenario..... is i have a column, let say fieldx some of them have 10 characters that is 00000000a0 others are 8 characters 000000ao and i want the 8 char to be also 10 by adding additional 00? is this possible?
thanks...
Help Urgent
Apr 30, 2006hi
my problem is i need query code for
Concatenate Column Values from Multiple Rows into a Single row with Access
like this
Last First Code
------- --------- ----
Lesand Danny 1
Lesand Danny 2
Lesand Danny 3
Benedi Eric 7
Benedi Eric 14
Result should look like:
Last First Codes
------- --------- -----
Lesand Danny 1,2,3
Benedi Eric 7,14
URGENT Help Please
Sep 12, 2006hi everyone
urgent help needed with creating a query please...
I have a table with AutoNumber as primary key.
The second column is called ClassID and the third column is called TeacherID.
I want to run a select query that finds all records where the ClassID column and TeacherID column match.
Basically I want to find records where the fields are duplicated.
How do I do this either through Access query builder or SQL view?
Thanks in advance
Urgent!Please Help :(
Feb 21, 2007Hi Friends,
I am not very gud in MS Access.Please check out the below example and help me.
Product_name Price
P1 $20
P2 $10
P3 $5.......
Mon Week_no Prod_name No_of items
1 1 P1 4
1 4 P1 10
2 4 P1 20
3 4 P1 10
2 3 P2 50........
Assume that Price of P1 changed to $40 in Feb.
Now I want to calculate amount earned by selling P1 from Jan to March.
Remember (For Jan the rate will be $20 and from Feb to March it will be $40)
If I calculate manually it will be - 4*$20 + 10*$20 + 20*$40 + 10*$40
But How do I do it using a query or code??
HELP (urgent)
Apr 17, 2005Hi guys,
im doing a project now, where i have to estimate the service due of cars. For this i need to put a count down timer in one of my FORMS and also REPORTS(sorry about posting about reports in this section but i ddnt want to post twice :rolleyes: but will do if necessary)... i searched a LOT on google but couldnt find anythng..... if some1 could come up with something reasonable, it would be VERY VERY helpful...
Please try to make it before this friday plz if you can...
thanks! :rolleyes:
Urgent Help!
Apr 21, 2005Hi i have imported an excel sheet in form as an OLEUnbound.
The form is for registering product details and the excel sheet iam using for price calculations. But when i register a new product the sheet doesnt clear it shows the same values enterd as in the previous product and when i change them the same thing happens with the previous products. I want to use the same sheet with the calculation differently for all product.B`cus the products doesnt have same price.
Any help. I want to use that one sheet instead of making one own sheet for every products. Use the sheet as an mal or something like that.
Plz help.. :confused:
i have included a picture of my form.
when i should register a new product the sheet should be linked for that product only.
Need Urgent Help
Sep 8, 2004Hy, Ive got problem that drives me crazy. i have form with two combo boxes and text field which shows value from table based on a criteria from those combo boxes.
Can i use Dlookup function with more than one criteria like
Dlookup(myField,myTable,1valueOfTheField inTable= & forms!myForm!cboFirst.value &,2valueOfTheField inTable= & forms!myForm!cboSecond.value)
I also know how to make a querry in VBA that gives me correct value but i don't know how to put that value(which is currency) in textbox
Or is there other way to solve this problem and get correct value
Thanks for any help
Urgent....
Jan 6, 2005i,m doing a project using Microsoft Front Page.It has to link to database.can i use Microsoft Access to do my database.if not,what should i use?
View 2 Replies View RelatedUrgent Help!!!!
Jun 4, 2005hello to all,
i need help with a basic problem. Is it possible to link a listbox and a calander,
My Main aim is to get a booking board for a hotel database, therefore i want it so that when you click on a particular date, the listbox displays all bookings on that date.
Also i need assistance with using queries for derived entities!!
Please help
Urgent Help
Oct 6, 2006Hi i have a problem coming up with the ans to the last part of this text. Can anyone help me?
The information technology (IT) department in your school has asked you, a part-time
employee at the department, to help create a database to track fundraising activities
and donations in your school. In the past, the schools fund-raising foundation has
been manually maintaining detailed records of donors and fund-raising activities. The
schools president has recently asked the IT department to help computerize the
foundations records. Your job is to design and implement the database for the
foundation. The following information is captured in the manual records:
1. Individual_Donor name, address, email and phone number.
2. Company_Donor company name, company address, company email address
company phone number, main contact, main contact phone number, main
contact email and phone number
3. Amount of donation and date of donation
4. The donation can be a one-off donation or a monthly donation (interval of one
month from the date of the first donation)
5. Name of fund-raising campaign (New building fund, President fund,
Scholarship fund, Bursary fund, Star fund)
1. Draw the ERD and database schemas for the donor database that you will
design for the foundation. Decompose the ERD where necessary. You can
make any assumptions that are reasonable for the design. Make sure to
suggest attributes that should be included but are currently not in the manual
system.
(5 marks)
2. Implement the ERD in Access. Design the tables for the donor database. If
the NRIC number of the individual donor is not available right now, what is an
appropriate primary key for the individual donor? Populate your database
donor with records.
...................(3 marks)
3. Create an input form(s) for the donor database. In your design of the input
form(s), create (a) an input mask for a control and (b) a validation rule for a
control
(4 marks)
4. Create a report that lists the donations in the order of descending amount of
donations. Put in the appropriate donation details. Separate individual
donations from company donations. Aggregate the donations for each
category
..(2 marks)
5. Perform the following queries on your database.
a. What is the largest amount of total donations received over a single
month period (first of the month till end of the month) for 2005?
b. Which are the company donors that donated on a monthly basis and
how much are the donations?
c. List the details of individual donors that donated to the New Building
and state how much they are donating to the fund and on what dates.
Urgent
Oct 12, 2006i want to execut two queries from unrelated table in single query.
is it posiible the below logic
"select PRODUCT_NAME from Products and
select Divisionname from Division "
i want to store colums of two different tables in single table
thanks in advance
narasim