Join Properties Cause Type Mismatch
May 29, 2007
Okay, I apologize, I'm not extremely Access knowledgeable so bear with me.
I have an Access database I created which I thought was working okay, then I realized it was missing one vendor because we haven't started writing checks to that vendor yet and probably won't for a while.
I am using a make-table-query to create a table that combines data from two linked tables. The two linked tables have a matching field (VendorID) one linked table is "History" and the other table is "Master" (these tables are SQL data from MS Great Plains if you need to know that).
Now my problem ... not every VendorID in Master table is present in History table.
I first created the join statement to say use all records in History and only those records in Master that match. This works without any error statements, however, I discovered there is a significant field of detail that is being omitted because a VendorID is in Master, but since no checks or invoices have been created for that VendorID it does not exist in the History table yet.
I decided to change the join properties to say "include all records in Master and only those records in History that agree". When I try to run the query I receive the error message "data type mismatch". I feel certain it is because several of the fields have no information to draw from on the vendors that don't exist in the History table.
What I need the query to do is go ahead and use the information from the Master table and when there is no matching VendorID in the History table use a zero for those fields.
I used to program and know a little C+. I understand "if" statements and feel like a sql if statement could work around this (for example, if History.VendorID does not exist zero, else History.[fieldname], but I don't know how to go about doing it. Any help for a novice would be much appreciated. Thanks in advance
View Replies
ADVERTISEMENT
Aug 15, 2005
I don't quite understand this error message, and therefore cannot begin to fix it. One of my forms will not open except in design view because of a "Type Mismatch in JOIN expression" error. Can someone please tell me where to look to fix it? Thanks.
View 5 Replies
View Related
Apr 30, 2006
Looks like mismatched join types has caused others plenty of headaches in the past!!
I am trying to create a query that connects 2 separate areas of our factory.
The first table (Table 1) has a field called prod_code which is a text field and this code (5 digit number) describes a manufactured product.
The next table (Table 2) also has a field called prod_code which is also a text field, is a different 5 digit number, and describes the same product but after packaging.
There is a 3rd table which I want to use to link both of these tables, but in table 3:
table 1. prod_code = table 3.item_code, and is a long integer. and table 2.prod_code = table3.item_code_prnt, also a long integer.
I need to be able to use table 3 to correlate data from tables 1 and 2.
I suspect I need to use Clng or similar but am unsure how to apply it.
Have been trying to construct an expression but continually get error (bracketing error, join mismatch etc, etc)
Any clues?
View 3 Replies
View Related
Feb 7, 2008
I have 2 tables. one (Data_Participant) has all of the data on individual participants. the other (Data_Main) has the data of how they participated per year. my Data_Participant table has a primary key (ParticipantID) which does not allow duplicates and the Data_Main table is setup w/ a non-primary key field (ID) which will allow dupes. these two fields are joined in my query with the Data_Participant.ParticipantID set to include all records and and only those records from the Data_Main.ID field where the records are equal.
to me, the join properties being setup like this would allow me to put any type of search criteria i would like under the Data_Main table fields and i would still get all of the Data_Participant's tables as a result, but only those from Data_Main that i had filtered.
ultimately, i'd like to see all of my Data_Participant data and only the Data_Main data that makes it through my filter/search criteria. am i not understanding how the join properties work?
View 5 Replies
View Related
Nov 20, 2007
Hi,
i've got a query that is linking 2 tables.
i'm having problems with the join properties.
basically from what i can understand, there are 3 options.
1. Where join field from both tables are equal
2. All records from table 1 and only those from table 2 where they match
3. All records from table 2 and only those from table 1 where they match
how do i go about having all records from both tables showing?
View 10 Replies
View Related
Jan 16, 2008
I have table1 with fields 'project', field1, field2, field3 and table2 with fields 'project', fieldA, fieldB, fieldC. I need a query that has all fields from table1 and only fieldA from table2. What kind of join property should it have in order for me NOT to have duplicates? 'project' field in both tables has the same values.
As always, any help is greatly appreciated. Thanks.
View 2 Replies
View Related
Oct 21, 2005
Hi
I posted this on the end of the audit trail thread but nobody was really looking at it. I have used the script for the audit trail, and when I start changing any of the records, it comes up with the error:
13 - Type Mismatch
When I ctrl - break, and debug, it highlights the last line of the script:
On Error GoTo Form_BeforeUpdate_Err
Call Audit_Trail(Me)
Form_BeforeUpdate_Exit:
Exit Sub
Form_BeforeUpdate_Err:
MsgBox Err.Number & " - " & Err.Description
Resume Form_BeforeUpdate_Exit
Anyone any ideas on what is happening?
View 6 Replies
View Related
Nov 8, 2006
Hi all,
I have a problem with the following piece of code:
Private Sub cmdCautare_Click()
Dim strSQL As String, strOrder As String, strWhere As String
'Select Case Me.cmbTipVersus
'Case 1
'If Me.cmbTipVersus = "" Then
strSQL = "SELECT tblDosare.DosarID, tblDosare.DenumireDosar, tblDosare.CodDosar, tblDosare.DataDosar, tblInstante.Localitate, tblStadiu.Data, tblStadiu.Stadiu FROM tblInstante INNER JOIN (tblDosare LEFT JOIN tblStadiu ON tblDosare.DosarID = tblStadiu.Dosar) ON tblInstante.InstantaID = tblDosare.Instanta"
strWhere = "WHERE"
strOrder = "ORDER BY DosarID"
If IsNull(Me.txtDenumire) Or Me.txtDenumire = "" Then
Else
strWhere = strWhere & "(DenumireDosar) Like '*" & Me.txtDenumire & "*'"
End If
If IsNull(Me.cmbStadiu) Or Me.cmbStadiu = "" Then
Else
strWhere = strWhere & "(DenumireDosar) Like '" & Me.txtDenumire & "*' & " And " & (Stadiu) Like '" & Me.cmbStadiu & "*'"
End If
DoCmd.OpenForm "frmRezultateCautare", acNormal
Forms!frmRezultateCautare!lstRezultate.RowSource = strSQL & " " & strWhere & "" & strOrder
'End If
'End Select
End Sub
And on this line strWhere = strWhere & "(DenumireDosar) Like '" & Me.txtDenumire & "*' & " And " & (Stadiu) Like '" & Me.cmbStadiu & "*'"
i have an error message type mismatch. If i do the search only with the first text box the code works hjust fine but if i make the search w.r. with the second control (combo box cmbStadiu) the error appears. If anyone can help i will appreciate it.
Thank you all!
View 4 Replies
View Related
Sep 13, 2004
I am persistently getting the "Error Number:13; Type Mismatch" with the code below.
Any help is greatly appreciated...
BTW, in the SQL string, i will like to have the wildcard as "*" but the VB Editor automatically changes it to " * "... can that be a problem??
Code:
Dim db As DAO.database
Dim qdf As DAO.QueryDef
Dim sqlsearch As String
Set db = CurrentDb
If Not QueryExists("Q_Paint") Then
Set qdf = db.CreateQueryDef("Q_Paint")
Else
Set qdf = db.QueryDefs("Q_Paint")
End If
sqlsearch = "SELECT M_Paint.* From M_Paint " & _
"WHERE M_Paint.Color_Number = '" * " & "Me.txb_pcn_colornumber" & " * "';"
qdf.SQL = sqlsearch
DoCmd.OpenForm "F_Display_Paint"
DoCmd.Close acForm, "F_Paint_Catcodesearch"
DoCmd.Close acForm, "F_Search_Paint"
View 2 Replies
View Related
Dec 29, 2005
WHy whould this be a type mismatch?
Dim strLABCHECK As Integer
strLABCHECK = CInt(StrComp(strSymbol, "(LAB)"))
If (Len(strSymbol) < 6 & Len(strSymbol) > 1 & strLABCHECK < 0) Then
...
End if
View 2 Replies
View Related
Jun 5, 2006
This is an Access 2000 question.
Now, I know what the error message is supposed to mean, despite my total newbie-ness. My table Product has p/k ProdID (autonumber, long integer) and my table Items has ProdID (number, long integer) as a f/k. It's a one-to-many relationship (each Item is only one kind of Product, but each Product may have multiple Items.) But when I try to run a query in Access, I get the "Type mismatch in expression" error. The only relationship is between a number and an autonumber as described above.
Does anyone know what might be going on?
View 2 Replies
View Related
May 26, 2005
hey,
can someone pls tell me why i get an Type mismatch in expression err with this code:
INSERT INTO tblACAD ( PROIZVAJALEC, TIP, DN, KOSOV )
SELECT tblsifrant.Proizvajalec, tblsifrant.Tip, tblsifrant.DN, tblsifrant.Kosov
FROM tblsifrant, tblACAD
WHERE (((tblsifrant.Sifra)=[tblACAD.TIP]) AND ((tblsifrant.DN)=[tblACAD.DN]) AND ((tblACAD.KOSOV)>0));
If i remove one criteria to get this code then there are no err, but thats not what i want:
INSERT INTO tblACAD ( PROIZVAJALEC, TIP, DN, KOSOV )
SELECT tblsifrant.Proizvajalec, tblsifrant.Tip, tblsifrant.DN, tblsifrant.Kosov
FROM tblsifrant, tblACAD
WHERE (((tblsifrant.Sifra)=[tblACAD.TIP]) AND ((tblACAD.KOSOV)>0));
I create this code in design view so all the names and tables are correct.
So does anyone have any ideas?
Thx
View 2 Replies
View Related
Dec 20, 2005
Hi all,
I'm using DB to run a small poker league, here's my setup.
Tables:
players - player_id (autonumber), player_name (text)
tourn - tourn_id (autonumber), venue (text), entry_fee (number, currency), tourn_date (date/time, medium date), n_entrants (number, integer<>0)
status - status_id (autonumber), player_name (from players table), tourn_id (from tourn table), position (number, integer<>0), winnings (number, currency)
I'm trying to create a query, that groups by player name, the count of tourn_id, victories (count of position=1), cash_prizes (count of winnings>0), sum of winnings, sum of entry_fee, net winnings (sum of winnings - sum of entry_fee)
With the help of someone else, I get this, but I keep getting error msg "type mismatch in expression"
SELECT P.player_name, Count(T.tourn_id) AS CountOftourn_id, Sum(S.winnings) AS SumOfwinnings, Sum(T.entry_fee) AS SumOfentry_fee, (SELECT Count(position) FROM status WHERE position =1
AND status.player_name= P.Player_Name) AS victories, (SELECT Count(winnings) FROM status WHERE winnings>0
AND status.player_name= P.Player_Name) AS Cash_prizes
FROM tourn AS T INNER JOIN (players AS P INNER JOIN status AS S ON P.player_name=S.player_name) ON T.tourn_id=S.tourn_id
GROUP BY P.player_name;
What's wrong with the above?
Thanks in advance
Raju
View 5 Replies
View Related
Jan 10, 2007
Ive been working at this problem for a while now and I can't figure it out. I have a table full of Work Orders, and on the form for inputing the Work Order data, there is a field for the date that the WO was received, and the date it is wanted. There is also a field that tells if this was a rush job (Yes/No) field.
I need to make a query that will grab all the rush jobs, and sort by how many days were between the date received and date wanted. This would be easy, just subtracting the dates, but I need to have it not include weekends and holidays. I found an algorithm to do that and it seems to work well. However, when I run the query, it gives me a "Data type mismatch in criteria expression." error. At this point, to debug it, I put in a message box to see if it processes any entries. It does process them one at a time, but once it gets to a certain point I get that error. I have checked all the dates, making sure they are all valid and they are. I'm just really stumped here. Here is the code for my query:
SELECT [Usable Orders].[AI Number], [Usable Orders].[District Name], [Usable Orders].[CCM Name], [Usable Orders].[8255 Received], [Usable Orders].[Date Wanted], [Usable Orders].Rush, WorkingDays2([8255 Received],[Date Wanted],[AI Number]) AS [Working Days]
FROM [Usable Orders]
GROUP BY [Usable Orders].[AI Number], [Usable Orders].[District Name], [Usable Orders].[CCM Name], [Usable Orders].[8255 Received], [Usable Orders].[Date Wanted], [Usable Orders].Rush
HAVING ((([Usable Orders].Rush)="Yes") AND ((WorkingDays2([8255 Received],[Date Wanted],[AI Number]))<=10));
and here is the code for my WorkingDays2 (counts all working days excluding holidays) the AINumber field I put in for debugging purposes to see which entries were being processed.
Public Function WorkingDays2(StartDate As Date, EndDate As Date, AINumber As String) As Integer
'................................................. ...................
' Name: WorkingDays2
' Inputs: StartDate As Date
' EndDate As Date
' Returns: Integer
' Author: Arvin Meyer
' Date: May 5,2002
' Comment: Accepts two dates and returns the number of weekdays between them
' Note that this function has been modified to account for holidays. It requires a table
' named tblHolidays with a field named HolidayDate.
'................................................. ...................
On Error GoTo Err_WorkingDays2
Dim intCount As Integer
Dim rs As Object
Dim stSql As String
Dim con As Object
Dim Message As String
If StartDate > EndDate Then
MsgBox "Start Date is After End Date"
WorkingDays2 = -1
GoTo Exit_WorkingDays2
End If
stSql = "SELECT [HolidayDate] FROM tblHolidays"
'StartDate = StartDate + 1
'To count StartDate as the 1st day comment out the line above
intCount = 0
Set con = Application.CurrentProject.Connection
Set rs = CreateObject("ADODB.Recordset")
rs.Open stSql, con, 1 ' 1 = adOpenKeyset
'MsgBox "Today is " & Weekday(StartDate) & ", " & StartDate & "Opening AI Number is " & AINumber
Do While StartDate <= EndDate
rs.Find "[HolidayDate] = #" & StartDate & "#"
If Weekday(StartDate) <> vbSunday And Weekday(StartDate) <> vbSaturday Then
If rs.EOF Then
intCount = intCount + 1
' Message = Message & " and today is a work day."
End If
Else
' Message = Message & "and today is not a work day."
End If
' MsgBox Message
'rs.MoveNext
StartDate = StartDate + 1
Loop
'MsgBox "Closing AI Number " & AINumber & "Count is " & intCount
'MsgBox "After Loop count is " & intCount & " and today is " & StartDate
WorkingDays2 = intCount
'MsgBox "Date is " & StartDate & "AI Number is " & AINumber & " and there were " & intCount & " days."
Exit_WorkingDays2:
Exit Function
Err_WorkingDays2:
Select Case Err
Case Else
MsgBox Err.Description & "Start date is " & StartDate & "End Date is " & EndDate
Resume Exit_WorkingDays2
End Select
End Function
View 1 Replies
View Related
Jun 4, 2007
Hi
Hope someone can help
I have a query that is trying to match two tables, one in MSSQL2000 and the other in Access 2003. The matching field in MSSQL is a Text field and in Access the field is a long integer. When I try to run the query it gives a Type Mismatch error.
I've tried all the functions that I can see to convert either of the fields data types but to no avail.
Does anyone know of a way to force a match?
Thanks
Mark
View 2 Replies
View Related
Sep 6, 2007
I don't understand why this won't work.
I have a date field in a table. The default value for this field is Date().
The data type is Date/Time
The field is called Import Date.
Here is what I am trying to do in a query:
Month Imported: DatePart('m', 'Import Date')
I am getting a data type mismatch, and I don't see how.
If I put this:
Month Imported: DatePart('m', Date())
It works fine.
View 8 Replies
View Related
Jan 23, 2008
I am querying results using Access 97(Yes its old and no my company is not willing to upgrade.....:confused:). Anyhow, I am connecting to a corporate database that has two tables I am querying that should be joined on one field (wmg.wmgtk01_tnk.sys_i = wmg.wmgwo04_halfleg_actl.tnk_sys_i). I am running into a problem with these fields because they have been defined differently by my IT department. The "sys_i" field is a NUMBER of length 5, while the "tnk_sys_i" field is a NUMBER of length 20. Is there a way that I can trick Access into joining these fields even though they do not match? I am currently getting a "Data Type Mismatch" error when I attempt to create this join.
Thanks in advance for your help!
View 3 Replies
View Related
Jun 3, 2006
Hi,
I'm using the function found here http://support.microsoft.com/?kbid=210236to to repeat the values from the previous record automatically.
It works fine for one single form but I keep getting "type mismatch" when applying it to a subform within another subform within a main form.
Any ideas?
Thanks, in advance, for any help offered.
Tony
View 1 Replies
View Related
Feb 25, 2005
Hi I'm doing some work on an open source intranet for a friend and I've come unstuck with data types I guess.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'str'
D:SITESEXTRANETCLIENTS../includes/connection_open.asp, line 104
I added a date field and now get this error.
The process is as follows:
add user - client-add.asp
client-add-processor.asp (& siteSQL.asp include)
the error occours on submiting the original form page
new feilds:
Code:<form method="post" action="client-add-processor.asp" name="strForm" id="strForm">..............edited...............<tr><td><b class="bolddark"><%=dictLanguage("HostingPeriod")%>:</b></td><td><input name="HostingPeriod" size="20" value="<%=Session("HostingPeriod")%>" class="formStyleShort" onkeypress="txtDate_onKeypress();" maxlength="10"><a href="javascript:doNothing()" onclick="openCalendar('<%=server.urlencode(date())%>','Date_Change','HostingPeriod',150,300)"><img border="0" src="<%=gsSiteRoot%>images/calendaricon.jpg" onmouseover="this.style.cursor='hand'" WIDTH="16" HEIGHT="15"></a></td></tr><tr><td><b class="bolddark"><%=dictLanguage("DomainPeriod")%>:</b></td><td><input name="DomainPeriod" size="20" value="<%=Session("DomainPeriod")%>" class="formStyleShort" onkeypress="txtDate_onKeypress();" maxlength="10"><a href="javascript:doNothing()" onclick="openCalendar('<%=server.urlencode(date())%>','Date_Change','DomainPeriod',150,300)"><img border="0" src="<%=gsSiteRoot%>images/calendaricon.jpg" onmouseover="this.style.cursor='hand'" WIDTH="16" HEIGHT="15"></a></td></tr>
To client-add-processor.asp
Code:sql = sql_UpdateClient( _session("Name"), _session("Rep"), _session("Client_Since"), _session("Standard_Rate"), _session("Address1"), _session("Address2"), _session("City_State_Zip"), _session("LiveSite_URL"), _session("DevSite_URL"), _session("Contact_Name"), _session("Contact_Phone"), _session("Contact_Email"), _session("Contact2_Name"), _session("Contact2_Phone"), _session("Contact2_Email"), _Active, _session("client_id"), _session("ClientFolder"), _session("HostingPeriod"), _session("DomainPeriod"), _session("Notes"), _session("WebFolder"))'response.write(sql)Call DoSQL(sql)%><!--#include file="../includes/main_page_open.asp"-->
includes/main_page_open.asp
Code:Function MediumDate(str) Dim aDay Dim aMonth Dim aYear aDay = Day(str) -line 104 'aMonth = Monthname(Month(str),TRUE) aMonth = Month(str) Select Case aMonthCase 1aMonth = "Jan"Case 2aMonth = "Feb"Case 3aMonth = "Mar"Case 4aMonth = "Apr"
SQL
Code:Function sql_InsertClient(Client_Name,Rep_ID,Active,Client_ Since,Standard_Rate,Address1,Address2, _City_State_Zip,LiveSite_URL,Devsite_URL,Contact_Na me,Contact_Phone,Contact_Email,Contact2_Name, _Contact2_Phone,Contact2_Email,HostingPeriod,Domain Period,Notes)dim sqlsql = "INSERT into tbl_clients (client_name,rep_id,active,client_since,standard_r ate,address1," & _"address2,city_state_zip,livesite_url,devsite_url,c ontact_name,contact_phone,contact_email,contact2_n ame," & _"contact2_phone,contact2_email,hostingperiod,domain period,notes) VALUES (" & _"'" & Client_Name & "'," & _Rep_id & "," & _Active & "," & _"" & DB_DATEDELIMITER & MediumDate(Client_Since) & DB_DATEDELIMITER & "," & _Standard_Rate & "," & _"'" & Address1 & "'," & _"'" & Address2 & "'," & _"'" & City_State_Zip & "'," & _"'" & LiveSite_URL & "'," & _"'" & DevSite_URL & "'," & _"'" & Contact_Name & "'," & _"'" & Contact_Phone & "'," & _"'" & Contact_Email & "'," & _"'" & Contact2_Name & "'," & _"'" & Contact2_Phone & "'," & _"'" & Contact2_Email & "'," & _"" & DB_DATEDELIMITER & MediumDate(HostingPeriod) & DB_DATEDELIMITER & "," & _"" & DB_DATEDELIMITER & MediumDate(DomainPeriod) & DB_DATEDELIMITER & "," & _"'" & Notes & "')"sql_InsertClient = sqlend Function
Thanks in advance for any pointers.
View 3 Replies
View Related
Mar 1, 2005
I've been studying unbound for quite awhile and i've build to forms but i seem to get stumped with datatype mismatch. I've tried everything that i would possibly know. I guess i'm just to new in access to try this but it's the only thing that works for what i'm trying to do can some1 please provide me some assistance. I've attached both forms. YOUR HELP WILL BE GREATLY appreciated.
Now the problem, when adding or editing info i get datatype mismatch -21233 some number of that sort....
Thanks...
Eddie...
View 14 Replies
View Related
Jun 13, 2005
hi,
i'm trying to locate a record by id using a recordset clone. when i debug the code, i get a "type mismatch" error...
what am i doing wrong??/
here is the code:
Code:Dim rsCur As RecordsetDim strRecord As StringDim Bookmarkstr As StringstrRecord = Me.List26.ValueSet rsCur = Me.RecordsetClonersCur.Find "id =" & strRecord Bookmarkstr = rsCur.BookmarkMe.Bookmark = Bookmarkstr
any ideas??
thanks
*j
View 4 Replies
View Related
Aug 1, 2006
Dear All:
I am trying to print letters from access using a command button. It works well, but when I try to print the displayed record, I get "Data type mismatch in criteria expression".
The primary key is a 9-digit number where some have a leading zero. I have made this as text so I do not loose the leading zero.
Here is the code when the command button is pressed:
Private Sub Command1315_Click()
Dim strWhere As String
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print" _
, vbInformation, "Select a Record"
Else
'The Student ID Number is the name of the Primary Key
strWhere = "[STUDENT_ID] = " & Me.[STUDENT_ID]
DoCmd.OpenReport "HONORS_LETTER", acViewPreview, , strWhere
End If
End Sub
Thanks for all the help.
Dion
View 1 Replies
View Related
Apr 12, 2006
I don't understand why I'm getting this message.
I have a form that is based on a parameter query. The user inputs an item number and the form opens in edit mode. The user clicks the "duplicate" command button and then changes the item number. I've incorporated GHudson's "A Better Mouse Trap" logic and when clicking "save" I get the type mismatch error.
I don't understand why Access is not returning the 3022 duplicate entry error.
When I click "debug" Access highlights the line as shown below:
Err_bSave_Click:
If Err = 2046 Then 'The command or action Undo is not available now
Exit Sub
Else
MsgBox Err.Number, Err.Description
Resume Exit_bSave_Click
End If
End Sub
Any and all assistance is appreciated.
Randy
View 6 Replies
View Related
Jul 22, 2005
Hi,
I'm having some problems with a simple query and it's driving me nuts. The invoice numbers in our system have hyphens in them, and I'm trying to find invoice numbers whose part before the hyphen matches a number I enter. Here's my SQL:
SELECT dbo_NIHB_ClaimLog.InvoiceNum, Left([InvoiceNum],InStr([InvoiceNum],"-")-1) AS InvoiceNumLeft
FROM dbo_NIHB_ClaimLog
WHERE (((dbo_NIHB_ClaimLog.InvoiceNum) Is Not Null) AND ((Left([InvoiceNum],InStr([InvoiceNum],"-")-1))=23316));
I'm getting a "Data Type Mismatch In Criteria Expression" error, and I can't figure out why. I've wrapped a Clng() around the Left() function, but that doesn't help either.
Am I missing something here?
View 5 Replies
View Related
Jun 15, 2006
I am trying to do a basic query and I keep getting a "Type Mismatch" error and the query will not run. If I only do a query on one table, it works no problem so I know it must be related to my Join between tables.
For the two tables that are joined (it is one-to-many)- the first table is a clients table and I created a field called ClientNumber that is an AutoNumber. The second table is called TrainingRequests. This will store the training requests for each client and each client can have multiple training requests. I created a field called ClientNumber in it as well (this is what field I linked the tables by). But I set it to text instead of AutoNumber.
Is there a way to do a query with the two tables? Or will I have to change something in table design? I already have some data in the tables so I am not sure what direction to take.
Thanks for any help someone can provide. It would be greatly appreciated.
View 1 Replies
View Related
Aug 20, 2007
I have two tables, one has the autonumber column, sysid, and then in the process of updating the database via forms the sysid from one table is placed in another (text format). I thought I could use that to link the tables for queries, but I am running into a data/type mismatch error.
Any ideas to get around this?
Thanks!
View 2 Replies
View Related
