Reports by date range

[sambucaman]

Hi everyone.
Sorry if this post is in the wrong place, but as im new to access I dont really know what to search for. I did try searching, but its all gobbly-de-gook to me
Ok, so im new to access, but over the last few weeks i have been getting to grips with creating a table then a form. So far, i have a form which allows me to create a customer, with name, address, ect and also a few drop down menus which vary from customer to customer (is this called lookup?)

For each customer i enter on the database, i have date function, so i can see what date the customer was entered.

My question is....

How can i make a report, to select all the customers entered within a specific date range
ie - all entries between 1st May 2010 and 7th May 2010, or 4th may to 8th may etc.

Once again, as in my few previous posts, please be kind and keep techno speak to plain-ish english - i am still a very very very novice access user and need a bit more help than; do this and do that!

Also, im after a bit of help with my form / table. Each time i open the dataebase it opens and shows customer #1 - how can i set this so that when i open access it just shows a blank field and the next customer number (eg, enter customer 20 then close db, upon reopen it shows blank field with no 21 all ready to go?)

Hope you nice guys and gals can help (again ) Thank you so much in advance.

Andy

 

[rainman89]

check this out

if you are using a form, you can do it this way

between [forms]![frmname].[startdate] AND [forms]![frmname].[enddate]

if not you can do

between [enter start date] and [enter end date]

put that into the criteria for your date field

Also for your form- you can do docmd.gotorecord acnewrecord on the forms open event to automatically open to a new record.

 

[boblarson]

I don't know if it will help or just confuse you but you might want to take a look at my sample on how to build a generic report and then limit it by various means (including a date range). Here's the sample.

 

[boblarson]

Also for your form- you can do docmd.gotorecord acnewrecord on the forms open event

Probably should use the ON LOAD event instead as the records have not yet loaded in the On Open event.

 

[rainman89]

Probably should use the ON LOAD event instead as the records have not yet loaded in the On Open event.

That's what i said!

 

[PNGBill]

Good to hear you are getting into it and now asking more specific questions as you find a problem.

Your drop down menu could be a pop up or a list box or a value list, look up etc. Not that it could be any all the time just that your words may not be specific to what is happening. Check F1 when you are in a task and often the help menu opens on what you are doing - If you don't know what is happening, maybe help does - works for me sometimes

Your queries will select the dates to be shown. If you have a question within a query then this will also be asked when a form is opened using that query.
Say you have a field InvDate, then in the query you type this in the criteria.
Between [Enter Start Date] and [Enter End Date]
When you run this query it will ask you "Enter Start Date", you type in 01/01/2010 and then it will ask you "Enter End Date" and you type in 31/01/2010 and the query will return all the records with an InvDate of 1st January 2010 and up to and including 31st Jan 2010.
This can be developed a lot and you can refer to fields rather then input the data. eg, I just did an asset register for our company and to start you enter the start and finish date of the financial Year (Could have just used end date). From then on, all dates are either or both of these fields until I change them ie an new financial year.

When you open a form it can be opened as edit or enter new data.
Your form is being opened as edit and the sort order is ascending on the primary key? (invoice number).

If the query you used had a different sort it would open on a different record.
How did you open the form, by menu or a command button on another form?

Have you setup a menu yet?

Just as you do not want a form to open to edit the first invoice ever created, you may not want to have a new invoice or customer waiting to be added. This can mess up your autonumber as records may be created by accident or half created.

You could have the form open with no ability to edit or add data but command buttons to allow same.

 

[PNGBill]

This is an entry in access help:

Specify whether a form opens for data entry only@import url(/Office.css);Specify whether a form opens for data entry only

1. Open the form in Design view.
2. Double-click the form selector to open the form's property sheet.
3. In the DataEntry property box, click Yes if you want the form to open for data entry (blank record); click No if you want the form to open with all records showing.