Queries
in [Access]
|
Can I do this in a query? tblNames: id (auto), name tblSvcCode: id, name (there are only 2, 0=nonbill; 1=bill) tblWIP: id(auto), EmpID (linkto tblNames), SVCcode(link to tblsvccode),WIP WIP looks like: id Emp ID SVC Code WIP 1 1 1 55 1 1 1 20 2 1 0 60 3 2 1 75 4 2 0 89 5 3 1 40 6 3 0 12 Ca... 19 Feb 2010 17:45
summarize data in access 2007 I have a EmployeeInfo table with 1000 records. Each employee has an autonumber EmployeeID field. Within that same table there are 117 supervisors, identified in the SupName field. I would like to summarize the count of EmployeeID by SupName. I have no idea where to begin... Please let me know if you need more i... 19 Feb 2010 15:32
Query Results Where Qty Shipped is not Divisable by 4 How would I construct a query to return all invoices where the qty shipped for a specific item is not divisable by 4? Really its the divisable by 4 part need assistance with. Thanks! ... 19 Feb 2010 14:24
Importing Excel data into Access? Can Excel data be imported into Access easily!? I know from Word table I can simply copy and paste but it is not that easy when doing from Excel to Access! I downloaded this manual from http://www.mousetraining.co.uk/training-manuals/Access2003Intro.pdf but couldn't find this topic If anyone knows please let m... 19 Feb 2010 15:32
IIf Hi i have a crosstab query that takes values from 2 tables table one weekly prod scores (entered weekly) table two takes scrap numbers (entered daily) the values are divided to create a percentage loss using 1per:Sum((rejectreason_baseweeklysum.sumof1/ [rejectreason_baseweeklysum Query].wk1)) problem is w... 19 Feb 2010 09:52
Hyperlink within Database 2007 I am creating a rather extensive database in Access 2007 that is going to have many tables. To make this database user-friendly I want to create Hyperlinks that link to tables within the database. Here is a basic idea of what I want to do: In Table 1 I have a field with Location Identifiers the run fro... 18 Feb 2010 10:35
Sorting in select query. manually Hello, I have a select query and I would like to sort on the field month. but I want to be able to specify the order myself (not descending nor ascending). how can I do this? thank you! ... 16 Feb 2010 18:23
Another Len function not working Thanks for your time I have this code: Private Sub txtUser1_AfterUpdate() On Error GoTo txtUser1_AfterUpdate_Error If Len(Nz(Me!txtUser1, "")) = 0 Then MsgBox "does it work" Me.txtUser1.SetFocus End If On Error GoTo 0 Exit Sub txtUser1_AfterUpdate_Error: Err.Description = Err.Descrip... 16 Feb 2010 18:23
OLE object open problem Dear Kindly solve my problem table t1 has fields pictures, name in design view pictures field is ole object name is text. now in table, i have inserted some pictures in field pictures, corresponding written some name in name field if we open table t1 to view. pictures name package n1 pa... 17 Feb 2010 02:18 |