Hi, i have a query which contains two fields: PtId and visitdate. I'd like to create a field that sequentially numbers the visits.
If you're really smart, the second part of my problem involves computing the time from the last (or max) visit to the visit before it. I was thinking if I had the visits numbered it would make this task easier, but if there is another way, that would be even better!
Thanks so much for your help!
Hi, I have a MS-Access Database with one table, around 50 column and 1000 of rows. When I retrieve data(rows) one by one from this table, I am not able to access it sequentially, only one record(row) is not retrieve in sequence.
I have one database MVAL. First I go to its first record by MoveFirst then try to read records one by one sequentially by MoveNext based on some conditions.
When I access the records after 1st two records(rows), third time 6th no. record(row) is retrieved instead of 3rd record. I write this data into a file and then read this file in some other program. As my program is expecting data in sequence which is actually not.
This deficiency can be removed if I make completely new database but I can not do it every time or I have to add some new column and make some logic for its sequence.
Is there any way so that I can retrieve it in sequence. My data is stored based on field name "Signal Number" which is unique (Indexed- No Duplicate).
Here's my problem: I have to get a control number from a table, then use it to sequentially number a group of records in a table.
Details: I need to batch print a group of checks (could be one, could be a dozen). The data for the checks is in a temporary table (that is exactly the same as the permanent check table except the check number is blank). I assume I'll retrieve the control number using a simple one field popup form (that way the user can verify the number is correct). I'm fine up to this point. How do I take the number from the form and use it to sequentially number the records in the table? (At this point the popup with the control number is open and the table is closed.)
Is it safe to assume, after this process I can use the DMax function on my temporary check table to find my new last check number and write it to the control table?
FYI, after the records in the temporary table are numbered, they're printed, then appended to the permanent table, then deleted from the temporary table.
WELL, I cant get the Quantities to display in sequence where it would find the next record that matches Apple. I did some research and saw a formula that will find the next record which it looks like the one below but I dont know how to use that.
Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.
I am sure Im not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question.
Is there a limit on the number of records you can have in an access database? I've got one with 8500 records and it's been a PITA! I have a webpage on our intranet so users can go and enter their information to it, and they get a nasty error whenever they try to enter information. I'm trying to figure out why and i was just wondering... i know it's not the webpage because when i connect it to my test database it works fine? so i dunno :confused:
I have a table that contains a number of email addresses. I need to combine a number these into a single record to allow me to email a report to a number of different recipients depending on the client the report is for.
I have a database that allows the user to order clothing items. Each size of each item has a different stock number.
I have [StockNo] - [StaffNo] - [Qty] i need to generate [OrderNo].
The problem i have is that [OrderNo] is incremented after every five five items (ie[StockNo]). This gives me my first problem of selecting just the first five records of a table in order to allocate an order number.
The second problem i have is that in order to allocate an order number, i have to summarise the [Qty] by [StockNo]. This gives me the opportunity to select the order number but i lose the individual [StaffNo] information. This information, together with the [OrderNo] is needed for a master order table.
I have created a crosstab query which summarised the [StockNo]but how do i retrieve the [StaffNo] information from the column headings.
I am new to Access and would be grateful for any help or comments as to whether i am going about solving this problem in the best way.
Hi. I have a form (frmdetails) to store job details and another form (frmMaterials) to add materials to each job. They are both linked via a field Project_No
I have a query (QryTotal)that when run will list the materials used for each project, that is all OK.
What I am tryng to do, is add a text box to frmdetails, that will just tell me how many materials have been booked against each job. Just a running total that will tell me that for project number 100000, 4 items have been booked.
I have tried using subforms (using =count(*) ) but this doesn't seem to be working. I also added =Count(QryTotal!Material) to a text box but this doesn't work.
I have a query that pulls data from two tables. I need to have another column in the query that numbers the rows like a primary index or gives each records a different number. Any ideas without adding any columns to the orginal tables.
Hi- Im importing 80,000 records into a table and then using a query to reformat the records and append them to a second table. The import works, but the append quits after about 6500 records. Is there a limit to the number of records an ACCESS query can handle?
Does anyone know if this is possible. I've looked but can't find anything like it posted within the forums unless I'm searching for the wrong keywords.
If I have a list of records on a continuous form, I want to drop a combo box at the end of the each record with a list of numbers in ranging from 1 - 100. When a value is chosen, the selected record is then duplicated by that number.
For example, Select a record, choose 20 from the combo box = 20 new entries of the record.
Also, as a side issue, is there a way of omitting or clearing certain fields from the process. For example, Serail Numbers are unique, so I want the user to have to manually key these in once the duplication process completes.
A form i have gains its records from a query. I know that the number of records found is displayed down the bottom, but is it possible to have a text box displaying this, so i can choose where on the form i have it?
Is there a way to display a number (on a Form) for the number of records in a specific table? I just want to reference how many records there are. I tried to search this topic, but couldn't find anything. Thanks.
I am attempting to drop in a lot of records (about 54,000) into an Access database. Can someone please let me know how many records Access will accommodate without having any problems???
I am expected to add to this database on a weekly basis and believe that Access will not be able to accommodate our needs. Can someone please let me know if I am right?? Beside me dropping in the data, someone will be doing data-entry as well.
Hey all, i just would like to know if there is a way to have a fixed number of records in a query. Let's say, example (a), a query returns 2 records (qry1); i would like to have my query (qry2) to have 5 records, so the first two records will appear and then 3 blank records. (b) A query (qry1) returns 4 records, then this query(qry2) should return the 4 records plus a blank record
Why do i want to do this? Because i want my report to show 5 records so when i print it i have those blank spaces to fill if necessary.
I want to have this: ______ lrecord1l lrecord2l l______l l______l l______l
Instead of: ______ lrecord1l lrecord2l
What im doing now is creating a temporary table and add the records to it plus blank records. What i used to do was add blank records in the same table meting the criteria of the report, so they will appear. After close the report, those records would be deleted.
I would like to know if theres another way, like a command in sql, or maybe some property on the report. What ever is most efficient and a good database practice. Thanks in advance
(this might be more appropriate in Forms; apologies if I'm putting it in the wrong place.)
My company runs a home repair program and we keep track of our clients in a database I made a few months ago. We use almost exclusively a form drawing from 3 tables. We just hit 800 records (according to the form) and I was checking some things, and found that there are 807 records in each of our 3 tables.
I did a preliminary check, and the primary keys match as best I can tell, so I'm trying to figure out how 7 records can be missing from our form.
We want to send letters to clients on behalf of our salespeople on a weekly basis from a list of clients in a table. But some salespeople will have 5 letters go out and some will have 20 go out (depending on what amount the salesperson is able to followup on). I can store the weekly letter quantity number in the table no problem, but I am just not sure how to have the query show 5 letters for Bob and 20 letters for Sue. I know about the "Top N" setting in query design, but not sure how to set it to read from the table.
I've been searching the Queries Forum for help on this issue. I have a database that records loading records for a Taconite facility. Some days contain many records and on other days there are no records because of no loading activity. I create reports that group these loading records by each day, but I really need a quick and dirty report that just shows me the number of days in any month in which we had loading activity (records present). I have not figured out a way to create a query which counts the number of days in a month which contain records. I'm hope I'm explaining this well enough for someone to help me understand what to do.
I am creating a database that will allow users to log in and submit bids on houses. There are only a certain amount of house plots available, but I cannot seem to make the database find the top bidders within the plots available, for example the top 5 bidders or top 7 bidders, depending on how many plots available.
I have 4 fields, from two different tables. I have a bidder ID field, House Type ID field (which I use "[please enter house type ID"]), a bid amount field and Number of plots field.
I want the query to select the top "x" amount of bids that it says in the number of plots field, e.g. 5.
How can I do this for all the different house types?