microsoft access

  • Thread starter Thread starter brady33
  • Start date Start date
B

brady33

I am a fairly new user to access. I made some correction in a query. Now
whenever I save a query I can open it back up but cannot get into the design
view. When I try to open the query in design view it gives me the message -
invalid use of null.
 
I am a fairly new user to access. I made some correction in a query.
Now whenever I save a query I can open it back up but cannot get into
the design view. When I try to open the query in design view it gives
me the message - invalid use of null.
Click to expand...

Open in SQL view and see what the query looks like. you may have an = null
when you should have is null. The query may work, but the designer gets
confused.

Without seeing the actual query, that is about all I can offer you.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************
 
Try posting in a newsgroup for Microsoft Access. This is a newsgroup for
general questions about Microsoft ".NET" programming.
 
Back
Top