query returns table name with field name (1 Viewer)

DevAccess

Registered User.
Local time
Today, 01:43
Joined
Jun 27, 2016
Messages
321
Hello

I have table Name "A" as master table, other lookup tables are "B","C", "D", "E" and they are joined using primary and foreign key relationship.

Now I am creating a query manually using query design to get required field from lookup table, but when I am creating a query it returns couple of fields from lookup table with table name, for example tbl_a.firstname

Can anybody please help me why this is happening this is not happening with all the fields from specific table but for few fields only.

Thanks
DJD
 

bob fitz

AWF VIP
Local time
Today, 08:43
Joined
May 23, 2011
Messages
4,717
Perhaps you have a field called "firstname" in more than one table.
 

DevAccess

Registered User.
Local time
Today, 01:43
Joined
Jun 27, 2016
Messages
321
Yes that was it Bob thanks for your kind help..

Can you please help me in word document header case,

I dont want header on the first page, in other word I want header starting from second page of word document, here is the code I tried but it did not worked.

With wddoc
For i = 1 To .Sections.Count
With .Sections(i)
Set MyRange = .Headers(wdHeaderFooterFirstPage).Range
MyRange.Text = ""
Set MyRange1 = .Headers(wdHeaderFooterPrimary).Range
MyRange1.Text = "ORDERS: " & rs.Fields("Order Number").Value & vbTab & "Centre" & vbTab & Format(Date, "DD MMM YY") & vbTab
End With
Next i
End With
 

bob fitz

AWF VIP
Local time
Today, 08:43
Joined
May 23, 2011
Messages
4,717
I don't think I can help you with this. However, you might like to try:
For i = 2To .Sections.Count
 

Users who are viewing this thread

Top Bottom