Search results
-
R
Access Report - Custom Stacked Line Chart
Wondering if someone can point me in the right direction. I am updating an access db and one of the reports that gets used a lot is for displaying sieve data. I have attached an example of the current charts output here. The chart is an embedded Microsoft Graph 97 Chart and was created by an... -
R
Incrementing A Value For Every Return In Select Statement
Access. I am pretty new to SQL in general so based on your question I'm assuming ROW_NUMBER() is not an Access function? tblImport has a date field and tblSubImport also has a [Sampled] column that has a time value which ideally I'd like it Ordered By but not super necessary. I'll look into the... -
R
Incrementing A Value For Every Return In Select Statement
Trying to increment a value in an SQL SELECT statement. Started with the following: INSERT INTO Table1 (PROJECT, SET_NO) SELECT tblImport.[Project Number], (SELECT MAX(SET_NO) + 1 FROM Table1 INNER JOIN tblImport ON Table1.PROJECT = tblImport.[Project Number]) FROM tblImport INNER JOIN... -
R
Solved Linking form table and subform table from imported excel spreadsheet data
Finally had time today to come back to this issue and this worked perfectly! I knew there was some sort of join query that could do it, i just didnt know how haha. Thanks so much for putting together that demo, I have definitely learned from this so appreciate it! -
R
Solved Linking form table and subform table from imported excel spreadsheet data
No I was just trying to describe the fields, the actual field name is some sort of RecordID name like that but it just populates through Autonumber. I have quickly reviewed the database you sent me and upon first glance it does seem like it should do what I need. I will hopefully have time in a... -
R
Solved Linking form table and subform table from imported excel spreadsheet data
Currently the database is filled through forms from the users where they have to physically be in the office, but we are trying to use some new software that users can use in the field and then export their results. So what I am trying to do is import these results properly into the existing... -
R
Solved Linking form table and subform table from imported excel spreadsheet data
I have added some more info in my post about what the spreadsheets and tables look like. The spreadsheets have different fields then the tables so I need to import each spreadsheet as a new table and then query them to insert/append the details I need into the existing tables. I have it working... -
R
Solved Linking form table and subform table from imported excel spreadsheet data
I have two separate excel spreadsheets. One contains some overview information about a project, whereas the other excel spreadsheet has project specific details that extend multiple rows. Each row in this specific info spreadsheet has an alpha-numeric identifier that can be used to link it to...