Search results

I am having on heck of a time trying to sort a subdatasheet in my table. I have a table that has tiered subdatasheets as follows: Table 1 Table 2 Table 3 Table 4 For some reason when I open table one and get to the record I need in Table 3, Table 4 is sort...

I have tables that have various date fields with dates in most of the fields. The date fields that are empty are fine, but I want to be able to put something like "N/A" in a date field if a date doesn't apply. Is there a way I can accomplish this? Thanks for any help offered. Brad

Can no one figure this out, or at least point me in the right direction to figure it out for myself?

What I need is to turn (1) one record into (7) records. For example, the (1) record contains 7 "Date" fields (Date1, Date2, Date3...) and also contains 7 "Hours" fields (Hours1, Hours2, Hours3...). I would like to split that 1 record into seven records that look something like the following...

Sorry ab out that... See Attached. I haven't created the other table yet, but basically I want to break each record in one table into 7 records in the new table, where Date1 corresponds to Hours1 and so on. thanks again for any help.

Hi all, I want to thank anyone who might be able to help me with this and appreciate you taking the time to read my problem. Ok, I have a table in my DB that is populated from a word form that I have created. In the form I have 7 "Date" fields that are filled by a user and 7 "Hours" fields...

RE: GolferGuy I am using Access, don't know why i would have typed excel other than my brain being scrambled at the time. Anyway, the preoble is I have coulumn data the may eventually run over past the first page and i would like to have the coulmn headers repeat on subsequent pages.

I would like to have my page header show up on every page except the 1st page. I am using Access XP(not by choice...work comp). Any help would be appreciated. Thank you

Wayne, Thanks so much for the speedy reply and for your help. I think I have the problem solved. The information does have a relationship to the existing data. I think this is going to work for me: Private Sub btnTransfer_Click() Dim db As DAO.database, sSQL As String Set db...

Wayne, Thank you for the reply. What I have is this, I have a small windows app that batch processes word forms and puts each form field into the db. What I end up with is one tale with all the information. Much of it is repeated, so it is not a very efficient db, so what I am trying to do is...

I am trying to get data from one table to another. What i have so far is Private Sub btnTransfer_Click() Dim db As DAO.database, sSQL As String Set db = CurrentDb aSQL = "UPDATE Projects RIGHT JOIN InspectionReports ON Projects.ProjectNumber =...