Hi,
I am looking for guidance on how to get a query field to display a numeric period from an existing field that contains a date.
ie:
01/01/2005 = 1 (1st Month)
01/05/2005 = 5 (5th Month)
Etc.
Thanks
Darrell...
Hi,
Over the past three months I have been trying to develop an application which can repeat appointment entries.
I would like to have the option to repeat an appointment entry for a given number of weeks.
For example if an appointment entry was placed for today (Wednesday), there would be a command to create additional duplicate enties for the same day of the week for a given period of weeks ie say every Wednesday for the next 52 weeks.
Any help on how I could approach this would be very much appreciated.
Thanks
Hi there
I have created a database in Access XP (2002). In a nutshell, the database records numbers of people attending a seminar; which can take place any number of times per week, and so hence can take place any number of times per month.
I have set up the query so that it can run immediately after a seminar to show the attendants who attended the seminar on that current date "Date()" in the criteria box. However, how would I go about setting it up so that it shows who attended every seminar in the current week or month?
Can anyone help?
want to establish the criteria for a report to include 6 months (into the future) from todays date. Have tried dateadd function but this doesn't seem to allow dynamic (automatic) start of period date
Cheers
I want code with message that can prevent user to adding a new record for an employee within specific of date through a form in the Ms Access database, but after a period of date i can, For example (after two months of the last record on the main table i can add the new record, otherwise the message will popup tell the user that this employee didn't complete tow months of last adding)
View 8 Replies View RelatedI need to put a date field in that is the month and year of the reporting period...
for example
February 2013
and then another date field that is the 10th day of the month following the reporting period.
example: March 10, 2013
I have tried a number of different formats and can't get it right.
I've got a members table where my members pay an annual fee. The fee is paid 12 months on from when they originally registered. So, for example, 12 months from today, i would expect to pay my next annual fee.
Now, with different members registering at different times of the year, it isn't so straightforward. I would like my calculated field to indicate to me if a payment is required.Furthermore, I would like to include a '' date range '' so that the calculated field entitled ''Payment Required?'' shows yes for a fortnight. Here is my attempt at the expression which partially works:
PaymentRequired?: IIf((Format(Date(),"dd/mm")>= [RenewalDate] And Format(Date(),"dd/mm")<=[RenewalDateAdd14])Or ([Subscription Paid?]=0),"Yes","No")
i used the Format Date method. But i've got a case where someone is due to pay at the end of November...and today being teh 3rd of December.they should have a good few days yet to pay the fee (before teh aforementioned 14 days is up)
In my Access app I need to get the latest record added of an item from a MS Sql table and check the period between now and the date saved in the record.
So my guess is:
Select TOP 1 * from tbl_StockItems
Where StockId = Loc_StockId
I then need to check the days between tbl_StockItems.LastStockDate and Today.
How would I write an Access VBA query to give me the amount of days and put that number into a variable.
How to create a table that has a recurring entry, based on a start date and a nominal interval period of e.g. one calendar month?
Is it possible to have these entries applied automatically each time so that they appear, as required, when the table is opened?
For example, for the entry of regular payments due per month.
I am creating a repayment schedule (as a report) and I want to display a series of fields as a column which return (show) a date one month after the date in the field above.
The first repayment date field (Line 1) will show a date one month after the loan was paid out. the Next field below will show the date one month later.
I can't simply insert the "Date + 30" because that would get out of since over the year. If the loan was issued on say the 15th of January, I need the first field to display 15th February and the next would be .... 15th March.... Yes - You've got it!
Now I could do that in Excel, but I don't know how to get Access to do it.
I have just taken over an access database written by someone else. I am being asked to write some customized reports that will be extracted to excel and passed around to the team.
The database is used to track employee assignments and show us who is available and what percentage they are assigned to a task. The current report shows their percentage of assignments by month. The current column headers in the table are Month1, Month2, Month3, etc.
In the report I am creating, I would like to write it so that it pulls data based on criteria I give, but I want the columns to show Month1 as the current month, and Month2 as next month, etc. So instead of Month1, Month2, Month3... I will have September, October, November.
I cant seem to figure out how to calculate the "display as" part. When I put the formula Format(Now(),"mmmm"), the formula appears as the column name, not the expected value.
Your help is most certainly appreciated.
This used to be an easy one. . . but has anyone noticed that long date format no longer shows the day on the end? I have looked through the regional windows settings too and i cant find it anymore. What i would like is to group some results by date on a form with it displaying the day as like a diary style listing. Any help would be greatly appreciated....
View 5 Replies View RelatedCan someone help me?
is there a way about how to display date format inside on date field?
(but if user want to type the data then the date format automatically be deleted)
currently i just put the date format label below of the date field like this picture:
http://img62.imageshack.us/img62/4936/date6kq.jpg (http://imageshack.us)
please help me to solve it..
thank you:)
Hello, I've searched the forums and all over the web, but I still can't figure out how to solve my problem.
I am creating a contact manager/scheduler. There are several tables in this database but the only ones that are involved with this problem are the following:
Contacts Table (main table stores all the contact info)
Meetings Table (stores all the meetings for all contacts)
The field relating the two tables is ContactID.
I have created a tabbed form allowing the user enter Contact Info, Meetings Info, Call History etc. Entering Meeting Info, is done on a subform and the subform will only display the meetings scheduled for the specific ContactID being modified. So everything works great.
What I am trying to accomplish now is to show the very next appointment for the specific ContactID being modified. Meaning if I'm editing/adding info for a specific ContactID, I would like to display above the subform (maybe in a textbox not sure) the very next meeting scheduled for that contact.
Currently the user can simply browse through the subform (meetings) for that Contact ID, and find the next meeting, but I think it would make it a lot more user friendly if the next meeting would be displayed automatically.
So what I am trying to figure out, is how to parse the Meetings table for the specific ContactId being modified and find a meeting date that is later then NOW() but is also the earliest date from now (hopefully this makes sense). If there is now such date, I would like to display "There is no scheduled meetings" (or something along the lines of that).
How can I accomplish this? Would be through a query?
Hopefully my explaination was clear, and I would appreciate any help, because I have really hit a road block...
Eric
Good day,
I have a query that returns hours of vacation time taken for each specfic day of the year. But if no time is taken on for example Jan. 19th, that date do not show up in the query. I am wondering is it possible to return all 365 days and display a zero,if nothing is booked for that day. Attached is the db.
Thanks
Chris
Can anyone quickly tell me how to display the date in a field in a form or report as
Year - Month - Day?
example 1999 - Feb - 03
Do I do this in the format function or should I use the input mask and... and how do I do this?
Dear Programmers,
I would like to display a page that tells the user that there are no "bookings" for TODAY. It is a restaurant booking database which I have nearly completed. When there are bookings for TODAY, it shows a table with the customers booked for today (that's working ok), but if there aren't any for 'today' when I open that page, it just shows the headings of the table with no customers. I'd like to just display a message (and no table elements) when there aren't any bookings for today. Pretty confusing explanation? sorry bout that.
Of course I'm using a MS Access DB and .asp
Any suggestions?? Thanks very much.
Rod.
Hello,
I'm attempting to create a report for a major school district in TX. I need to have the total number of records entered each month and a cumulative number of records entered for the year. Can anyone help me with this?
Thanks
It's a small publishing business with a monthly newsletter. Access and database set-ups is not really my field but I'm going to give it a as much of my time as I can. I've gone through a number of tutorials and most of it is reasonably digestible but I think I have stumbled upon a hurdle.
The newsletter is a yearly paid-subscription and I need to be able to put up a sort of query/reminder of which subscribers need to renew. So that means I need to add 1 year to the subscribe date. After a bit of Googling I found a lot of DateAdd() function references for a similar problem but nothing really explaining how or where to implement it.
DateAdd("m", 12, [DateLastCalibrated])
I assume the [DateLastCalibrated] should be able to be replaced with my subscribed date but I get a number of invalid errors. Does it have to be implemented as a query? Should I create a calculate field? Do I even need to use this!?
I have a customer table with an address Column and an Order table with a OrderDate column .
I would like to create a Query that would display the customer address and only the Last order made.
So far I was only able to display the address and and all the Order dates.
hi, i have created a form and would like to display todays date and time in the following format
Mon 6 June 2005 24:00
this will literally be just on the form, no link to anything or any extra dynamic features. just there for the user's benefit
if anyone could tell me the steps that need to be taken, im guessing some formatting will need to be done, or some script will need to be placed in the form event code builder.
i have only recently focused my attention on ms access so a descriptive but to the point explanation will be ideal thanks
hi
i would like to display the date and week number on one of my forms but have no idea about dates and how to code this.
can some one help? id appreciate it it beyond me :confused:
thanks :)
rob
If I key in to the control source of a text box "=Date()-184" I will get the date 6 months ago but if I tried the same of 06/10/05 I will lose a day because of the 30/31 day months. Does anybody know another way around this?
View 6 Replies View RelatedI have two fields in a form that are both bound to the same date/time control source. One is for the date, one for the time. Using the format and input mask properties is some help. But when the focus is on the field the entire date + time displays. I would like the date field to show just the date portion and the time to show just the time portion, but haven't figured out how yet.
thanks, roy
Hi,
I have created a basic query, in MS 1997
Would someone be kind enough to give me the code for the following,
I need to display only the last 13 weeks worth of dates in this query.
The table is called "Tbl_History_RotAwaitShip"
The field is called "Time/Date" and is formatted as "13/05/2005"
Thankyou
I created a query with: Between [Forms]![Dummy]![StartDate:] And [Forms]![Dummy]![EndDate:] in it.
I created a Form with two text boxes named StartDate and EndDate and appropriate labels and buttons.
I then Created a Report, which prompts for dates and finds the data between the given Dates correctly.
Now the problem: When I create a text box in the report of the following form, I get ?Name? error on the Report: =[Forms]![Form Name]![StartDate] This should work?
Can you help me solve this last problem and acheive a good working program?