The record source error problem MS Access 2013 (1 Viewer)

LivingColor

New member
Local time
Yesterday, 16:21
Joined
Jan 13, 2018
Messages
3
Hi friends

I am getting errors for the form after inputting the following on row source property sheet. I am new to MS Access 2013

SELECT[Query1].[MoDayYear],[Query1].[Filename],[Query1].[Year&Time],[Query1].[Size] FROM Query1 ORDER BY [MoDayYear];

The error I get is SEleCT[Query1].[MoDayYear],[Query1].[Filename],[Query1].[Year&Time],[Query1].[Size] FROM Query1 ORDER BY [MoDayYear]; specified on this form or report does not exist. Not sure what the problem is


Kind Regards

LivingColor
 

isladogs

MVP / VIP
Local time
Today, 00:21
Joined
Jan 14, 2017
Messages
18,221
Hi & welcome to AWF

You need a space after SELECT
 

LivingColor

New member
Local time
Yesterday, 16:21
Joined
Jan 13, 2018
Messages
3
Thank you so much ridders. It now works!

LivingColor
 

Users who are viewing this thread

Top Bottom