Search results

Hi sorry for lack of information. What i am trying to do is create a query where no matter what day it is it will run a show all records upto a max of seven days but not look any further then the most previous Sunday I.E. If in run it today on Sunday it will only show records for today. If run...

I was looking for a way to run this report when ever i wanted without changing any fields. so to show records upto the most recent Sunday. Will the >= date() - weekday(date()) + 1 criteria you gave me do this?

Thanks for that it does the trick, just out of interest what do you change to get the report to start from another day instead of the Sunday is it +1 Sunday +2 Monday etc etc????

Hello, I have a table of records which i need to filter via a query to show all data for up to 7 days from the day the query is ran. This in its self is simple using a Date()-7 function but i only want to show records that start from the Sunday within the date parameters. For example if i ran...

Hi, i have posted this question twice with 38 views and 0 replys so please have a look as i really need help but if you cant help than thanks for looking anyway. Original Question I have a reports menu were i can select which report i want and press either preview or Print. The problem is i am...

Report Problem. Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Hi, I have a reports menu were i can select which report i want and press either preview or Print. The problem is i am trying to creat a button and command that will send the selected report via email (Send Object) I have attached the...

ORNA, Thanks for that it works a treat

Hello i have three combo boxs on a form which are linked to a querie. I am trying to find a way that if i do not select anything from the dropdown menu in the third combo box it will by-passes the Critiria and show all of the information unfiltered. Any Help!!!!

Thanks a lot that works fine, simple when you know how!

Hi all, I have a querie that pulls together two tables, i need to filter the querie using what is selected by using three perameters in Combo box's. I understand this is simular to a cascading querie but its not one as the value's of the combo boxs does not alter in anyway after the previous one...

I have used it but only very simple stuff. I originaly exported the table to Excel and ran a V-Lookup., but when i imported the table back 1000's of data was missing and placed in an import error table. I have also tried to copy and paste as well. In regard to the size of the entries there are...

Hi, thanks for help but i am looking for a way to update a table, your suggestion looks like a SQL. Sorry if i am missing something

Hello all, I am sure what i am asking is very simple but as i am a mear starter in the world of Access your patients and wisdome is required. I have a table called "Master" with multiple fields but this question revolves around just two of them. I have a field called "Vendor" and a field...

Thanks anyway mate, have a good weekend Steve

Thanks for help but unfortunatly all it does is make the Combo box invisable when any change is made whether its £0.00 or £1.00 I need the value to change to "Closed" as a querie will run upon exit of the form.

I all, I have a Textbox called "Cost" with is set at currency format and a Combo box called "Status" which has two options "Open" and "Closed", (Default value of "Open"). What i am trying to do is when the cost is changed to anything greater then £0.00 the Combo box changes it's value to...

Thanks a lot, that works fine. I am in your debt

Hello i need your help, I am using a sort string to show only the month of a date "Month: Month([ArrivalDate])" It returns a number as a month eg April reads as 4. I need it to return the month as it is shown on the table. The format of the Date is dd-mmmm-yy. Any help would be great

Hello all, Just a quick question, If the date of an entry is stored on the table as Long Format (dd/mm/yy hh/nn) but if i run a report i want all of the entries to be grouped per month? Also i want the grouped entries to have a header that is labeled as the month name. Any help would be great...

Thanks for your reply i have not used End If because i am using End With. Or have i made an error. I have had no experience with Case statments and wanted to use them as they are neater, i have searched the forum but all i seem to find i comments saying "Search Forum".