Hello msquared
Thankyou yes the data type was text and after changing it to date, the query worked. Thankyou again for your assitance
zandiT
Last Activity: Nov 18 '09, 06:18 AM
Joined: Sep 11 '08
Location:
-
Filtering Access Reports Based on Formated a Date
Hello
I have an access report and im using a query to filter the report using Date parameters eg Start Date-12 May 2009 and End Date-30 September 2009. the query works perfectly.
My problem is recently i formated the date values so they appear as May 2009 instead of 12 May 2009. When i tried to use the filtering query again it did not work.
Instead the result set from the query only showed records from... -
tblGeneral
GeneralID: Autonumber PK
BorrowerName: String
DateAdded: Date/Time
tblFinance
FinanceID: AutonumberPK
Amount: Currnecy
Date: Date/Time
the tables are joined in a query
the report should display currnet records, as well as the same data but from the previous 3 months for comparative purposes. So for example;
Position as at 31 May 2009 and Position as at 28 February...Leave a comment:
-
Thank you for the quick response fishval,
let me explain further.
i need to create a report that displays information from two different tables as well as current records and previous records form the previous 3 months. the current records are not a problem, its displaying the records for the previous months thats an issue for me. i need to put it in a query so its easier to link it to a report.Leave a comment:
-
Access Query To display previous months Records
Hello
i have a query with two date fields General.Date and Finance.Date. i would like the date in Finance.Date to be previous month of General.Date. So for example if General Date is in the month of February, the Finance.Date should be in the month of January. i put the following expression in the criteria section of Finance.Date =DateAdd("m",-1,[tblGeneral.Date]) but it is not working
Thank you for your help -
helo
thankyou for the reply. yes its in its own table. ive never done an append query, but let me do some research on it and try it out
thanks againLeave a comment:
-
Copying records(duplicating records)
hello
i created a database that has a form which represents a template. this template is filled out every month. my problem is i don't want to have to copy and paste ever record wen the template is being filled out the next month. i thought of putting the controls i want to duplicate in a label, but the text is too much and i can't scroll with a label control, so had to use a text/ memo box. is there a way i can click a button and the... -
setting permanent color on datapoints, ms access bar graphs
Hello
i have a bar graph on a report. i need to know how to set the color for the different data points without the color changing depending on the output. here's what i mean.
if the result is equal to 1 then the data point for the value 1 should always be white,if the result is 2,3,4 and 5, the data points for these values should always be yellow and 6,7,8,9 should be always be red. it works fine if all of the numbers are... -
Creating a Search Form
Hello everyone
i have a mainform called frmMain and it has 2 subforms. the frmMain consists of 2 combo boxes. i want to create a search form whereby the user can choose an option in combo1 and in combo 2 then the matching record appears in the subforms . i tried using the find button in access but the search form is too confusing for users so i would like to create a form that is more straight forward. your help is greatly appre... -
Group Header Title in Access Reports
hello everyone
when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report that groups depending on a field called TypeOfReporting . It can either be Complete or Edit. i used the sorting and grouping functionality and it groups all the records depending on if the TypeOfReporting was Complete or Edit. but i want to display... -
Group Header Title Change depending on group displayed
hello everyone
when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report that groups depending on a field called TypeOfReporting . It can either be Complete or Edit. i used the sorting and grouping functionality and it groups all the records depending on if the TypeOfReporting was Complete or Edit. but i want to... -
Thanks Fish
Great help!!!Leave a comment:
-
Disabling SHIFT key to deny access to database window in an MDE file
hello
i have a database that ive converted to an mde because its going on the network and will be accessd by various users. on the startup option i unticked all the options available so users wouldnt tamper with the underlying functionality of the database. my problem is when i hold down the shift key and open the database it opens the database window. you can't do anything to the forms but my main problem is there is no protection for the... -
hey
ive just tried it out and deleted the relationship and created a new relationship with the linked audit table and it worked fine. can i just ask, how often will i need to refresh the link to keep the audit table up to date or is that done automatically. thankyou so so much again.Leave a comment:
-
thanks for the quick reply, ive manged to import the audit table to a new database but when i tried to delete the table in the original database it won't let me because my audit table has a relationship with one of the other tables (main table) in the original database. i can delete the audit table once the relationship is also deleted, but will i be able to re link the relationship with the audit table in the new database and the the main table...Leave a comment:
-
thankyou so much. its working now.
thanks againLeave a comment:
-
Archive access table to another access databse
hello all
after creating an audit trail for my access database, ive realised that the size of the audit table is increasing very fast and i would like to transfer the contents of the audit trail table to a separate database. how can i do this. im using access 2003 and the database is in an mde format is unsplit and on a network share.
thanks -
Unable to Manipulate Records from datasheet view on users desktops
hello
i have an access database which ive just put on a shared folder on the network for users to use. i tested it well, exported all the objects in a new database, converted to to an mde file, placed the mde version on the network and opened the database again just to make sure its working. but the problem is if a user opens the database, they cannot add delete or edit fields in certain tables.
i have a particular... -
yes im really happy. i was always really sceptical about any kind of programming and databases but after this i am going to take it seriously and really understand what it involves. thankyou again for the forum. by the way i know i can't make it executable but what do you think is the best way to finish it off....Leave a comment:
-
Hey its working now. now im done just error handling and thats it.Leave a comment:
No activity results to display
Leave a comment: