Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Hello all,
I have a big problem, i need to create a report in access that contains the results from a query.
The query can only return a result if there is something input for the value. How do i make this query ?? Help !!
[Edited on 12-07-2007 by Neo]
[Edited on 12-07-2007 by Neo]
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Help, need it finished by tomorrow night !
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
I'm not clear - you only want to run the report if you have user input?
Give me some sample data / queries.
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Ok an example
I need to create a report (Letter) that looks up the name of a person, and then 2 fields of information (Job Function and Standard Limits). Each user has more than 1 job function, however i want the final report to ignore any job function headings where there is no data in the standard limits field.
Hope thats clear.
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
Give me table structures.
I'm guessing you want an inner join or some sort and perhaps a limit in there somewhere, but I'm still not clear what you want.
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
OK update,
I guess its something to do with null values, however i can't make it work.
When i use "is not null" it gives no results.....
any help ?
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Table Structures....You really have lost me somewhat, i google it and its asking to use asp...I'm new to this
I know about inner joins and i think i'm just being stupid. you probably think so to.
I think i have the idea of what to do, just going to put it into play...
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
Show me some data!!
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Its finished now, rang my old college lecturer and he explained how to do it over the phone.
You were right Ian it was an inner join using 2 queries, and i was doing it totally wrong for how it was meant to work...i feel like a fool 
Thanks for your help anyway Ian 
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
No worries.
|
