S
SURGEON1971
How do i add data to a table in a specific place for insertion in date order
and then renumber each record previously in table?
and then renumber each record previously in table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Daniel Pineault
Renumber? Why? What number are you wishing to renumber exactly? If you are
referring to an autonumber, you should not be reliant on that number
whatsoever to be sequential!!! If you truly need such a sequential number
then you'd need to create it yourself, but then I'd ask you why?!
As for insertion place. If you set your form, you are using a form for data
entry right, to sort chronologically, when you enter new data and refresh the
form it will automatically be sorted properly.
You need to give a little more detail about your table structure & form for
us to have an understanding of where you are vs. where you would like to go.
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
referring to an autonumber, you should not be reliant on that number
whatsoever to be sequential!!! If you truly need such a sequential number
then you'd need to create it yourself, but then I'd ask you why?!
As for insertion place. If you set your form, you are using a form for data
entry right, to sort chronologically, when you enter new data and refresh the
form it will automatically be sorted properly.
You need to give a little more detail about your table structure & form for
us to have an understanding of where you are vs. where you would like to go.
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
S
SURGEON1971
Hi,
Let me start by saying I HAVE NEVER USED ACCESS BEFORE!!! So be gentle with
me and speak plainly!!LOL
I am entering data via a table. It contains info on previous bookings for
childrens parties. Each table is by year and contains all contact details and
party booking info.
Where I would like to go with it is to be able to analyse all means of
things such as most popular party theme, all parties by county, where people
heard about the company etc and so on for marketing and advertising in the
future/franchising and info on repeat bookings.
I wish to renumber because as i have filled in data then deleted some i note
that autonumber doesnt work. I do need to have each record sequentially
numbered to correspond to when they were booked. The data also includes the
actual date of the party. So far they are being entered sequentially anyway
on basis of party date.
So my main problem today is that sometimes people book two parties and the
paper booking sheet is filed sequentially by date under later party date and
thus i cannot insert new record in table if other party was earlier up the
table. I am overcoming it the long way round by cutting and pasting!!!!!
So all said i think and clearly i need an idiots guide to access and excel
(for other things im doing with business info) or someone like you to move in
to my house!!!LOL
Let me start by saying I HAVE NEVER USED ACCESS BEFORE!!! So be gentle with
me and speak plainly!!LOL
I am entering data via a table. It contains info on previous bookings for
childrens parties. Each table is by year and contains all contact details and
party booking info.
Where I would like to go with it is to be able to analyse all means of
things such as most popular party theme, all parties by county, where people
heard about the company etc and so on for marketing and advertising in the
future/franchising and info on repeat bookings.
I wish to renumber because as i have filled in data then deleted some i note
that autonumber doesnt work. I do need to have each record sequentially
numbered to correspond to when they were booked. The data also includes the
actual date of the party. So far they are being entered sequentially anyway
on basis of party date.
So my main problem today is that sometimes people book two parties and the
paper booking sheet is filed sequentially by date under later party date and
thus i cannot insert new record in table if other party was earlier up the
table. I am overcoming it the long way round by cutting and pasting!!!!!
So all said i think and clearly i need an idiots guide to access and excel
(for other things im doing with business info) or someone like you to move in
to my house!!!LOL
D
Daniel Pineault
Firstly, you really should not be using tables for data entry. You should
create a form and set it to display the data in the order you need... Forms
give you much more power and control!
That said to solve your immediate issue I would enter the Date and Time in
the party date field. This way you do not need to rely, which go can't
anyways, on a sort number. You would simply sort on the date column and
everything would be ordered properly. For instruction on sorting by
date/time look at:
http://www.functionx.com/access/analysis/datetime/filtering.htm
so don't just enter the date, but also enter the time with the date.
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
create a form and set it to display the data in the order you need... Forms
give you much more power and control!
That said to solve your immediate issue I would enter the Date and Time in
the party date field. This way you do not need to rely, which go can't
anyways, on a sort number. You would simply sort on the date column and
everything would be ordered properly. For instruction on sorting by
date/time look at:
http://www.functionx.com/access/analysis/datetime/filtering.htm
so don't just enter the date, but also enter the time with the date.
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
S
SURGEON1971
Yes that helps thanks. It also raises further ?'s
Is it possible to merge table data to a form? only i have done tables for
2006-2008.
When putting in date entry into table it is formatted to facilitate ease of
entry and then converts to long date. How would putting time in as well
affect this and what is the solution.
Should i just start over and create forms instead?
Is it possible to merge table data to a form? only i have done tables for
2006-2008.
When putting in date entry into table it is formatted to facilitate ease of
entry and then converts to long date. How would putting time in as well
affect this and what is the solution.
Should i just start over and create forms instead?
B
BruceM
You should not separate data by years. Rather, use a date field in the
table. Create a query based on the table. In the criteria for the date
field:
Between [Enter start date] And [Enter end date]
There are a lot of ways to go about using criteria. This is just one of
many options. You can use the current year automatically, or you can just
enter the year rather than a date range. It's depends on how you specify
the criteria.
You can add the data automatically when you enter a new record. Set the
Default Value of a text box bound to a date field to:
=Now()
Default Value affects only new records.
Use a query to sort by that field to see records in the order they were
entered.
There are quite a few resources to help out the learning process. One very
good one is here:
http://allenbrowne.com/casu-22.html
Links on the page will lead to further information.
table. Create a query based on the table. In the criteria for the date
field:
Between [Enter start date] And [Enter end date]
There are a lot of ways to go about using criteria. This is just one of
many options. You can use the current year automatically, or you can just
enter the year rather than a date range. It's depends on how you specify
the criteria.
You can add the data automatically when you enter a new record. Set the
Default Value of a text box bound to a date field to:
=Now()
Default Value affects only new records.
Use a query to sort by that field to see records in the order they were
entered.
There are quite a few resources to help out the learning process. One very
good one is here:
http://allenbrowne.com/casu-22.html
Links on the page will lead to further information.