Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

referencing table.field in query by design

Status
Not open for further replies.
sksbizkit

sksbizkit

Programmer
Jan 11, 2007
9
US
Hey everybody i'm trying to reference a table field directly in a query by design with this code:

[mytable]![myfield]

there is only one row and will always be one row.

Can this work??
 
Sort by date Sort by votes
Have you added the table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
384
SkipVought
S
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
318
dhookom
dhookom
teach314
  • Locked
  • Question
question re Description in Table Design 1
Replies
2
Views
131
teach314
teach314
BLSguy
  • Locked
  • Question
Referencing Totals from One Table in the Fields of Another
Replies
2
Views
117
BLSguy
BLSguy
MattGreer
  • Locked
  • Question
Is it "bad" to have a Lookup table/query in a table? 2
Replies
4
Views
150
MattGreer
MattGreer

Part and Inventory Search

Sponsor

Back
Top